先将附件上的 10 个 .sql 文件放入这个路径中 :
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.sq 这个文件。
a) SQL>@e:\oracle\product\10.1.0\db_1\demo\schema\human_resources\hr_main.sq
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: welcome1
j) Specify log path as parameter 5:
k) Enter value for 5: C:\oracle\product\10.1.0\db_1\RDBMS\log
可以通过此命令来查看 HR 用户是否已经建立成功。
desc dba_users;
Select username, account_status from dba_users;
备注：关于 这个样例数据库用户的 script 文件下载
密码：www.muu.cc
在 2011年LinuxIDC.com\4月\Oracle HR 样例数据库用户的建立
下载方法见 http://www.linuxidc.net/thread-1187-1-1.html