oracle 18c installation sample schema

오라클 설치를 하였으니
테스트용으로 HR 샘플 스키마를 설치한다.

oracle@solaris:~$ sqlplus sys as sysdba

Connected to:

SQL*Plus: Release 18.0.0.0.0 - Production on Sun Dec 2 06:50:10 2018

Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.   All rights reserved.

Enter password:

Connected to:

Oracle Database 18c Enterprise Edtion Release 18.0.0.0.0 - Production

Version 18.3.0.0.0

SQL> alter session set "_ORACLE_SCRIPT"=true;    -- 이걸 안해주면 아래와 같은 오류가 발생한다.

-- ora-20000 schema hr does not exist or insufficient privileges

SQL> @?/demo/schema/human_resources/hr_main.sql

specify password for HR as parameter 1:

Enter value for 1: hr

specify default tablespace for HR as parameter 2:

Enter value for 2: users

specify temporary tablespace for HR as parameter 3:

Enter value for 3: temp

specify log path as parameter 4:

Enter value for 4: $ORACLE_HOME/demo/schema/log/

……

Comment created.

Commit complete.

PL/SQL procedure successfully completed.

SQL>