OraFAQ Forum: Server Administration » ORA-29857: domain indexes and/or secondary objects exist in the tablespace

Home » RDBMS Server » Server Administration » ORA-29857: domain indexes and/or secondary objects exist in the tablespace

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

ORA-29857: domain indexes and/or secondary objects exist in the tablespace [message #266052]

Sun, 09 September 2007 06:19

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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.

Report message to a moderator

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

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

By the way I think this is appropriate in server administration section.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:56:08 CST 2024