[ORACLE] 删除用户drop user报错ora-01001解决方案

tjyyz

执行：

drop user abc cascade;

报错：

VBO：无法删除用户。

ORA-01001 无效的游标

ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []

原因

ORACLE 数据库从9201升级到9207不彻底。

解决

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

References
Note 222876.1 - ORA-600 [qmxiUnpPacked2]

Errors
ORA-600[QMXIUNPPACKED2]

参考：

http://www.oracleblog.org/working-case/drop-user/