Menu

#84 Table import fails in Oracle with ORA-30657

V 3.9
open
JDBC (13)
5
2008-07-14
2008-07-14
Rob Decker
No

If a you attempt to import tables and one of the tables is an external organized table the import fails with the exception "ORA-30657: operation not supported on external organized table". Similiarly, if the recylce bin is enable in Oracle 10g there are table whose name starts with bin$ and an exception is thrown during import. The import should be more graceful when exceptions are thrown, allowing the import to complete, perhaps logging a list of failed tables/entities, rather than just ending off on the error and importing nothing.

For the recycle bin table you can purge the recycle bin:

purge recyclebin

as a workaround.

Discussion


Log in to post a comment.

MongoDB Logo MongoDB