As we move on to 12.2 and 19c we're seeing more instances where simple schema export/import migrations are missing objects on the target database. If you do object counts after a simple schema migration... Or see something like this pop up in your impdp logs:…
I recently came across a legacy database that was using Oracle FLOAT datatype for Primary and Foreign Keys. As the database needed some attention I was asked to get data types in order and get rid of the FLOATs in favor of NUMBER data types.
I recently fielded a question about getting data out of Oracle quickly. Without much detail on the systems involved here is my answer: I need to migrate data from Oracle to MySQL quickly (in less than 1 day). What are my options? Oracle does not…
If you have a lot of LOB data to move around with Oracle import/export utilities this might help you out. The default for the COMMIT parameter is No. COMMIT=N : For tables that have a LOB column, commit is performed after loading each table This…