Using the Database Configuration Assistant
Using DBCA is by far the most intuitive and simple way to install the Sample Schemas. Step 9 of the database creation process lets you configure the Sample Schemas you wish to use in your database.
-
The checkbox "Example Schemas" needs to be checked for any Sample Schema to be created.
-
DBCA installs all five schemas (HR, OE, PM, IX, SH) in your database.
|
Note:
At the end of the installation process, a window displays the accounts that have been created and their lock status. All of the Sample Schemas are locked. You can unlock the accounts at this point in the installation process. Alternatively, after installation is complete, you can unlock the schemas with an ALTER USER ... ACCOUNT UNLOCK statement. |
The Sample Schemas and objects that are available to you depend on the edition of Oracle you install and its configuration. Please consult the following table to see which schemas you can install (limitations apply):
