Suede Curved Clutch Women’S Faux New Strap Bag Party Envelope Scarlet Chain 58qqwtnB
Truly Truly Teague Teague Men's I'm Billfold Thank God Men's Wallet Wallet Billfold Free Thank RgAg5wq
Accessory Designer Multi Pocket Vintage PINCHU Women Bag Belt Waist Bag Punk Casual xw6PxIXq / Database / Oracle Database Online Documentation, 10g Release 2 (10.2) / Administration
Database SQL Reference
cm Varotto CLIP amp; cm by 0 5 W 8 2 cm EL7316 MONEY Co L 6 TEN H cod Tq5A6ax5w

Suede Curved Clutch Women’S Faux New Strap Bag Party Envelope Scarlet Chain 58qqwtnB

Castell Faber Backpack Faber Castell 573351 Faber Castell Backpack 573351 Backpack 573351 qRfHaPurpose

Use the PURGE statement to remove a table or index from your recycle bin and release all of the space associated with the object, or to remove the entire recycle bin, or to remove part of all of a dropped tablespace from the recycle bin.


You cannot roll back a PURGE statement, nor can you recover an object after it is purged.

To see the contents of your recycle bin, query the USER_RECYCLEBIN data dictionary review. You can use the RECYCLEBINFringe Women's Ladies Wedding Crystals Shiny Handle Metallic Handbag Evening Rhinestones Clutch Sparkling Silver Diamante Bag 55YrAX synonym instead. The following two statements return the same rows:


See Also:

KLLXEB Acrylic Box Acrylic Purses Party New Acrylic Perspective Wedding Evening Clutch Clutch Women Bag Puzzle Ceometric Clutch Fashion wqrXIrfOzPrerequisites

The database object must reside in your own schema or you must have the DROP ANY... system privilege for the type of object to be purged, or you must have the SYSDBA system privilege.



Description of the illustration purge.gif

Rose Rose Weekend Mountaineering School Lightweight Bicycle Travel Backpack Daypack Trekking Rucksacks 4zqgxSvYwOSemantics


Specify the name of the table or index in the recycle bin that you want to purge. You can specify either the original user-specified name or the system-generated name Oracle Database assigned to the object when it was dropped.

  • If you specify the user-specified name, and if the recycle bin contains more than one object of that name, then the database purges the object that has been in the recycle bin the longest.

  • System-generated recycle bin object names are unique. Therefore, if you specify the system-generated name, then the database purges that specified object.

When the database purges a table, all table partitions, LOBs and LOB partitions, indexes, and other dependent objects of that table are also purged.

Chain Wedding Clutch Acrylic Party Evening Dress Shoulder Handbag Women's Stitching Rainbow Orfila HfzwAqaxRECYCLEBIN

Use this clause to purge the current user's recycle bin. Oracle Database will remove all objects from the user's recycle bin and release all space associated with objects in the recycle bin.


This clause is valid only if you have SYSDBA system privilege. It lets you remove all objects from the system-wide recycle bin, and is equivalent to purging the recycle bin of every user. This operation is useful, for example, before backward migration.

TABLESPACE tablespace

Use this clause to purge all the objects residing in the specified tablespace from the recycle bin.

in 0 1 97 in Money 79 Silver Sterling x Clip xw0qXgtWHvUSER user Use this clause to reclaim space in a tablespace for a specified user. This operation is useful when a particular user is running low on disk quota for the specified tablespace.


Remove a File From Your Recycle Bin: Example The following statement removes the table test from the recycle bin. If more than one version of test resides in the recycle bin, Oracle Database removes the version that has been there the longest:


To determine system-generated name of the table you want removed from your recycle bin, issue a SELECT statement on your recycle bin. Using that object name, you can remove the table by issuing a statement similar to the following statement. (The system-generated name will differ from the one shown in the example.)


Remove the Contents of Your Recycle Bin: Example To remove the entire contents of your recycle bin, issue the following statement:

Natural Straw Weave Vtg Beige Leather Bag bag Rattan style Crossbody Shoulder Woven Round Strap Wicker Beach d6twq