SQL Developer

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!

"Copy To Oracle" failed if column sequence is different

942932Jun 11 2012 — edited Jun 13 2012

Hello,

I am trying to use the "Copy to Oracle" function to copy data from MSSQL 2008 to Oracle 11g. Since I already go the table created on Oracle and thus, I only need to migrate the data.

But I realize that, the copying failed, due to the column sequin between source and destination is different.

E.g. Table A on MSSQL has the column (id, phone, address) but the same table on Oracle is created in the order of (id, address, phone)

It seems to me that the data copying is done with column_id, instead of column_name.

What's your suggestion to get around with the issues? I would take re-creating the table as the last resort as there are like hundreds, if not thousands of tables I am talking about.

Many thanks!

ronnie

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2012

Added on Jun 11 2012

#sql-developer, #sqldeveloper

2 comments

387 views