//아이디생성
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;
'Oracle Database' 카테고리의 다른 글
[ORACLE] INSERT (0) | 2020.04.15 |
---|---|
[ORACLE] ALTER (0) | 2020.04.15 |
[ORALCE] 데이터형식 2 (0) | 2020.04.14 |
[ORACLE]데이터형식 (0) | 2020.04.14 |
ORACLE 12C 테이블 생성 (0) | 2020.04.04 |