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方案，考试时会提供，我这里没有，故手动创建了一个简单的。

[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.