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…