Oracle10g/Admin Workshop1
Create Tablespace Syntax
클라인STR
2008. 6. 30. 12:26
CREATE TABLESPACE 테이블스페이스이름
DATAFILE '파일이름1', SIZE integer [M/K] reuse,
'파일이름2', SIZE integer [M/K]
........
[MINIMUM EXTENT integer [M/K]]
[BLOCKSIZE integer [K]]
[DEFAULT STORAGE (
INITIAL integer [M/K]
NEXT integer [M/K]
MAXEXTENTS integer
PCTINCREASE integer)]
[ONLINE | OFFLINE]
[LOGGING | NOLOGGING]
[PERMANENT | TEMPORARY]
[EXTENT MANAGEMENT
DICTIONARY | LOCAL
AUTOALLOCATE | UNIFORM SIZE integer [M/K]]
[SEGMENT SPACE MANAGEMENT (MANUAL/AUTO)]