Oracle

Subsections of Oracle

How to create DB

Modify following script with your user/password (database will be created with same name as username)

ALTER SESSION SET "_ORACLE_SCRIPT"=true;

CREATE USER username IDENTIFIED BY "password";
GRANT CONNECT TO username;
GRANT CONNECT, RESOURCE TO username;
GRANT CREATE SESSION TO username;
GRANT UNLIMITED TABLESPACE TO username;
GRANT SELECT ON SYS.DBA_RECYCLEBIN TO username;

QUIT

script can be run as:

sqlplus sys/sys_password@hostname:1521/ORCLCDB as SYSDBA @/oracle-init.sql;

How to drop DB

ALTER SESSION SET "_ORACLE_SCRIPT"=true;

DROP USER username CASCADE;

QUIT

script can be run as:

sqlplus sys/sys_password@hostname:1521/ORCLCDB as SYSDBA @/oracle-init.sql;