Show Me
 

Freeing Space

Previous previous|next Next Page
Objects that are dropped are not completely removed from the database but instead are moved to the recycle bin. The recycle bin is actually a data dictionary table containing information about dropped objects. Dropped tables and any associated objects (such as indexes, constraints, nested tables, and so on) are not removed and still occupy space. They continue to count against user space quotas until specifically purged from the recycle bin or (an unlikely situation) until purged by the database because of tablespace space constraints.

Sheila dropped some objects earlier. She now wants to free up the space used by these objects. Watch Sheila remove these objects permanently from the recycle bin.

Launch Demonstration

Show Me and Try It