Home » RDBMS Server » Server Administration » Recycle bin problem !!!
Recycle bin problem !!! [message #215859] Wed, 24 January 2007 02:02 Go to next message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
I have the following problem: I am working with AdminUser and I need to purge the recycle bin from another user so the problem is that i can not connect to the other user, i issued the following statement :

SQL> purge user.recyclebin;

but i get the following error:

ORA-27234: Message 27234 not found; product=RDBMS; facility=ORA

Can anyone give me a hint please??!!


Thanks
Re: Recycle bin problem !!! [message #215868 is a reply to message #215859] Wed, 24 January 2007 02:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Which Oracle Rel: ?
SQL> purge scott.recyclebin;
purge scott.recyclebin
      *
ERROR at line 1:
ORA-38302: invalid PURGE option


SQL> purge tablespace USERS user SCOTT;

Tablespace purged.


Example Based on 10.1.0.2.0

Note : you cann't your purge SCHEMA.recyclebin there is not syntax.
you have to purge USER TABLESPACE where recyclebin OBJECTS is exists.

regards
Taj
Re: Recycle bin problem !!! [message #215874 is a reply to message #215859] Wed, 24 January 2007 02:31 Go to previous message
sshpocp
Messages: 9
Registered: January 2007
Location: India
Junior Member
Hi,

I hope that you are working on Oracle 10g Database.

If you want to purge a perticular User's recycle bin. You can follow the below steps.

1. connect to SQL*Plus as SYSDBA
2. Check the purged objects for a perticular user, and Tablespace Name.

SQL> SELECT OBJECT_NAME,TS_NAME FROM DBA_RECYCLEBIN WHERE OWNER='SCOTT' ;

OBJECT_NAME TS_NAME
---------- ------------------------------
EMP USERS
DEPT USERS
..... .....


3. Now purge that tablespace for SCOTT user.

SQL> PURGE TABLESPACE USERS USER SCOTT;
Tablespace purged.

Regards,
Sabdar Syed,
http://sabdarsyed.blogspot.com

Previous Topic: Problem faced while patching 10.2.0.3 Patch set 2 on 10g (5337014)
Next Topic: how to make a formserver
Goto Forum:
  


Current Time: Thu Dec 08 14:30:58 CST 2016

Total time taken to generate the page: 0.12037 seconds