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 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. |
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"
另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。