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!

recycle bin space management...

knowledgespringSep 23 2008 — edited Sep 25 2008
Hi,

is recycle bin uses default tablespace entire free space or the space used by tablesspace earlier and freed at moment..
for example: If my tablespace total size size 1000mB at moment its size is 300mb , does it mean recycle bin uses 700MB or recycle bin uses the space emptied by drop or delete operation on user which makes tablespace size go less than 300GB. if tablespace is autexetensible and there is 10GB or unlimited, does it mean that recycle bin uses all the space or only space which was used by tablespace earlier and emptied at moment??

can you please one provide me information on this , thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2008
Added on Sep 23 2008
4 comments
1,890 views