Google+ Followers


Friday, July 27, 2012

Manual steps to create Oracle Sample Schemas

The sample schemas can be installed using the database configuration assistant by checking the checkbox Example Schemas.

Manual method of creating oracle Sample Schemas.

When the sample schemas are installed manually, the driving script (mksample.sql) is invoked like so.
The first two arguments are the password for system and sys, respectively, followed by the six passwords for hr, oe, pm, ix, sh and bi, respectively, followed by the default tablspace and the default temp tablespace.

Connect as DBA and issue following command.
@?/demo/schema/mksample passwd_system passwd_sys pw_hr pw_oe pw_pm pw_ix pw_sh pw_bi users temp c:\temp\ora_schema_log

No comments:

Post a Comment