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
There are objects in SYS.OBJ$ that need to be dropped first.
SOLUTION
Run these queries:
spool output.txt
select user# FROM SYS.USER$ U WHERE U.NAME = 'DMSYS';
(note user# and use it in the queries below):
select obj#,name FROM SYS.OBJ$ WHERE type#=82 AND owner# = <user# from above>;
select distinct u.name from obj$ o, user$ u where o.owner#=u.user# and o.owner#=<user# from above>;
delete from obj$ WHERE type#=82 AND owner# = <user# from above>;
Then drop DMSYS
As SYS:
DROP USER DMSYS CASCADE;
如果自己搞不定可以找詩檀軟件專業ORACLE數據庫修復團隊成員幫您恢復!
詩檀軟件專業數據庫修復團隊