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!

Disable recyclebin for a tablespace

299008Nov 10 2005 — edited Nov 10 2005

Hi,

I want to drop a number of tables but don't want them to go in the recycle bin. I know I can use the purge option of the drop table command.

But can I define a tablespace so that the recycle bin is disabled. Thus all dropped tables are purged immediately (without the purge option of the drop table command).

I actually want this as we have scripts to run on 9i + 10g databases and I don't want to create specific ones for each DB.

thx,
Steve.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2005

Added on Nov 10 2005

#general-database-discussions

4 comments

719 views