Purge Recyclebin(What is dba_recyclebin.can_purge?) [message #533628] |
Wed, 30 November 2011 23:28 |
prejib
Messages: 126 Registered: March 2009 Location: India
|
Senior Member |
|
|
Hi
Can I Purge all the items from dba_recyclebin without checking any other details ? Also what is meant for the column - dba_recyclebin.can_purge . I got the below result for the below query. Can I purge those(purge dba_recyclebin)?
SQL> select count(*) from dba_recyclebin where can_purge<>'YES';
COUNT(*)
----------
70
|
|
|
|
|
|
|
|
Re: Purge Recyclebin(What is dba_recyclebin.can_purge?) [message #533956 is a reply to message #533648] |
Thu, 01 December 2011 23:45 |
prejib
Messages: 126 Registered: March 2009 Location: India
|
Senior Member |
|
|
The objects coming under the category 'can_purge='NO'' are either LOB/LOB INDEX. If try to purge those through toad , the indexes are getting purged. When I issue the DDL in prompt its not working as given below .
SQL> select object_name,
original_name,
type,
can_purge
from user_recyclebin
where can_purge = 'NO' and object_name in ('SYS_IL0000077384C00003$$', 'SYS_LOB0000077384C00003$$');
OBJECT_NAME ORIGINAL_NAME TYPE CAN
------------------------------ -------------------------------- ------------------------- ---
SYS_IL0000077384C00003$$ SYS_IL0000077384C00003$$ LOB INDEX NO
SYS_LOB0000077384C00003$$ SYS_LOB0000077384C00003$$ LOB NO
SQL> purge LOB index 'SYS_IL0000077384C00003$$';
purge LOB index 'SYS_IL0000077384C00003$$'
*
ERROR at line 1:
ORA-38302: invalid PURGE option
SQL> purge lob 'SYS_LOB0000077384C00003$$';
purge lob 'SYS_LOB0000077384C00003$$'
*
ERROR at line 1:
ORA-38302: invalid PURGE option
SQL>
Please help
[Updated on: Fri, 02 December 2011 01:20] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|