All the other sample schemas must be installed manually via the scripts available on GitHub.

You should not use the sample schemas for your personal or business data and applications.

By default, sample schemas are locked and their passwords are expired.

Before you can use a locked account, you must unlock it and reset its password.

You can unlock the accounts at this point in the installation process.

Alternatively, after the installation completes, you can unlock the schemas and reset their passwords by using the ALTER USER.

The following steps provide a summary of the installation process.

To verify that the schema was created, use the following command.

To prepare schema HR for use with the directory capabilities of Oracle Internet Directory, run the hrdnc.sql script.

If you want to return to the initial setup of schema HR, use script hrdnd.sql to undo the effects of script hrdnc.sql.

Oracle 11G Oe Schema Script Download Them From

If you want to use sample schemas other than HR, such as OE, OC, PM, and SH schemas, you must download them from the GitHub repository.

Specify a temporary and a default tablespace, and make sure to end the name of the log file directory with a trailing slash.