-
error in droping tablespace
hi all,
ver-Oracle 9.2
When i tried to drop tablespace(in test box) it shows me err.
SQL> drop tablespace users including contents and datafiles;
drop tablespace users including contents and datafiles
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-02429: cannot drop index used for enforcement of unique/primary key
already all datafiles are offlined.
which index i have to drop ???
Thanks in adv.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|