您好,欢迎来到智榕旅游。
搜索
您的当前位置:首页OCM_Session1_7_SchemaCreation

OCM_Session1_7_SchemaCreation

来源:智榕旅游

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_b



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, C written [oracle@ocm1 scripts]$
SQL> @/home/oracle/scripts/create_bishhr.sql
User created.

Grant succeeded.

Copyright © 2019- zrrp.cn 版权所有 赣ICP备2024042808号-1

违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务