Home » RDBMS Server » Server Administration » problem droping locally managed tablespace in oracle 8i
problem droping locally managed tablespace in oracle 8i [message #115094] Thu, 07 April 2005 08:05 Go to next message
setudunya
Messages: 6
Registered: March 2005
Location: Botswana
Junior Member
Hi there

I wanted to drop a tablespace and I got the error ORA-29857 domain indexes and/or secondary objects exist. I identified those indexes but I cannot drop them. I get the message [ORA-01418: specified index does not exist], when connected as SYSTEM. I get [ORA-02429: cannot drop index used for enforcement of unique/primary key] when I connect as the index owner. This is a snapshot of their definition:



Name Type Uniqueness Owner

SYS_IL0000052995C00016$$ LOB UNIQUE APPL

SYS_IOT_TOP_59727 IOT - TOP UNIQUE FINC

Report message to a moderator

Re: problem droping locally managed tablespace in oracle 8i [message #115100 is a reply to message #115094] Thu, 07 April 2005 08:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
seems there is constraint that is enforcing the index.
So first disable / drop all the constraints that are involved ( which have the indexes created on this tablespace).

then drop the tablespace.
recreate the tablespace and recrate the constraints.

Report message to a moderator

Re: problem droping locally managed tablespace in oracle 8i [message #115197 is a reply to message #115100] Fri, 08 April 2005 02:05 Go to previous message
setudunya
Messages: 6
Registered: March 2005
Location: Botswana
Junior Member
I can drop indexes with type NORMAl with no problem, I experience this problem with those type LOB only.

Thank you.

Report message to a moderator

Previous Topic: undo-retention=0
Next Topic: Using ASM without raw disks?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 02:32:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.