Drop user fails with ORA-01418
- From: Chadi Kassan <chadi@xxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 16 Nov 2004 10:01:07 -0500
Hi everyone,
I'm pretty sure, many had run into this problem before and can provide some
help.
When I try to drop one of my user, I get the following:
SQL> drop user theuser cascade;
ORA-00604: error occurred at recursive SQL level 1
ORA-01418: specified index does not exist
What index it's talking about, metalink says this is related to some data
corruption in data dictionnary, but doesn't provide a solution.
We run Oracle Database 10g Release 10.1.0.3.0 on Linux.
Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
