1. TABLESPACE 생성
|
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLESPACE MY_SPACE DATAFILE
'MY_SPACE' SIZE 2048M AUTOEXTEND ON NEXT 4M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT
MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;
|
cs |
Tablespace의 이름을 MY_SPACE로,
크기는 2G 이며 초과시 자동으로 4M씩 증가
2. USER생성
|
1
2
3
4
|
CREATE USER JWKIM IDENTIFIED BY JWKIM1234
DEFAULT TABLESPACE MY_SPACE
PROFILE DEFAULT
QUOTA UNLIMITED ON MY_SPACE
|
cs |
JWKIM / JWKIM1234 유저를 MY_SPACE에 생성
3. GRANT
|
1
2
3
4
|
GRANT "CONNECT" TO JWKIM WITH ADMIN OPTION;
GRANT "DBA" TO JWKIM WITH ADMIN OPTION;
GRANT "RESOURCE" TO JWKIM WITH ADMIN OPTION;
ALTER USER JWKIM DEFAULT ROLE "CONNECT", "DBA", "RESOURCE";
|
cs |
JWKIM유저에 CONNECT, DBA, RESOURCE 권한 부여
4. DROP (USER, TABLE)
|
1
2
3
4
5
|
/*유저 삭제*/
DROP USER TESTER CASCADE;
/*TABLESPACE 삭제*/
DROP TABLESPACE TEST_UP INCLUDING CONTENTS AND DATAFILES;
|
cs |
오라클 Tablespace 생성, User 생성 방법
1. TABLESPACE 생성 CREATE TABLESPACE TEST_UP DATAFILE 'TEST_UP' SIZE 2048M AUTOEXTEND ON NEXT 4M MAXSIZE UNLIMITED LOGGING PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE M..
fillin.tistory.com