-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathCreat Tablespace.txt
More file actions
14 lines (7 loc) · 1.33 KB
/
Creat Tablespace.txt
File metadata and controls
14 lines (7 loc) · 1.33 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
CREATE SMALLFILE TABLESPACE "HSCMP_TBL" DATAFILE 'D:\ORADATA\hscmp\HSCMP_TBL' SIZE 20G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE SMALLFILE TABLESPACE "HSCMP_IDX" DATAFILE 'D:\ORADATA\HSCMP\HSCMP_IDX' SIZE 10G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE SMALLFILE TABLESPACE "HSCMP_TBL_LOG" DATAFILE 'D:\ORADATA\HSCMP\HSCMP_TBL_LOG' SIZE 3G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE SMALLFILE TABLESPACE "HSCMP_TBL_STK" DATAFILE 'D:\ORADATA\HSCMP\HSCMP_TBL_STK' SIZE 5G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE SMALLFILE TABLESPACE "HSCMP_TBL_SAL" DATAFILE 'D:\ORADATA\HSCMP\HSCMP_TBL_SAL' SIZE 15G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE SMALLFILE TEMPORARY TABLESPACE "HSCMP_TEMP" TEMPFILE 'D:\ORADATA\HSCMP\HSCMP_TEMP' SIZE 5G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
CREATE SMALLFILE TABLESPACE "HSCMP_COM" DATAFILE 'D:\ORADATA\HSCMP\HSCMP_COM' SIZE 2G AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO