Skip to Main Content

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!

show recyclebin not showing anything after table drop

819300Dec 21 2010 — edited Dec 22 2010
currently testing flashback table but i am wondering why recycle bin not showing anything after drop? i check the parameter and the value is on. now it made me think is there a relative relationship between recycle bin, undo retention and undo tbs size?

if so why is it not working on an undo_retention= 900, undo tbs size= 100MB and the table i dropped consist of only 1 column and 3 rows data type number, which is particulary small. is there something i need to set further???

db version is 10.2.0.1.0

Thanks!
This post has been answered by Aman.... on Dec 21 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2011
Added on Dec 21 2010
8 comments
1,633 views