Home » RDBMS Server » Server Administration » Question about recyclebin
Question about recyclebin [message #538463] Fri, 06 January 2012 05:51 Go to next message
justlearner
Messages: 9
Registered: January 2012
Junior Member
Hi All,
I have a question about recyclebin.When i drop a table,the talbe will be moved to recyclebin,the name is changed to BIN$...,but the constraint built on the table aren't moved to recyclebin and their name are also BIN$...,why?

Thanks.

Report message to a moderator

Re: Question about recyclebin [message #538465 is a reply to message #538463] Fri, 06 January 2012 05:58 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The recyclebin contains the object that have segment that is physical objects.
The logical objects are logically in the recycle bin by the relation they have with the physical objects.

In the same way tables are in dba_segments but their constraints not.

Regards
Michel

Report message to a moderator

Previous Topic: what's the maximum size of the control file ?
Next Topic: How partition can be brought offline
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 13:46:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.