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!

Temporary tables are getting created, name starting with BIN$.....

665832Oct 17 2008 — edited Oct 17 2008

Hi,

I am using Oracle 10.2 and am experiencing an issue that doing some operations on existing tables, some temporary tables are getting created starting with BIN$.

For ex: BIN$HULdSlmnRZmbCXAl/pkA9w==$0

But I dont see these tables in the database after two or three days. I found that these temporary tables are a replica of existing tables and these contain only the table structure but not the data. I even not able to drop them from database.

Can anyone throw some pointers on this?

Thanks and Regards,
Siva

This post has been answered by JustinCave on Oct 17 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2008

Added on Oct 17 2008

#general-database-discussions

6 comments

1,175 views