Re: Migration to MySQL

nendee wrote:
> We've been trying to convert a MySQL database to Oracle. As it
> stands, the Oracle Migration Workbench is a complete no starter - some
> of the data columns aren't converted correctly, etc.
>
> So, we created a "safe" version of the DDL and would like to create
> control files directly from this DDL. Does anyone know if this is
> possible?

There is no way to use SQL*Loader to do what you are trying to do. Also, it would be best practice to not build generic tables in Oracle that are identical with those you had in MySQL without first determining whether they are the best solution for what you are doing.

My recommendation would be to hand-write, yes I know it is a pain, your DDL and execute it as a script that also builds constraints and indexes. Then create a control file, and yes again by hand as I know of no tool that will do it for you, and run SQL*Loader from the command line.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org