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.
This question is mainly about running
/Home/oracle/scripts/create_bishhr. SQL. This script is mainly used to create the hr solution. It will be provided during the examination. I don't have it here, so I created a simple one manually.
[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.
