Skip to Main Content
Forums

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!

Automatic Purging of Recyclebin

753645Feb 17 2010 — edited Feb 17 2010
Hi,

Anybody can tell me when recyclebin is purged automatically in Oracle 10g. I was trying to insert some records using a database link in production DB, I am also using an audit table to track all DDL operations by using DDL trigger). At the time of insert, one drop statement is getting recorded in the DDL audit table for an object in recyclebin; this drop command is executed by SYS user.

Could someone share idea about it.

Thanks in Advance,
Sree.
This post has been answered by Zeeshan BaiG on Feb 17 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2010
Added on Feb 17 2010
#general-database-discussions
2 comments
2,908 views