drop user时报错ORA-00600 [qmxiUnpPacked2]。是由于升级问题造成的。metalink上给出如下解决方法。
|Subject:||Drop user fails with ora-600 [qmxiUnpPacked2]|
|Last Revision Date:||07-DEC-2005||Status:||PUBLISHED|
Oracle Server - Enterprise Edition - Version: 220.127.116.11
This problem can occur on any platform.
ORA-600 [qmxiUnpPacked2] [121 being reported during a drop user on a new 18.104.22.168 database.
This is generally caused by an invalid upgrade from earlier release.
If a database is created with the DBCA at 22.214.171.124 and one of the "seed" databases are used (not the "New Database" option),
then this seed database is at 126.96.36.199.
Once the create database is complete it needs patching to 188.8.131.52
This error occurs due to XMLType data that has not been successfully upgraded from a previous version.
To implement the solution, please execute the following steps:
1)SQL> shutdown immediate
2)SQL> startup migrate
3)SQL> spool patch.log
5)SQL> spool off
Note 222876.1 - ORA-600 [qmxiUnpPacked2]
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/228190/viewspace-183274/，如需转载，请注明出处，否则将追究法律责任。