Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Migration to MySQL
On Mar 16, 2:41 pm, "nendee" <krish.dasgu..._at_gmail.com> 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?
I don't know exactly what you are trying to ask.
Control files are part of the oracle database architecture.
They don't have a clear relationship to creating DDL ( create table, create index etc ) for moving applications into oracle.
You put DDL commands into a "sql" file ( aka "my_oracle_scheme_definitions.sql" ) and have them executed by sqlplus ... is this what you are asking about? Received on Fri Mar 16 2007 - 14:11:29 CDT