ORACLE 12c 사용자 계정 생성

//아이디생성
CREATE USER C##ORA_SQL_TEST IDENTIFIED BY "1QAZ2WSX";


//권한부여
GRANT ALTER SYSTEM TO C##ORA_SQL_TEST;
GRANT CONNECT, RESOURCE TO C##ORA_SQL_TEST;
GRANT ALTER SYSTEM TO C##ORA_SQL_TEST;
GRANT SELECT ON V_$C##ORA_SQL_TEST;
GRANT SELECT ON V_$SQL_PLAN_STATISTICS_ALL TO C##ORA_SQL_TEST;
GRANT SELECT ON V_$SESSION TO C##ORA_SQL_TEST;
GRANT EXECUTE ON DBMS_STATS TO C##ORA_SQL_TEST;
GRANT SELECT ON DBA_SEGMENTS TO C##ORA_SQL_TEST;


## TEMP 영역 사이즈 확인.
SELECT T1.FILE_NAME,(T1.BYTES/1024/1024) TMP_MB
FROM DBA_TEMP_FILES T1;

##5.000MB보다 작다면 늘려줘야함.
ALTER DATABASE TEMPFILE 'C:\APP\WE\VIRTUAL\ORADATA\ORCL\TEMP01.DBF' RESIZE 5000M;