ORA-600[KZDGENDROPSTMT] & ORA-600[DMMECLODM.2] While Dropping DMSYS User (Doc ID 1428416.1)

Last updated on AUGUST 04, 2013

Applies to:

Oracle Data Mining - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

In Oracle Database 11g, the DMSYS schema is no longer used. The Data Mining option is installed in the SYS schema. The 11.2 pre-upgrade tool has been extended to include a warning that the DMSYS schema should be dropped. If this warning is reported, it is recommended to drop the schema as per the Oracle Data Mining Administrator's Guide 11g Release 2 (11.2).

While dropping the DMSYS user, you receive the following errors:

ORA-00600: internal error code, arguments: [dmmeclodm.2], [1403], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DMP_SYS", line 132
ORA-06512: at "SYS.DMP_SYS", line 1217
ORA-06512: at line 1

ORA-00600: internal error code, arguments: [kzdGenDropStmt], [82], [0], [], [], [], [], [], [], [], [], []

dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=d5rrp44zk179y) -----
DROP USER dmsys CASCADE

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms