- Notifications
You must be signed in to change notification settings - Fork 849
/
Copy path01_setup12c.sql
17 lines (15 loc) · 562 Bytes
/
01_setup12c.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
-- DISCLAIMER:
-- This script is provided for educational purposes only. It is
-- NOT supported by Oracle World Wide Technical Support.
-- The script has been tested and appears to work as intended.
-- You should always run new scripts initially
-- on a test instance.
set echo off
connect /as sysdba
REM To allow for re-execution of this script,
REM the user is first dropped, then created.
dropuser aczm12c cascade;
set echo on
createuseraczm12c identified by oracle_4U;
alteruser aczm12c default tablespace users;
grant connect, dba to aczm12c;