How does a DBA clear objects from a recyclebin of another user in an Oracle database ?...It can be done in one of the three ways listed below.
* SQL> select owner,OBJECT_NAME,ORIGINAL_NAME,TS_NAME from dba_recyclebin; OWNER OBJECT_NAME ORIGINAL_NAME TS_NAME --------- ------------------------------ ----------------- ---------- USER1 BIN$b5VRkexOdOjgRAADurN2OQ==$0 TABLE1 TBL_SPACE USER1 BIN$b5VRkexNdOjgRAADurN2OQ==$0 TABLE2 TBL_SPACE USER1 BIN$b5VRkexMdOjgRAADurN2OQ==$0 TABLE3 TBL_SPACE USER1 BIN$b5VRkexLdOjgRAADurN2OQ==$0 TABLE4 TBL_SPACE USER1 BIN$b5VRkexJdOjgRAADurN2OQ==$0 TABLE5 TBL_SPACE* http://oracleandunix.blogspot.com/2010/11/clearing-recyclebin-in-oracle-database.html more such articles on oracleandunix.blogspot.com ______________________________________ Get 3 GBs of online storage where you can dump all your files which can appear both Public / Private to others and you can access them anywhere online. Even uploading the files is easier, does not take much time - you can upload files whilst you are working online on something else. Follow the link pasted below. https://www.dropbox.com/referrals/NTQ5NDA0Mjk -- You received this message because you are subscribed to the Google Groups "GTA DBA" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/gtadba?hl=en.
