The interactions in this eCourse require Javascript to be enabled.
Freeing Space
previous|next
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.