Home » RDBMS Server » Server Administration » Dropped Table is not available in Recyclebin
Dropped Table is not available in Recyclebin [message #130422] Sat, 30 July 2005 02:33 Go to next message
dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore
Member
In 10g after droping a table, its not available in recyclebin. What could be the reason.

After droping an object if i want to that object to be available in recyclebin what process should i follow?

Regards,
Praveen

Report message to a moderator

Re: Dropped Table is not available in Recyclebin [message #130428 is a reply to message #130422] Sat, 30 July 2005 03:58 Go to previous messageGo to next message
Achchan
Messages: 86
Registered: June 2005
Member
It seems strange for me.Maybe there is a DDL trigger that purge ther recycle bin after you drop a table.
-I am tracing this.

Report message to a moderator

Re: Dropped Table is not available in Recyclebin [message #130601 is a reply to message #130422] Mon, 01 August 2005 07:17 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Are you sure that it is not there immediately following your drop? Can you post your session information where you create and then drop a table and show us that it is not there?

Also keep in mind that it will only be there if there is enough free space in the tablespace to hold it. If other tables grow, they will overwrite the dropped objects.

Also oracle changed the behavior of user_tables between version 10.1.0.2 and either 10.1.0.3 or 10.1.0.4 so that dropped tables do not show up by default in that view like they did originally.

Report message to a moderator

Previous Topic: Problem with open cursors.
Next Topic: Schema Creation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 26 22:53:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.