Creat Tablespace.txt

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