-
Error while drop user
When i have tried to drop ACC user i got fllowing error
SQL>DROP USER ACC CACSADE;
drop user acc
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [],
[], [], []
After getting this error i have checked than there is no object in ACC user.
-
From metalink:
Code:
Symptoms
ORA-600 [qmxiUnpPacked2] [121 being reported during a drop user on a new 9.2.0.7 database.
Cause
This is generally caused by an invalid upgrade from earlier release.
If a database is created with the DBCA at 9.2.0.7 and one of the "seed" databases are used (not the "New Database" option),
then this seed database is at 9.2.0.1.
Once the create database is complete it needs patching to 9.2.0.7
This error occurs due to XMLType data that has not been successfully upgraded from a previous version.
Solution
To implement the solution, please execute the following steps:
1)SQL> shutdown immediate
2)SQL> startup migrate
3)SQL> spool patch.log
4)SQL> @?/rdbms/admin/catpatch
5)SQL> spool off
-
Thanks jmodic.
I follow the steps as mention by you.
My problem is solved