Home » SQL & PL/SQL » Client Tools » how to clean recyclebin in 11g (oracle 11g)
how to clean recyclebin in 11g [message #638790] Sun, 21 June 2015 08:56 Go to next message
jgjeetu
Messages: 363
Registered: July 2013
Location: www.Orafaq.com/Forum
Senior Member

SQL> select * from v$version
  2  /

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> select * from recyclebin
  2  /

OBJECT_NAME                    ORIGINAL_NAME                    OPERATION TYPE                      
------------------------------ -------------------------------- --------- ------------------------- 
BIN$80VNR20YR6eO2mRNs3v7vA==$0 T                                DROP      TABLE                     
BIN$wyze0BJfQ12cb0XMUwUscA==$0 TEMP                             DROP      TABLE                     
BIN$gPcHwa3iQL24TIPY0j+frg==$0 J                                DROP      TABLE                     

SQL> purge recyclebin
unknown command beginning "purge recy..." - rest of line ignored.
SQL> 


purge recyclebin command is not working in oracle 11g why ? how to clean recyclebin then
please help
Re: how to clean recyclebin in 11g [message #638791 is a reply to message #638790] Sun, 21 June 2015 09:21 Go to previous messageGo to next message
BlackSwan
Messages: 26183
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/wiki/Recycle_bin

http://www.orafaq.com/node/968

Problem Exists Between Keyboard And Chair
[oracle@localhost dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun Jun 21 07:21:34 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from V$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL> purge recyclebin;

Recyclebin purged.

SQL> 


[Updated on: Sun, 21 June 2015 09:22]

Report message to a moderator

Re: how to clean recyclebin in 11g [message #638794 is a reply to message #638790] Sun, 21 June 2015 12:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65837
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Your SQL*Plus must be of a version which knows the recycle bin.

Re: how to clean recyclebin in 11g [message #638983 is a reply to message #638790] Sun, 28 June 2015 03:52 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3131
Registered: May 2013
Location: World Wide on the Web
Senior Member
jgjeetu wrote on Sun, 21 June 2015 19:26

purge recyclebin command is not working in oracle 11g why ?


Perhaps your client version is old. You could try purging individual objects or use EXECUTE IMMEDIATE in PL/SQL. See https://community.oracle.com/message/1968705#1968705
Re: how to clean recyclebin in 11g [message #638984 is a reply to message #638983] Sun, 28 June 2015 04:12 Go to previous message
Michel Cadot
Messages: 65837
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Perhaps your client version is old.


This is sure.
Previous Topic: Oracle client
Next Topic: Insert postgresql BYTEA datatype data into oracle blob column
Goto Forum:
  


Current Time: Tue Oct 16 06:10:23 CDT 2018