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
purge command
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
purge command
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
dba_recyclebin or
user_recyclebin view.
Example: The following will remove
table_name from the
recycle bin.
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
examples:
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:
purge recyclebin;
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.
The
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.
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
