hpuxrac wrote:
> 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?
By control file the OP is asking about SQL*Loader control files.
--
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
Received on Fri Mar 16 2007 - 15:59:41 CDT
