Re: Oracle generated tables in 10g?

> Does anyway know why does Oracle do that, and what can I do to prevent these
> tables from being generated?

This is a new feature in 10g called the Recycle Bin. When you drop a table, it isn't removed automatically. Instead, it goes to the recycle bin. You can clear out the recycle bin if you wish. Please read the docs on this new feature.

And you can't disable this automatic feature. But you can use the PURGE option on the DROP TABLE clause to stop that one table from ending up in the recycle bin.

Personally, I'd like to see an initialization parameter to disable the recycle bin. By that's just my opinion.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"