[oracle] TABLESPACE 생성, 사용자 생성 및 권한

- TABLESPACE 생성CREATE TABLESPACE TABLESPACE_NAME LOGGING DATAFILE 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/TABLESPACE_NAME.DBF' SIZE 4096M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

 

- TEMP TABLESPACE 생성CREATE TEMPORARY TABLESPACE RAISE_TEMP TEMPFILE 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/TABLESPACE_NAME_TEMP.DBF' SIZE 1024M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

 

- USER 생성CREATE USER 아이디 IDENTIFIED BY 패스워드 DEFAULT TABLESPACE TABLESPACE명 TEMPORARY TABLESPACE TEMP_TABLESPACE명 QUOTA UNLIMITED ON TABLESPACE명;

 

- USER 권한GRANT CONNECT, RESOURCE, DBA TO 아이디;