Table import fails in Oracle with ORA-30657
Brought to you by:
acarboni
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.