SET TERMOUT ON
SET ECHO OFF
SET VERIFY OFF
SET LINESIZE 300
SET PAGESIZE 75

SPOOL 09_creating_TS.log

ACCEPT Server PROMPT 'Enter DATABASE name (default - MAGICASH): ' DEFAULT MAGICASH
ACCEPT SYSpsw PROMPT 'Enter SYS password: ' DEFAULT NCTSYS

CONNECT SYS/&SYSpsw@&Server AS SYSDBA


prompt ******* MG_TABLE *******
 
CREATE TABLESPACE MG_TABLE DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_TABLE.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;


prompt ******* MG_INDX_LARGE *******

CREATE TABLESPACE MG_INDX_LARGE DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_INDX_LARGE01.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;

ALTER TABLESPACE MG_INDX_LARGE ADD DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_INDX_LARGE02.DBF' size 1000M autoextend on next 1000M maxsize unlimited;


prompt ******* MG_INDX *******

CREATE TABLESPACE MG_INDX DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_INDX.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;


prompt ******* MG_TABLE_LARGE *******

CREATE TABLESPACE MG_TABLE_LARGE DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_TABLE_LARGE01.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;

ALTER TABLESPACE MG_TABLE_LARGE ADD DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_TABLE_LARGE02.DBF' size 1000M autoextend on next 1000M maxsize unlimited;


prompt ******* MG_LOB *******

CREATE TABLESPACE MG_LOB DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_LOB.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;


prompt ******* MG_TABLE_JOURNAL_PC *******

CREATE TABLESPACE MG_TABLE_JOURNAL_PC DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_TABLE_JOURNAL_PC01.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;

ALTER TABLESPACE MG_TABLE_JOURNAL_PC ADD DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_TABLE_JOURNAL_PC02.DBF' size 1000M autoextend on next 1000M maxsize unlimited;


prompt ******* MG_INDX_JOURNAL_PC *******

CREATE TABLESPACE MG_INDX_JOURNAL_PC DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_INDX_JOURNAL_PC01.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;

ALTER TABLESPACE MG_INDX_JOURNAL_PC ADD DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_INDX_JOURNAL_PC02.DBF' size 1000M autoextend on next 1000M maxsize unlimited;



prompt ******* MG_INDX_JOURNAL_ROC *******

CREATE TABLESPACE MG_INDX_JOURNAL_ROC DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_INDX_JOURNAL_ROC01.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;

ALTER TABLESPACE MG_INDX_JOURNAL_ROC ADD DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_INDX_JOURNAL_ROC02.DBF' size 1000M autoextend on next 1000M maxsize unlimited;



prompt ******* MG_TABLE_JOURNAL_ROC *******

CREATE TABLESPACE MG_TABLE_JOURNAL_ROC DATAFILE
  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_TABLE_JOURNAL_ROC01.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;

ALTER TABLESPACE MG_TABLE_JOURNAL_ROC ADD DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\MAGPC\MG_TABLE_JOURNAL_ROC02.DBF' size 1000M autoextend on next 1000M maxsize unlimited;












 
SPOOL OFF
SET TERMOUT ON
SET ECHO ON
SET SHOW ON
SET VER ON
EXIT