Predefined Oracle System Schemas
Posted by Vishal Gupta on Jun 19, 2011
If you have ever wondered what are the various predefined internal Oracle system schemas, you can find the list of such accounts and their use in Oracle® Database 2 Day + Security Guide
11g Release 2 (11.2) at this link. This list comes in handy, when you want to do some analysis on database objects, but want to exclude all internal Oracle provided system accounts and want to focus only on application level accounts.
Here is the list of schemas:-
ANONYMOUS APEX_PUBLIC_USER CTXSYS DBSNMP DIP EXFSYS FLOWS_% FLOWS_FILES LBACSYS MDDATA MDSYS MGMT_VIEW OLAPSYS ORACLE_OCM ORDDATA ORDPLUGINS ORDSYS OUTLN OWBSYS SI_INFORMTN_SCHEMA SPATIAL_CSW_ADMIN_USR SPATIAL_WFS_ADMIN_USR SYS SYSMAN SYSTEM WKPROXY WKSYS WK_TEST WMSYS XDB XS$NULL