Home » RDBMS Server » Performance Tuning » Purge recyclebin
Purge recyclebin [message #380038] Thu, 08 January 2009 21:27 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
I have 4950 objects in the reclyebin in the production database
.Purge Recycebin will delete only tables in recyclebin.It
wont effect anything else.Please confirm.
Regards,
Varun Punj
Re: Purge recyclebin [message #380040 is a reply to message #380038] Thu, 08 January 2009 21:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If some anonymous person confirms it in a forum, will it make it secure?
First search.
Then test it. It is very simple. Then come to conclusion.

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

[Updated on: Thu, 08 January 2009 21:33]

Report message to a moderator

Re: Purge recyclebin [message #380334 is a reply to message #380038] Sat, 10 January 2009 23:30 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You can do it. Tables and its associated Indexes reside in the recyclebin will be purged.
Re: Purge recyclebin [message #380342 is a reply to message #380334] Sun, 11 January 2009 01:09 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
varunvir
Purge Recycebin will delete only tables in recyclebin.It
wont effect anything else.Please confirm.

Arju
You can do it. Tables and its associated Indexes reside in the recyclebin will be purged.

So you confirm it impacts other things than tables. Grin

Regards
Michel

[Updated on: Sun, 11 January 2009 01:10]

Report message to a moderator

Previous Topic: Oracle 9i
Next Topic: Need help in Optimizing this query
Goto Forum:
  


Current Time: Mon Jul 01 16:26:24 CDT 2024