The Oracle HR sample user's build 10g,11g can be
Put the 10. sql files on the attachment (see the end of the article) in this path first:
$ORACLE _home/demo/schema/human_resources
Script Name |
Description |
Hr_analz.sql |
Collects statistics on the tables in the schema. |
Hr_code.sql |
Creates procedural objects in the schema. |
Hr_comnt.sql |
Creates comments for each object in the schema. |
Hr_cre.sql |
Creates the HR objects. |
Hr_dn_c.sql |
Adds the distinguished Name column used by Oracle Internet Directory to the employees and departments tables. |
Hr_dn_d.sql |
Drops the Oracle Internet Directory Distinguished Name column from employees and departments. |
Hr_drop.sql |
Drops the HR schema and all its objects. |
Hr_idx.sql |
Creates indexes on the HR tables. |
Hr_main.sql |
Main script for the HR schema; Calls other scripts. |
Hr_popul.sql |
Populates the objects. |
The hr_main.sq file is then executed on the Sql*plus.
A) Sql>@?/demo/schema/human_resources/hr_main.sql
b) Specify password for HR as parameter 1:
c) Enter value for 1:HR
d) Specify default Tablespeace for HR as parameter 2:
e) Enter value for 2:users
f) Specify temporary tablespace for HR as parameter 3:
g) Enter value for 3:temp
h) Specify password for SYS as parameter 4:
i) Enter value for 4:runner
j) Specify log path as parameter 5:
k) Enter value for 5:c:/oracle/product/10.1.0/db_1/rdbms/log ($oracle_home/rdbms/log if it is Linux)
You can use this command to see if the HR user has established success.
Desc dba_users;
Select username, account_status from dba_users;
Attachment address:
http://download.csdn.net/detail/fuzhangpeng/7712823