Home » RDBMS Server » Server Administration » ORA-29857: domain indexes and/or secondary objects exist in the tablespace
ORA-29857: domain indexes and/or secondary objects exist in the tablespace [message #266052] Sun, 09 September 2007 06:19 Go to next message
manasbis
Messages: 8
Registered: August 2007
Junior Member
While dropping tablespace, follwing error encountered, Please help us.
ORA-29857: domain indexes and/or secondary objects exist in the tablespace

Re: ORA-29857: domain indexes and/or secondary objects exist in the tablespace [message #266053 is a reply to message #266052] Sun, 09 September 2007 06:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-29857: domain indexes and/or secondary objects exist in the tablespace
 *Cause: An attempt was made to drop a tablespace which contains secondary
         objects and/or domain indexes.
 *Action: Drop the domain indexes in his tablespace. Also, find the domain
          indexes which created secondary objects in this tablespace and
          drop them. Then try dropping the tablespace.

Regards
Michel
Re: ORA-29857: domain indexes and/or secondary objects exist in the tablespace [message #266119 is a reply to message #266052] Sun, 09 September 2007 21:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

This is the restriction of dropping tablespace.
That is,

You cannot drop a tablespace that contains a domain index or any objects created by a domain index.
Re: ORA-29857: domain indexes and/or secondary objects exist in the tablespace [message #266120 is a reply to message #266052] Sun, 09 September 2007 21:56 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

By the way I think this is appropriate in server administration section.
Previous Topic: Can I install Oracle DB 10g on HP UX PA-RISC without XWindow?
Next Topic: On 10gR2, Do you trust ADDM?
Goto Forum:
  


Current Time: Thu Dec 08 20:23:09 CST 2016

Total time taken to generate the page: 0.12060 seconds