Oracle 11g Default Schemas

ANONYMOUS SYSAUX TEMP YES
APEX_030200 SYSAUX TEMP YES
APEX_PUBLIC_USER USERS TEMP YES
APPQOSSYS SYSAUX TEMP YES
BI USERS TEMP YES
CTXSYS SYSAUX TEMP YES
DBSNMP SYSTEM TEMP

DIP USERS TEMP YES
EXFSYS SYSAUX TEMP YES
FLOWS_FILES SYSAUX TEMP YES
HR USERS TEMP YES
IX USERS TEMP YES
MDDATA USERS TEMP YES
MDSYS SYSAUX TEMP YES
MGMT_VIEW SYSTEM TEMP

OE USERS TEMP YES
OLAPSYS SYSAUX TEMP YES
ORACLE_OCM USERS TEMP YES
ORDDATA SYSAUX TEMP YES
ORDPLUGINS SYSAUX TEMP YES
ORDSYS SYSAUX TEMP YES
OUTLN SYSTEM TEMP YES
OWBSYS SYSAUX TEMP YES
OWBSYS_AUDIT SYSAUX TEMP YES
PM USERS TEMP YES
SCOTT USERS TEMP YES
SH USERS TEMP YES
SI_INFORMTN_SCHEMA SYSAUX TEMP YES
SPATIAL_CSW_ADMIN_USR USERS TEMP YES
SPATIAL_WFS_ADMIN_USR USERS TEMP YES
SYS SYSTEM TEMP
YES SYSMAN SYSAUX TEMP

SYSTEM SYSTEM TEMP
YES WMSYS SYSAUX TEMP YES
XDB SYSAUX TEMP YES
XS$NULL USERS TEMP YES

SCHEMA OVERVIEW

ANONYMOUS

• Purpose:

  • Account that allows HTTP access to Oracle XML DB. It is used in place of theAPEX_PUBLIC_USERaccount when the Embedded PL/SQL Gateway (EPG) is installed in the database. EPG is a Web server that can be used with Oracle Database. It provides the necessary infrastructure to create dynamic applications. See alsoXDB.

• Safe To Remove:

  • Yes

• Recreation Script:

  • $ORACLE_HOME/rdbms/admin/catqm.sql

APEX_030200

