Remove dmsys befor upgrading to 11.2.0.X

20:14:11 SQL> 20:14:11 SQL> SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
       4
Elapsed: 00:00:00.08
20:14:41 SQL> DROP USER DMSYS CASCADE;

Elapsed: 00:00:42.99
20:15:40 SQL> 20:15:40 SQL> SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
       4
Elapsed: 00:00:00.01
20:15:48 SQL> DELETE FROM SYS.EXPPKGACT$ WHERE SCHEMA = 'DMSYS';
Elapsed: 00:00:00.04

20:16:03 SQL> SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
       4
Elapsed: 00:00:00.00
20:16:18 SQL> SET HEAD OFF;
20:16:59 SQL> SELECT 'Drop public synonym ' ||'"'||SYNONYM_NAME||'";' FROM DBA_SYNONYMS
WHERE TABLE_OWNER = 'DMSYS';20:17:07   2

Drop public synonym "CLUSTER_RULE_TYPE";
Drop public synonym "CLUSTER_TYPE";
Drop public synonym "ODM_ATTRIBUTE_IMPORTANCE_MODEL";
Drop public synonym "ODM_NAIVE_BAYES_MODEL";
Elapsed: 00:00:00.05

20:17:08 SQL> Drop public synonym "CLUSTER_RULE_TYPE";
Elapsed: 00:00:00.06
20:17:22 SQL> Drop public synonym "CLUSTER_TYPE";
Elapsed: 00:00:00.04
20:17:28 SQL> Drop public synonym "ODM_ATTRIBUTE_IMPORTANCE_MODEL";
Elapsed: 00:00:00.04
20:17:33 SQL> Drop public synonym "ODM_NAIVE_BAYES_MODEL";
Elapsed: 00:00:00.03
20:17:39 SQL> SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
       0
Elapsed: 00:00:00.00
20:17:46 SQL>