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!

Database Copy Doesn't find tables for moving data

939790May 25 2012 — edited Sep 13 2012

I'm running SQL Dev 3.1.7 on a Win7-64 PC against Oracle 11g. Using the Database Copy function to move and update tables from one instance to another. The application seems to work fine, creating all of the tables, but in the script when it tries to move the data, for some tables it fails as follows:

Moving Data for object MY_TABLE_NAME
Unable to perform batch insert.
MY_TABLE_NAME ORA-00942: table or view does not exist

Earlier in the script it dropped and then recreated the table in the target instance. The table does exist in the source instance. This occurred for 24 tables out of 105.

Any ideas what is going on?

Edited by: user12200489 on May 25, 2012 9:47 AM