先将附件的10个sql文件放入这个路径中：

%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.

然后在SQL*Plus上执行hr_main.sql这个文件：

@?\demo\schema\human_resources\hr_main.sql

Specify password for HR as parameter 1:

Enter value for 1: hr

Specify default tablespeace for HR as parameter 2:

Enter value for 2: users

Specify temporary tablespace for HR as parameter 3:

Enter value for 3: temp

Specify password for SYS as parameter 4:

Enter value for 4: welcome1

Specify log path as parameter 5:

Enter value for 5: d:\

human_resources.zip

ITPub博客

创建HR演示模式