Question: I want to delete objects from my
recycle bin. How is this accomplished?
Is there an easy
way to purge these objects?
Answer: Using the
to purge recycle bin objects is a fairly straightforward process.
The user intending to use the
purge command must
either have the drop any system privileges for the
object(s) they intend to purge from the recycle bin, or the object
must belong to that user's schema.
If you decide that you are never going to restore an item from
the recycle bin, the purge statement will remove the items
and their associated objects from the recycle bin and restore their
storage space. When you use the Oracle
to purge a table, you can use the name that the table is known by in
the recycle bin or the original name of the table. If you use
the user-defined name of the table, and there are multiple tables
with the same name, then the purge command will purge the
objects with that name. This name can be retrieved by querying the
Example: The following will remove
table_name from the
purge table table_name;
You can use
the purge command to purge all the objects in the recycle
bin that are from a specified tablespace or only the tablespace
objects belonging to a specified user, as shown in the following
purge tablespace example;
purge tablespace example user oe;
Users can purge the recycle bin of their own objects and
release space for objects by using the following statement:
If you have the sysdba privilege, then you can purge
the entire recycle bin by specifying dba_recyclebin,
instead of recyclebin in the previous statement.
purge command is useful for
removing items for which you will have absolutely no use in the
future. Use the Oracle purge command to reclaim space
that is currently not being used gainfully by the recycle bin.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.