Persiapan Praktikum Pemrograman Basis Data: Install Oracle Database & SQL Developer + HR Schema

Описание: NOTES:

1. 6:24: Itu konfirmasi password ya, jadi 2 inputan itu harus sama isinya.

RESOURCES:

1. Oracle Database: https://www.oracle.com/database/free/...
2. SQL Developer: https://www.oracle.com/database/sqlde...
3. HR Schema: https://github.com/oracle-samples/db-...

CREATE TABLESPACE:

CREATE TABLESPACE spaceq
DATAFILE 'C:\app\{user}\product\23ai\oradata\FREE\spaceq01.dbf' SIZE 100M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;

IMPORT HR SCHEMA:

@{abs_path}\human_resources\hr_install.sql