My Oracle Support Banner

When Using DBCA to Create a Database, Extra Schemas Are Created (Doc ID 457800.1)

Last updated on DECEMBER 06, 2019

Applies to:

Oracle Database Configuration Assistant - Version 9.2.0.8 to 10.2.0.3 [Release 9.2 to 10.2]
Oracle Database - Enterprise Edition - Version 9.2.0.8 to 10.2.0.4 [Release 9.2 to 10.2]
Information in this document applies to any platform.
Oracle Database Configuration Assistant - Version: 9.2.0.8 to 10.2.0.3
This problem can occur on any platform.
Oracle Server Enterprise Edition - Version: 9.2.0.8 to 10.2.0.4

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

When using the DBCA utility to create a new database and  you choose the "General Purpose" template. At completion of the create, there are 25 schemas in the database:

 ANONYMOUS, CTXSYS, HR, MDSYS, ODM, ODM_MTR, OE, OLAPSYS, ORDPLUGINS, ORDSYS, PM, QS, QS_ADM, QS_CB, QS_CBADM, QS_CS, QS_ES, QS_OS, QS_WS, SCOTT, SH, WKPROXY, WKSYS, WMSYS, XDB

Changes

This is expected behavior with DBCA.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.