Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change column name on migration from MS SQL Server?

418487Apr 5 2004

Hi,
I'm moving data from MS SQL Server 2000 to Oracle 9.2.0.1.0 using Oracle Migration Workbench 9.2.0.1.7. This is a great tool.

My source database has longer column names than Oracle allows. When OMWB creates the Oracle model, it truncates, sometimes leading to 2 columns with the same name. Is there any way to edit the Oracle model before the new db is created in order to change column names?

(For example, the MS SQL Server db has columns such as
one_very_long_table_name_with_a_very_long_column_name1
one_very_long_table_name_with_a_very_long_column_name2

and OMWB generates
one_very_long_table_name_with_a_very_long
for both

I'd like to create something like
column_name1
column_name2
before the model is used.

Thanks,
Mitch

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2004

Added on Apr 5 2004

#database-and-application-migrations

0 comments

313 views