I am creating a new database in 8.1.7 through a batch file the details of which are given below:

createdb.bat
----
orapwd file=%ORACLE_HOME%/DATABASE/PWDCBK.ORA PASSWORD=ORACLE ENTRIES=20
set ORACLE_SID=cbk
echo off
cls

@%ORACLE_HOME%\bin\oradim -new -sid CBK -startmode manual -pfile %ORACLE_BASE%\admin\cbk\pfile\init.ora
set termout off

@%ORACLE_HOME%\bin\svrmgrl @%DBS_HOME%\Create\cbkrun.sql
@%ORACLE_HOME%\bin\svrmgrl @%DBS_HOME%\Create\cbkrun1.sql
@%ORACLE_HOME%\bin\svrmgrl @%DBS_HOME%\Create\cbkalterTablespace.sql

echo Running Script "user.sql"... Creating DBA User
echo off
@%ORACLE_HOME%\bin\svrmgrl @%DBS_HOME%\Create\user.sql

echo Running Script "cr_cbkdb.sql"...
echo off
@%ORACLE_HOME%\bin\svrmgrl @%DBS_HOME%\Create\cr_cbkdb.sql

echo Configuring Database to run as a Service...
echo off
@%ORACLE_HOME%\bin\oradim -EDIT -SID cbk -INTPWD sluggo -STARTMODE auto -pfile %ORACLE_BASE%\admin\cbk\pfile\init.ora

@%ORACLE_HOME%\bin\oradim -startup -sid cbk -starttype srvc,inst -pfile %ORACLE_BASE%\admin\cbk\pfile\init.ora
------------

The execution of files

1. cbkrun.sql
2. cbkrun1.sql
3. cbkalterTablespace.sql

takes around 38 minutes on A pIII 450 MHZ MACHINE.

Can this time be reduced.

Script files are attached.


cbkrun.sql

---
--//spool '%ORACLE_BASE%\admin\cbk\create\createdb'
set echo on
set termout off
connect INTERNAL/oracle
shutdown immediate;
startup nomount pfile = %ORACLE_BASE%\admin\cbk\pfile\init.ora
set echo off
--//Defect 66050 - Santosh 02/11/2003
--//Defect Summary: MF- QO 1.0.0.4 SQL scripts have "set echo on" which causes the
--installation to take 1.5+ hrs to complete.
--//Search String: "QO_66050"

CREATE DATABASE cbk
LOGFILE '%ORACLE_BASE%\oradata\cbk\redo01.log' SIZE 1024K,
'%ORACLE_BASE%\oradata\cbk\redo02.log' SIZE 1024K,
'%ORACLE_BASE%\oradata\cbk\redo03.log' SIZE 1024K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE '%ORACLE_BASE%\oradata\cbk\system01.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 10240K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET utf8
NATIONAL CHARACTER SET utf8;

set echo off
--spool off
------
bkrun1.sql

-----
--//spool %ORACLE_BASE%\admin\cbk\create\createdb1

set echo off
set termout off
--//Defect 66050 /66981 - Santosh 02/11/2003
--//Defect Summary: MF- QO 1.0.0.4 SQL scripts have "set echo on" which causes the
--installation to take 1.5+ hrs to complete.
--//Search String: "QO_66050/ QO_66981"

connect INTERNAL/oracle

REM ********** ALTER SYSTEM TABLESPACE *********
ALTER TABLESPACE SYSTEM
DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50);
ALTER TABLESPACE SYSTEM
MINIMUM EXTENT 64K;

REM ********** TABLESPACE FOR ROLLBACK **********
CREATE TABLESPACE RBS DATAFILE '%ORACLE_BASE%\oradata\cbk\rbs01.dbf' SIZE 520M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);

REM ********** TABLESPACE FOR USER **********
CREATE TABLESPACE USERS DATAFILE '%ORACLE_BASE%\oradata\cbk\users01.dbf' SIZE 108M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);

REM ********** TABLESPACE FOR TEMPORARY **********
CREATE TABLESPACE TEMP DATAFILE '%ORACLE_BASE%\oradata\cbk\temp01.dbf' SIZE 72M REUSE
AUTOEXTEND ON NEXT 640K
MINIMUM EXTENT 64K
DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) TEMPORARY;

REM ********** TABLESPACE FOR Tools **********
CREATE TABLESPACE TOOLS DATAFILE '%ORACLE_BASE%\oradata\cbk\tools01.dbf' SIZE 12M REUSE
AUTOEXTEND ON NEXT 320K
MINIMUM EXTENT 32K
DEFAULT STORAGE ( INITIAL 32K NEXT 32K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);

REM ********** TABLESPACE FOR INDEX **********
CREATE TABLESPACE INDX DATAFILE '%ORACLE_BASE%\oradata\cbk\indx01.dbf' SIZE 58M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);

CREATE PUBLIC ROLLBACK SEGMENT RBS0 TABLESPACE RBS
STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS1 TABLESPACE RBS
STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS2 TABLESPACE RBS
STORAGE ( OPTIMAL 4096K );
ALTER ROLLBACK SEGMENT "RBS0" ONLINE;
ALTER ROLLBACK SEGMENT "RBS1" ONLINE;
ALTER ROLLBACK SEGMENT "RBS2" ONLINE;
alter user sys temporary tablespace TEMP;
@%ORACLE_HOME%\Rdbms\admin\catalog.sql;
@%ORACLE_HOME%\Rdbms\admin\catexp7.sql
@%ORACLE_HOME%\Rdbms\admin\catproc.sql
@%ORACLE_HOME%\Rdbms\admin\caths.sql
connect system/manager
@%ORACLE_HOME%\sqlplus\admin\pupbld.sql
connect INTERNAL/oracle
@%ORACLE_HOME%\Rdbms\admin\utlsampl.sql
connect INTERNAL/oracle
set echo off
--spool off
-----------
cbkaltertablespace.sql
connect internal/oracle
alter user system default tablespace TOOLS;
alter user system temporary tablespace TEMP;
set echo off