OraFAQ Forum: Server Administration » how to clear recyclebin of a user in 10g

Home » RDBMS Server » Server Administration » how to clear recyclebin of a user in 10g

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

how to clear recyclebin of a user in 10g [message #128141]

Fri, 15 July 2005 06:32

dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore

Member

i dropped some tables from my user. when i give the query select * from tab, it is showing BIN$++ tables. These are coming from recyclebin. How do i clear recyclebin?

Praveen

[Updated on: Fri, 15 July 2005 06:38]

Report message to a moderator

Re: how to clear recyclebin of a user in 10g [message #128146 is a reply to message #128141]

Fri, 15 July 2005 06:44

Satheesh Babu.S
Messages: 35
Registered: July 2004

Member

SQL> purge recyclebin;

Recyclebin purged.

or

if you want to revert back to earlier behaviour you can use "_recyclebin"=false

Thanks and Regards,
Satheesh Babu.S
Bangalore

Report message to a moderator

Re: how to clear recyclebin of a user in 10g [message #128148 is a reply to message #128146]

Fri, 15 July 2005 06:53

dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore

Member

Can you briefly explain what is _recyclebin=false, what it does?

Report message to a moderator

Re: how to clear recyclebin of a user in 10g [message #128161 is a reply to message #128141]

Fri, 15 July 2005 08:17

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

You can use the dropped column in user_tables to filter for those with a value of NO, meaning they are not dropped. The behavior from the user, all, dba tables views changes slightly between 10.1.0.2 and either 10.1.0.3 or 10.1.0.4, so that when you select from user_tables you by default don't get those that have been dropped.

Report message to a moderator

Re: how to clear recyclebin of a user in 10g [message #128377 is a reply to message #128148]

Mon, 18 July 2005 04:59

Satheesh Babu.S
Messages: 35
Registered: July 2004

Member

"_recyclebin" is a undocumented parameter, which helps in reverting to earlier version behaviour.

Thanks and Regards,
Satheesh Babu.S
Bangalore.

Report message to a moderator

Previous Topic:	specifying destination location for archive log files
Next Topic:	specify maxsize to a datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 08:26:28 CST 2025