REM /*******************************************************/ REM /* Create statements for all other tablespaces */ REM /*******************************************************/ spool orainst3.log CREATE TABLESPACE work01 DATAFILE '/h/oradata1/$ORACLE_SID/$ORACLE_SID}_work01.dbf' SIZE 500M, '/h/oradata2/$ORACLE_SID/$ORACLE_SID}_work02.dbf' SIZE 500M DEFAULT STORAGE(INITIAL 10K NEXT 10K PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121); CREATE TABLESPACE index01 DATAFILE '/h/oradata1/$ORACLE_SID/$ORACLE_SID}_index01.dbf' SIZE 500M, '/h/oradata2/$ORACLE_SID/$ORACLE_SID}_index02.dbf' SIZE 500M, '/h/oradata3/$ORACLE_SID/$ORACLE_SID}_index03.dbf' SIZE 500M DEFAULT STORAGE(INITIAL 10K NEXT 10K PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121); CREATE TABLESPACE RBS DATAFILE '/h/oradata1/$ORACLE_SID/$ORACLE_SID}_rbs01.dbf' SIZE 50M, '/h/oradata3/$ORACLE_SID/$ORACLE_SID}_rbs02.dbf' SIZE 50M DEFAULT STORAGE(INITIAL 1M NEXT 1M PCTINCREASE 1 MINEXTENTS 2 MAXEXTENTS 121); CREATE TABLESPACE TEMP DATAFILE '/h/oradata1/$ORACLE_SID/$ORACLE_SID}_temp01.dbf' SIZE 50M, '/h/oradata2/$ORACLE_SID/$ORACLE_SID}_temp02.dbf' SIZE 50M DEFAULT STORAGE(INITIAL 256K NEXT 256K PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121); CREATE TABLESPACE tools DATAFILE '/h/oradata3/$ORACLE_SID/$ORACLE_SID}_tools01.dbf' SIZE 15M DEFAULT STORAGE(INITIAL 10K NEXT 10K PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121); CREATE TABLESPACE users DATAFILE '/h/oradata3/$ORACLE_SID/$ORACLE_SID}_users01.dbf' SIZE 30M DEFAULT STORAGE(INITIAL 10K NEXT 10K PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121); CREATE TABLESPACE ISA01 DATAFILE '/h/oradata3/$ORACLE_SID/$ORACLE_SID}_isa01.dbf' SIZE 50M DEFAULT STORAGE(INITIAL 10K NEXT 10K PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121); CREATE TABLESPACE Des2 DATAFILE '/h/oradata2/$ORACLE_SID/$ORACLE_SID}_des201.dbf' SIZE 15M DEFAULT STORAGE(INITIAL 10K NEXT 10K PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121); CREATE TABLESPACE Des2_I DATAFILE '/h/oradata3/$ORACLE_SID/$ORACLE_SID}_des2_i01.dbf' SIZE 15M DEFAULT STORAGE(INITIAL 10K NEXT 10K PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121); REM /*******************************************************/ REM /* Creation of PUBLIC Rollback Segments */ REM /*******************************************************/ DROP ROLLBACK SEGMENT R01; CREATE ROLLBACK SEGMENT R01 TABLESPACE RBS STORAGE(INITIAL 1M NEXT 1M OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 121); DROP ROLLBACK SEGMENT R02; CREATE ROLLBACK SEGMENT R02 TABLESPACE RBS STORAGE(INITIAL 1M NEXT 1M OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 121); DROP ROLLBACK SEGMENT R03; CREATE ROLLBACK SEGMENT R03 TABLESPACE RBS STORAGE(INITIAL 1M NEXT 1M OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 121); DROP ROLLBACK SEGMENT R04; CREATE ROLLBACK SEGMENT R04 TABLESPACE RBS STORAGE(INITIAL 1M NEXT 1M OPTIMAL 2M MINEXTENTS 2 MAXEXTENTS 121); DROP ROLLBACK SEGMENT R_BIG; CREATE ROLLBACK SEGMENT R_BIG TABLESPACE RBS STORAGE(INITIAL 5M NEXT 5M MINEXTENTS 2 MAXEXTENTS 121); spool off exit