Oracle 7.3.4 NT 4.0 Database create scripts
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle 7.3.4 NT 4.0 Database create scripts

  1. #1
    Join Date
    Aug 2000
    Posts
    143
    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

  2. #2
    Join Date
    Sep 2001
    Posts
    163
    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 ;

  3. #3
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    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;

  4. #4
    Join Date
    Aug 2000
    Posts
    143

    Smile

    many thanks

  5. #5
    Join Date
    Sep 2001
    Posts
    163
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width