|Oracle® Database Sample Schemas
10g Release 1 (10.1)
Part Number B10771-01
To reset the Sample Schemas to their initial state, from the SQL*Plus command-line interface, use the following syntax:
@?/demo/schema/mksample systempwd syspwd hrpwd oepwd pmpwd ixpwd shpwd
In place of the parameters
shpwd provide the passwords for
SYS, and the
mksample script produces several log files located in the directory
mkverify.log is the Sample Schema creation log file.
hr_main.log is the
HR schema creation log file.
oe_oc_main.log is the
OE schema creation log file.
pm_main.log is the
PM schema creation log file.
pm_p_lob.log is the SQL*Loader log file for
ix_main.log is the
IX schema creation log file.
sh_main.log is the
SH schema creation log file.
cust.log is the SQL*Loader log file for
prod.log is the SQL*Loader log file for
promo.log is the SQL*Loader log file for
sales.log is the SQL*Loader log file for
sales_ext.log is the external table log file for
In most situations, there is no difference between installing a particular Sample Schema for the first time or reinstalling it over a previously installed version. The
*_main.sql scripts drop the schema users and all their objects.
In some cases, complex interobject relationships in the
IX schemas prevent the
CASCADE operations from completing normally. To correct these rare cases, use one of the following procedures:
OC catalog subschema of the
Connect as the user
Execute the script
Ensure that no user is connected as
SELECT username FROM v$session;
Drop the user:
DROP USER oe CASCADE;
Ensure that no user is connected as a
SELECT username FROM v$session WHERE username like 'IX%';
Drop the schemas by executing the script
dix.sql. You will be prompted for the passwords for the individual users.