renduoa 发表于 2015-11-9 11:56:13

OCM_Session1_7_Schema Creation

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方案,考试时会提供,我这里没有,故手动创建了一个简单的。
$ mkdir -p /home/oracle/scripts/$ cd /home/oracle/scripts/$ vi create_bishhr.sqlcreate user hr identified by hr;grant connect,resource to hr;~~"create_bishhr.sql" 3L, 64C written                                                                              $
SQL> @/home/oracle/scripts/create_bishhr.sql   
User created.

Grant succeeded.
         版权声明:本文为博主原创文章,未经博主允许不得转载。
页: [1]
查看完整版本: OCM_Session1_7_Schema Creation