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