Does anyone have any database creation scripts for oracle 7.3.4 on NT4 they could send me. It would be much appreciated.
(I actually need them for windows 2000 but I hope the NT ones would work ;-)
My email is
Mark_Blakey@cwb.com
Printable View
Does anyone have any database creation scripts for oracle 7.3.4 on NT4 they could send me. It would be much appreciated.
(I actually need them for windows 2000 but I hope the NT ones would work ;-)
My email is
Mark_Blakey@cwb.com
Here is a copy of what we use to create a 7.3.4 DB on NT. It is not much different than any other create command.
CREATE DATABASE DBNAME
LOGFILE GROUP 1 ('C:\LOG\SVLG1.TRN') SIZE 20M,
GROUP 2 ('C:\LOG\SVLG2.TRN') SIZE 20M
MAXLOGFILES 20
DATAFILE 'C:\ADM\SVSYS.TSP' SIZE 8M
reuse autoextend on next 1M
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1 ;
Hi OPC2b
This is a full script which I use to create a test database, you can change the values to suit yourself.
Remembering of course that you need to run the data dictionary scripts at the end.
Hope this helps
Kind Regards
Alison
-- CREATES THE TEST INSTANCE
D:\orant\bin\oradim73 -new -sid TEST -intpwd TEST -startmode auto -pfile D:\ORADATA\TEST\initTEST.ora
-- BUILDS THE TEST INSTANCE
startup nomount pfile=D:\ORADATA\TEST\INITTEST.ORA
CREATE database TEST
CHARACTER SET WE8ISO8859P1
CONTROLFILE REUSE
logfile GROUP 1 ('d:\oradata\test\log11.dbf','d:\oradata\test\log12.dbf') SIZE 2m reuse ,
GROUP 2 ('d:\oradata\test\log21.dbf','d:\oradata\test\log22.dbf') SIZE 2m reuse ,
GROUP 3 ('d:\oradata\test\log31.dbf','d:\oradata\test\log32.dbf') SIZE 2m reuse ,
GROUP 4 ('d:\oradata\test\log41.dbf','d:\oradata\test\log42.dbf') SIZE 2m reuse
DATAFILE 'D:\ORADATA\TEST\SYSTEM01.DBF' SIZE 15M;
-- BUILDS THE TEST DATABASE
-- CREATE TEMPORARY ROLLBACK SEGMENT IN SYSTEM TABLESPACE
create rollback segment r0 tablespace system
storage(initial 16k next 16k minextents 2 maxextents 20 );
-- PLACE R0 ONLINE
alter rollback segment r0 online;
-- CREATE ROLLBACK TABLESPACE
create tablespace RBS
datafile 'D:\ORADATA\TEST\RBS01.DBF' SIZE 50M
default storage (
initial 104k
NEXT 104k
minextents 1
maxextents 505);
--CREATE ROLLBACK SEGMENTS
CREATE ROLLBACK segment R01 tablespace RBS storage(initial 5120K NEXT 1024K minextents 4 );
CREATE ROLLBACK segment R02 tablespace RBS storage(initial 5120K NEXT 1024K minextents 4 );
CREATE ROLLBACK segment R03 tablespace RBS storage(initial 5120K NEXT 1024K minextents 4 );
CREATE ROLLBACK segment R04 tablespace RBS storage(initial 5120K NEXT 1024K minextents 4 );
alter rollback segment R01 online;
alter rollback segment R02 online;
alter rollback segment R03 online;
alrer rollback segment R04 online;
--CREATE ADDITIONAL TABLESPACES
create tablespace TEMPORARY_DATA
datafile 'D:\ORADATA\TEST\TEMP01.DBF' SIZE 20m
default storage (
initial 104k
NEXT 104k
minextents 1
maxextents 505);
create tablespace USER_DATA
datafile 'D:\ORADATA\TEST\USER01.DBF' SIZE 50m
default storage (
initial 800k
NEXT 800k
minextents 1
maxextents 505);
CREATE tablespace USER_INDEX
datafile 'D:\ORADATA\TEST\INDEX01.DBF' SIZE 50m
default storage (
initial 104k
NEXT 104k
minextents 1
maxextents 505);
-- DON'T REQUIRE R0 ANYMORE
alter rollback segment r0 offline;
drop rollback segment r0;
many thanks
Thanks ALISON.
Actually, our create database process includes many more batch/sql files. I only posted the "create" command. I like your response better. More information.