Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Oracle Pre-Upgrade Check


Prior to upgrading my database, on running the utlu112i.sql all my checks passed except for the “DMSYS schema exists” message.

**********************************************************************
The DMSYS schema exists in the database. Prior to performing an
upgrade Oracle recommends that the DMSYS schema, and its associated
objects be removed from the database.

Refer to the Oracle Data Mining Administration Guide for the
instructions on how to perform this task.

**********************************************************************

After making sure that the scehma is not being used I followed the Metalink document 1497250.1 to remove the DMSYS schema.
SQL> CONNECT / AS SYSDBA;
SQL> DROP USER DMSYS CASCADE;
SQL> DELETE FROM SYS.EXPPKGACT$ WHERE SCHEMA = 'DMSYS';
SQL> SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
After removing the schema, the public synonyms referring to the dropped objects in the DMSYS schema need to be removed.
set header off
spool dropDmsysSyn.sql
SELECT 'Drop public synonym ' ||'"'||SYNONYM_NAME||'";' FROM DBA_SYNONYMS
WHERE TABLE_OWNER = 'DMSYS';
spool off
@dropDmsysSyn.sql
The upgrade succeeded without any issues.

Comments

Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

Postgres Database Patch

PostgreSQL Database startup / shutdown /restart

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL Pgbadger Installation On Linux