首页 > 其他 > 详细

OCM_Session1_7_Schema Creation

时间:2014-03-19 17:33:01      阅读:336      评论:0      收藏:0      [点我收藏+]


7. Schema Creation
 7.1 As user SYS, run the script /home/oracle/scripts/create_bishhr.sql Ignore any errors concerning OE. But do not ignore any other errors.



7. Schema Creation
  •  7.1 As user SYS, run the script /home/oracle/scripts/create_bishhr.sql Ignore any errors concerning OE. But do not ignore any other errors.

此题主要是跑/home/oracle/scripts/create_bishhr.sql这个脚本,这个脚本主要是创建hr方案,考试时会提供,我这里没有,故手动创建了一个简单的。

[oracle@ocm1 admin]$ mkdir -p /home/oracle/scripts/
[oracle@ocm1 admin]$ cd /home/oracle/scripts/
[oracle@ocm1 scripts]$ vi create_bishhr.sql
create user hr identified by hr;
grant connect,resource to hr;
~
~
"create_bishhr.sql" [New] 3L, 64C written                                                                              
[oracle@ocm1 scripts]$ 

SQL> @/home/oracle/scripts/create_bishhr.sql   

User created.


Grant succeeded.

OCM_Session1_7_Schema Creation,布布扣,bubuko.com

OCM_Session1_7_Schema Creation

原文:http://blog.csdn.net/rlhua/article/details/21538909

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!