oracle创建时无hr,创建HR演示模式

先将附件的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