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!

Tables in BIN

258524Jan 9 2006 — edited Jan 9 2006

Hi All,

I imported some of the tables from backup, First I imported tables from backup set 1, then I disables the constraints of some tables and truncated the data from them, after that I import the data in these tables from backup set 2,

Now the problem is, during import it has created some tables with name like BIN$Oi444KK+RsqAKHD1acjiDA==$0 these tables are empty and while I try to drop these tables the message displayed is
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

So are these tables really needed for correct functioning of database, if not how can we remove them, they are around 18 tables.

Any help will be highly appriciated. Best Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2006

Added on Jan 9 2006

#general-database-discussions

3 comments

479 views