OraFAQ Forum: Server Administration » Recycle bin problem !!!

Home » RDBMS Server » Server Administration » Recycle bin problem !!!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recycle bin problem !!! [message #215859]

Wed, 24 January 2007 02:02

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

Report message to a moderator

Re: Recycle bin problem !!! [message #215868 is a reply to message #215859]

Wed, 24 January 2007 02:25

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

Report message to a moderator

Re: Recycle bin problem !!! [message #215874 is a reply to message #215859]

Wed, 24 January 2007 02:31

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:48:49 CDT 2024