Can I drop MDSYS after removing Spatial and Multimedia?
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;