Default Schemas in 11g

When an 11g database is created without tweaking any of the options, using either dbca or the installer, 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.

Click here to read the entire article which lists the schema's and its importance in 11g.

Metalink Note:
Further information can be found in Metalink article 160861.1

No comments :

Post a Comment