Oracle HR 样例用户的建立 10g,11g均可

来源：互联网发布：steinberg ur22 mac 编辑：程序博客网时间：2024/06/09 22:25

先将附件(见文章尾部)上的 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.sq 这个文件。

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 (如果是Linux下的话就$ORACLE_HOME/rdbms/log)

可以通过此命令来查看 HR 用户是否已经建立成功。

desc dba_users;

Select username, account_status from dba_users;

附件地址：

http://download.csdn.net/detail/fuzhangpeng/7712823

0 0