Database Administration (MOSC)

MOSC Banner

Can I drop MDSYS after removing Spatial and Multimedia?

edited Jul 19, 2016 5:01AM in Database Administration (MOSC) 2 commentsAnswered ✓

We have 11.2.0.3 databases on which Spatial and Multimedia are installed, and we use neither on those databases.  I ran $ORACLE_HOME/md/admin/mddins.sql to remove Spatial and $ORACLE_HOME/rdbms/admin/catcmprm.sql ORDIM to remove Multimedia.  However, user MDSYS still exists, as do 1509 objects owned by it.  User MDDATA exists, as do users SPATIAL_WFS_ADMIN_USR and SPATIAL_CSW_ADMIN_USR.  Is it safe to drop all these user accounts?

drop user MDSYS cascade;

drop user MDDATA;

drop user SPATIAL_WFS_ADMIN_USR;

drop user SPATIAL_CSW_ADMIN_USR;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center