Oracle Internal\System Schema
Display
SELECT comp_name FROM dba_registry ORDER BY 1;
Component <-> Schema
Component Name Schema ================================== ======================================= JServer JAVA Virtual Machine SYS OLAP Analytic Workspace SYS Oracle Database Catalog Views SYS Oracle Database JAVA Packages SYS Oracle Database Packages and Types SYS, DBSNMP, OUTLN, SYSTEM, DIP Oracle Database Vault DVSYS Oracle Enterprise Manager SYSMAN Oracle Expression Filter EXFSYS Oracle Multimedia ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA Oracle Label Security LBACSYS Oracle OLAP API SYS Oracle Spatial MDSYS, MDDATA Oracle Text CTXSYS Oracle Ultra Search WKSYS, WKPROXY, WK_TEST Oracle Workspace Manager WMSYS Oracle XDK SYS Oracle XML Database XDB
Component Dependencies
Component Name Required Component(s)
----------------------------------------------------------------------
Oracle Data Vault Oracle Label Security (OLS )
----------------------------------------------------------------------
Oracle Expression Filter JServer JAVA Virtual Machine (JAVAVM)
----------------------------------------------------------------------
Oracle Data Mining JServer JAVA Virtual Machine (JAVAVM)
Oracle XML Database (XDB)
----------------------------------------------------------------------
InterMedia JServer JAVA Virtual Machine (JAVAVM)
Oracle XML Database (XDB)
Oracle XDK (XML)
----------------------------------------------------------------------
Oracle Rule Manager Oracle Expression Filter (EXF)
Oracle XML Database (XDB)
----------------------------------------------------------------------
Spatial JServer JAVA Virtual Machine (JAVAVM)
Oracle XML Database (XDB)
Oracle XDK (XML)
Oracle interMedia (ORDIM)
----------------------------------------------------------------------
Ultra Search JServer JAVA Virtual Machine (JAVAVM)
----------------------------------------------------------------------
XDK for JAVA JServer JAVA Virtual Machine (JAVAVM)
----------------------------------------------------------------------
Selectable List of Oracle System Schema
- AUDSYS
- ANONYMOUS
- APPQOSSYS
- CTXSYS
- DBSNMP
- DIP
- DVSYS
- EXFSYS
- GSMADMIN_INTERNAL
- GSMCATUSER
- GSMUSER
- LBACSYS
- MDDATA
- MDSYS
- ORACLE_OCM
- ORDSYS
- ORDPLUGINS
- OUTLN
- SI_INFORMTN_SCHEMA
- SYS
- SYSDG
- SYSKM
- SYSMAN
- SYSTEM
- SYSBACKUP
- WKPROXY
- WKSYS
- WK_TEST
- WMSYS
- XDB
- XS$NULL
For Use In SQL
This can be used in your SQL to exclude all Oracle system schema.
WHERE username NOT IN('ANONYMOUS','APEX_040200','APEX_PUBLIC_USER','APPQOSSYS','AUDSYS')
AND username NOT IN('CTXSYS','DBSNMP','DIP','DVF','DVSYS','EXFSYS','FLOWS_FILES')
AND username NOT IN('GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','LBACSYS','MDDATA','MDSYS')
AND username NOT IN('OJVMSYS','OLAPSYS','ORACLE_OCM','ORDDATA','ORDSYS','ORDPLUGINS','OUTLN')
AND username NOT IN('SI_INFORMTN_SCHEMA','SCOTT','SYS','SYSDG','SYSKM','SYSMAN','SYSTEM','SYSBACKUP')
AND username NOT IN('SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR')
AND username NOT IN('WKPROXY','WKSYS','WK_TEST','WMSYS','XDB','XS$NULL')
Comma Delimited
'ANONYMOUS','APEX_040200','APEX_PUBLIC_USER','APPQOSSYS','AUDSYS','CTXSYS','DBSNMP','DIP','DVF','DVSYS','EXFSYS','FLOWS_FILES','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','LBACSYS','MDDATA','MDSYS','OJVMSYS','OLAPSYS','ORACLE_OCM','ORDDATA','ORDSYS','ORDPLUGINS','OUTLN','SI_INFORMTN_SCHEMA','SCOTT','SYS','SYSDG','SYSKM','SYSMAN','SYSTEM','SYSBACKUP','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','WKPROXY','WKSYS','WK_TEST','WMSYS','XDB','XS$NULL'
No Quotes
ANONYMOUS,APEX_040200,APEX_PUBLIC_USER,APPQOSSYS,AUDSYS,CTXSYS,DBSNMP,DIP,DVF,DVSYS,EXFSYS,FLOWS_FILES,GSMADMIN_INTERNAL,GSMCATUSER,GSMUSER,LBACSYS,MDDATA,MDSYS,OJVMSYS,OLAPSYS,ORACLE_OCM,ORDDATA,ORDSYS,ORDPLUGINS,OUTLN,SI_INFORMTN_SCHEMA,SCOTT,SYS,SYSDG,SYSKM,SYSMAN,SYSTEM,SYSBACKUP,SPATIAL_CSW_ADMIN_USR,SPATIAL_WFS_ADMIN_USR,WKPROXY,WKSYS,WK_TEST,WMSYS,XDB,XS$NULL