|
Oracle的 HR 样例用户的建立
1、oracle 11g 中hr用户需要单独安装，比较麻烦，书本上学习例子很多都是HR用户的案例 ，下载后释放到 $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 theHRobjects.
hr_dn_c.sql
Adds the distinguished name column used by Oracle Internet Directory to theemployeesanddepartmentstables.
hr_dn_d.sql
Drops the Oracle Internet Directory distinguished name column fromemployeesanddepartments.
hr_drop.sql
Drops theHRschema and all its objects.
hr_idx.sql
Creates indexes on theHRtables.
hr_main.sql
Main script for theHRschema; calls other scripts.
hr_popul.sql
Populates the objects.
2、[oracle@OCM]$sqlplus / as sysdba;
3、执行$ORACLE_HOME/demo/schema/human_resources/下的hr_main.sql
SQL>@?/demo/schema/human_resources/hr_main.sql
注：
1、安装前需要使用root用户对human_resources下的文件执行：chmod 777 *。
2、安装前需要确定5个参数。分别是：
HR用户的密码：dbbocom；
默认用户空间：users。（必须是已经存在的用户空间）
临时用户空间：temp。（必须是已经存在的用户空间）
SYS用户的密码：dbbocom
日志文件存放的目录：$ORACLE_HOME/RDBMS/log
HR人事管理数据库下载地址：
http://down.51cto.com/data/1037205
或者：
http://download.csdn.net/detail/johnlxj/6689713
SQL> @?/demo/schema/human_resources/hr_main.sql
specify password for HR as parameter 1:
Enter value for 1: dbbocom
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: dbbocom
specify log path as parameter 5:
Enter value for 5: /home/oracle/app/oracle/
DROP USER hr CASCADE
*
ERROR at line 1:
ORA-01918: user 'HR' does not exist
old 1: CREATE USER hr IDENTIFIED BY &pass
new 1: CREATE USER hr IDENTIFIED BY dbbocom
User created.
old 1: ALTER USER hr DEFAULT TABLESPACE &tbs
new 1: ALTER USER hr DEFAULT TABLESPACE users
old 2: QUOTA UNLIMITED ON &tbs
new 2: QUOTA UNLIMITED ON users
User altered.
old 1: ALTER USER hr TEMPORARY TABLESPACE &ttbs
new 1: ALTER USER hr TEMPORARY TABLESPACE temp
…
PL/SQL procedure successfully completed.
...
PL/SQL procedure successfully completed.
检查是否正确安装完毕
SQL> show user
USER is "HR"
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
