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!

Is purging recyclbe bin safe ?

flying_penguinJan 21 2016 — edited Jan 21 2016

RDBMS Version: 11.2.0.4

Platform : Oracle Linux 6.5

Several of our Prod DBs have recyclebin enabled and we have noticed that there are several objects at schema level recycle bin and DB level recycle bin.

Question1. Is it safe to purge recycle bin (schema level and DB level) in production ? Apart from the fact that I cannot use FLASHBACK DROP feature, are there any other risks ?

Question2. If I purge DB level recyclebin, it will cover schema level recyclebins too . Right ?

This post has been answered by John Stegeman on Jan 21 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2016

Added on Jan 21 2016

#general-database-discussions

5 comments

1,421 views