Oracle HR 样例数据库用户的建立

先将附件上的10个.sql文件放入这个路径中:

E:/oracle/product/10.1.0/db_1/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>@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 tablespeacefor HR as parameter 2:

e)  Enter value for 2: users

f)  Specify temporary tablespacefor 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 asparameter 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 文件在我的资源下载中有，名字是Oracle HR Schema

可以去下载 然后 里面有附有说明文档。

下载地址：

http://download.csdn.net/source/3228255