• Purpose:

  • Part of the Oracle Application Express Suite - (Oracle APEX,previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. The account owns the Application Express schema and metadata. See alsoAPEX_PUBLIC_USERandFLOW_FILES.

• Safe To Remove:

  • Yes

• Recreation Script:

  • $ORACLE_HOME/apex/apexins.sql

APEX_PUBLIC_USER

• Purpose:

  • Part of the Oracle Application Express Suite - (Oracle APEX,previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. This minimally privileged account is used for Application Express configuration with Oracle HTTP Server and mod_plsql. See alsoAPEX_030200and

    APPQOSSYS

    • Purpose:

      • Used for storing/managing all data and metadata required by Oracle Quality of Service Management.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_ADMIN/rdbms/admin/catqos.sql

    BI

    • Purpose:

      • The account that owns the Business Intelligence schema included in the Oracle Sample Schemas. See alsoHR,OE,SH,IXandPM.

    • Safe To Remove:

      • Yes ?C run$ORACLE_HOME/demo/schema/drop_sch.sql

    • Recreation Script:

      • $ORACLE_HOME/demo/schema/bus_intelligence/bi_main.sql

    CTXSYS

    • Purpose:

      • The account used to administer Oracle Text. Oracle Text enables the building of text query applications and document classification applications. It provides indexing,word and theme searching,and viewing capabilities for text.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/ctx/admin/ctxsys.sql

    DBSNMP

    • Purpose:

      • The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database. Password is created at installation or database creation time.

    • Safe To Remove:

      • Yes ?C run$ORACLE_HOME/rdbms/admin/catnsnmp.sql

    • Recreation Script:

      • $ORACLE_HOME/rdbms/admin/catsnmp.sql

    DIP

    • Purpose:

      • The account used by the Directory Integration Platform (DIP) to synchronize the changes in Oracle Internet Directory with the applications in the database.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/rdbms/admin/catdip.sql

    EXFSYS

    • Purpose:

      • The account used internally to access the EXFSYS schema,which is associated with the Rules Manager and Expression Filter feature. This feature enables the building of complex PL/SQL rules and expressions. The EXFSYS schema contains the Rules Manager and Expression Filter DDL,DML,and associated metadata.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/rdbms/admin/exfsys.sql

    FLOW_FILES

    • Purpose:

      • Part of the Oracle Application Express Suite - (Oracle APEX,previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. This account owns the Application Express uploaded files. See alsoAPEX_030200andAPEX_PUBLIC_USER.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/apex/apexins.sql

    HR

    • Purpose:

      • The account that owns the Human Resources schema included in the Oracle Sample Schemas. See alsoBI,86);" target="_blank" rel="nofollow">PM.

    • Safe To Remove:

      • Yes ?C run$ORACLE_HOME/demo/schema/drop_sch.sql

    • Recreation Script:

      • $ORACLE_HOME/demo/schema/human_resources/hr_main.sql

    IX

    • Purpose:

      • The account that owns the Information Transport schema included in the Oracle Sample Schemas. See alsoSHandPM.

    • Safe To Remove:

      • Yes ?C run$ORACLE_HOME/demo/schema/drop_sch.sql

    • Recreation Script:

      • $ORACLE_HOME/demo/schema/info_exchange/ix_main.sql

    MDDATA

    • Purpose:

      • The schema used by Oracle Spatial for storing Geocoder and router data. See alsoSPATIAL_CSW_ADMIN_USR,SPATIAL_WFS_ADMIN_USRandMDSYS.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/md/admin/catmd.sql

    MDSYS

    • Purpose:

      • The Oracle Spatial and Oracle Multimedia Locator administrator account. See alsoMDDATAandSPATIAL_WFS_ADMIN_USR.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/ord/admin/ordinst.sql

    MGMT_VIEW

    • Purpose:

      • An account used by Oracle Enterprise Manager Database Control. Password is randomly generated at installation or database creation time. Users do not need to know this password.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/sysman/admin/emdrep/bin/RepManager

    OE

    • Purpose:

      • The account that owns the Order Entry schema included in the Oracle Sample Schemas. See alsoPM.

    • Safe To Remove:

      • Yes ?C run$ORACLE_HOME/demo/schema/drop_sch.sql

    • Recreation Script:

      • $ORACLE_HOME/ demo/schema/order_entry/oe_main.sql

    OLAPSYS

    • Purpose:

      • The account that owns the OLAP Catalog (CWMLite). This account has been deprecated,but is retained for backward compatibility.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/olap/admin/amdsys.sql

    ORACLE_OCM

    • Purpose:

      • This account contains the instrumentation for configuration collection used by the Oracle Configuration Manager.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/rdbms/admin/catocm.sql

    ORDDATA

    • Purpose:

      • This account contains the Oracle Multimedia DICOM data model.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/ord/admin/ordisysc.sql

    ORDPLUGINS

    • Purpose:

      • The Oracle Multimedia user. Plug-ins supplied by Oracle and third-party,format plug-ins are installed in this schema. Oracle Multimedia enables Oracle Database to store,manage,and retrieve images,audio,video,DICOM format medical images and other objects,or other heterogeneous media data integrated with other enterprise information. See alsoORDSYSandSI_INFORMTN_SCHEMA.

    • Safe To Remove:

      • Yes

    • Recreation Script:

      • $ORACLE_HOME/ord/admin/ordinst.sql

    ORDSYS

    • Purpose:

      • The Oracle Multimedia administrator account. See alsoORDPLUGINSand

        OUTLN

        • Purpose:

          • The account that supports plan stability. Plan stability prevents certain database environment changes from affecting the performance characteristics of applications by preserving execution plans in stored outlines. OUTLN acts as a role to centrally manage metadata associated with stored outlines.

        • Safe To Remove:

          • No

        • Recreation Script:

          • $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.

        OWBSYS

        • Purpose:

          • The account for administrating the Oracle Warehouse Builder repository. Access this account during the installation process to define the base language of the repository and to define Warehouse Builder workspaces and users. A data warehouse is a relational or multidimensional database that is designed for query and analysis. See alsoOWBSYS_AUDIT.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql

        OWBSYS_AUDIT

        • Purpose:

          • This account is used by the Warehouse Builder Control Center Agent to access the heterogeneous execution audit tables in theOWBSYSschema.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql

        PM

        • Purpose:

          • The account that owns the Product Media schema included in the Oracle Sample Schemas. See alsoSHandIX.

        • Safe To Remove:

          • Yes ?C run$ORACLE_HOME/demo/schema/drop_sch.sql

        • Recreation Script:

          • $ORACLE_HOME/demo/schema/product_media/pm_main.sql

        SCOTT

        • Purpose:

          • An account used by Oracle sample programs and examples.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/rdbms/admin/utlsampl.sql

        SH

        • Purpose:

          • The account that owns the Sales History schema included in the Oracle Sample Schemas and is only available forEnterprise Editioninstallations. See alsoPM.

        • Safe To Remove:

          • Yes ?C run$ORACLE_HOME/demo/schema/drop_sch.sql

        • Recreation Script:

          • $ORACLE_HOME/demo/schema/sales_history/sh_main.sql

        SI_INFORMTN_SCHEMA

        • Purpose:

          • The account that stores the information views for the SQL/MM Still Image Standard. See alsoORDPLUGINSandORDSYS.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/ord/admin/ordinst.sql

        SPATIAL_CSW_ADMIN_USR

        • Purpose:

          • The Catalog Services for the Web (CSW) account. It is used by the Oracle Spatial CSW cache manager to load all record type metadata,and record instances from the database into the main memory for the record types that are cached. See alsoSPATIAL_WFS_ADMIN_USR,86);" target="_blank" rel="nofollow">MDDATAandMDSYS.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/md/admin/sdocswpv.sql

        SPATIAL_WFS_ADMIN_USR

        • Purpose:

          • The Web Feature Service (WFS) account. It is used by the Oracle Spatial WFS cache manager to load all feature type metadata,and feature instances from the database into main memory for the feature types that are cached. See alsoMDSYS.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/md/admin/sdowfspv.sql

        SYS

        • Purpose:

          • An account used to perform database administration tasks. Password is created at installation or database creation time.

        • Safe To Remove:

          • No

        • Recreation Script:

          • $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.

        SYSMAN

        • Purpose:

          • The account used to perform Oracle Enterprise Manager database administration tasks. TheSYSandSYSTEMaccounts can also perform these tasks. Password is created at installation or database creation time.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • Created as part of thedbconsoleorEnterprise Managerbuild.

        SYSTEM

        • Purpose:

          • A default generic database administrator account for Oracle databases. For production systems,Oracle recommends creating individual database administrator accounts and not using the genericSYSTEMaccount for database administration operations. Password is created at installation or database creation time.

        • Safe To Remove:

          • No

        • Recreation Script:

          • $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.

        WMSYS

        • Purpose:

          • The account used to store the metadata information for Oracle Workspace Manager.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/rdbms/admin/owmctab.plb

        XDB

        • Purpose:

          • The account used for storing Oracle XML DB data and metadata. See alsoANONYMOUS.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/rdbms/admin/catqm.sql

        XS$NULL

        • Purpose:

          • An internal account that represents the absence of a user in a session. Because XS$NULL is not a user,this account can only be accessed by the Oracle Database instance. XS$NULL has no privileges and no one can authenticate as XS$NULL,nor can authentication credentials ever be assigned to XS$NULL.

        • Safe To Remove:

          • No

        • Recreation Script:

          • $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.

        OTHER ADMINISTRATIVE SCHEMA

        The schema listed below arenotinstalled by default,but can be built using the creation script(s) cited and any necessary additional steps as prescribed by the appropriate Oracle manual.

        LBACSYS

        • Purpose:

          • The account used to administer Oracle Label Security (OLS). It is created only when the Label Security custom option is installed.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/rdbms/admin/catlbacs.sql

        WK_TEST

        • Purpose:

          • The instance administrator for the default instance,WK_INST. After unlocking this account and assigning this user a password,then the cached schema password must also be updated using the administration tool Edit Instance Page. Ultra Search provides uniform search-and-location capabilities over multiple repositories,such as Oracle databases,other ODBC compliant databases,IMAP mail servers,HTML documents managed by a Web server,files on disk,and more. See alsoWKSYS

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/ultrasearch/admin/wk0csys.sql

        WKSYS

        • Purpose:

          • An Ultra Search database super-user. WKSYS can grant super-user privileges to other users,such as WK_TEST. All Oracle Ultra Search database objects are installed in the WKSYS schema. See alsoWK_TEST

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/ultrasearch/admin/wk0csys.sql

        WKPROXY

        • Purpose:

          • An administrative account of Application Server Ultra Search.

        • Safe To Remove:

          • Yes

        • Recreation Script:

          • $ORACLE_HOME/ultrasearch/admin/wk0csys.sql

        ADDITIONAL INFORMATION

        • Further information can be found in Metalink article160861.1.

        （编辑：李大同）

        【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

http://www.oracle-wiki.net/startdocsdefaultschemas ACKGROUND When an 11g database is created withouttweakingany of the options,using eitherdbcaor theinstaller,the schema listed in the table below,36 of them(!),are created by default. This document gives an overview of their purpose and function and,should the functionailty not be required,whether they can be safely deleted*or not without compromising the fundamental operation of the database. Additionally,having been removed,if a schema is required again,there are details of which script(s) are required to be run in order to recreate*it. As well as the schema installed by default,there are features that may need to be installed. The schema required to perform these functions,their purpose and installation scripts are described in theOther Administrative Schemasection below. [@more@] *IMPORTANT Removal of schema marked Safe To Remove may require further actions than that of simply dropping the user. Installation of certain functionality may require further actions than that of simply running the scripts cited below. Consult the appropriate Oracle documentation for the full set of removal and/or installation steps. DEFAULT SCHEMA
USER NAME	DEFAULT TABLESPACE	TEMPORARY TABLESPACE	LOCKED?	DBA?