CREATE TABLESPACE & CREATE USER

CREATE TABLESPACE [TABLESPACE DATA NAME]

DATAFILE 'D:\app\Administrator\oradata\orcl\[DATA FILE NAME].DBF' SIZE 1024M -- 경로변경가능

AUTOEXTEND ON NEXT 512M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

 

CREATE TABLESPACE [TABLESPACE INDEX NAME]

DATAFILE 'D:\app\Administrator\oradata\orcl\[INDEX FILE NAME].DBF' SIZE 1024M -- 경로변경가능

AUTOEXTEND ON NEXT 512M

SEGMENT SPACE MANAGEMENT AUTO;

 

CREATE USER [사용자계정] IDENTIFIED BY [계정비밀번호]

DEFAULT TABLESPACE [TABLESPACE DATA NAME]

TEMPORARY TABLESPACE temp;

 

ALTER USER [사용자계정] QUOTA UNLIMITED ON [TABLESPACE DATA NAME];

ALTER USER [사용자계정] QUOTA UNLIMITED ON TABLESPACE INDEX NAME];

 

GRANT connect, resource, dba (그외 권한 및 롤 들) TO [사용자계정];