oracledba.help

Oracle Internal\System Schema

<- System

TOC

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

<- System