Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: where can I find sample db creation script (9.2.0.1.0 installation)?

RE: where can I find sample db creation script (9.2.0.1.0 installation)?

From: Guang Mei <gmei_at_incyte.com>
Date: Thu, 09 Oct 2003 07:29:30 -0800
Message-ID: <F001.005D290D.20031009072930@fatcity.com> 





Which oracle version is your buildall.sql for? I just queried my 9i db and
got this:



SQL> select TABLESPACE_NAME from dba_tablespaces;



TABLESPACE_NAME





SYSTEM



UNDOTBS1



TEMP



CWMLITE



DRSYS



EXAMPLE



INDX



ODM



TOOLS



USERS



XDB



Where is "Undo" tablespace part in your buildall.sql?



Guang



-----Original Message-----


Bob Metelsky


Sent: Thursday, October 09, 2003 9:54 AM
To: Multiple recipients of list ORACLE-L
installation)?




Yes Im on Windows xp the script names and dir structure should be the
same though...



Here is buildall.sql


######## buildall.sql  ################




spool \build.log


SET TERMOUT OFF



SET ECHO OFF



connect internal


@@build_db.sql

@C:\oracle\ora81\RDBMS\admin\catalog.sql

@C:\oracle\ora81\RDBMS\admin\catsnmp.sql

connect internal


@C:\oracle\ora81\RDBMS\admin\catexp7.sql

@C:\oracle\ora81\RDBMS\admin\catproc.sql

@@scott.sql



connect internal


@@demo.sql



connect system/manager


@C:\oracle\ora81\RDBMS\admin\catdbsyn.sql

@C:\oracle\ora81\SQLPLUS\admin\pupbld.sql

connect internal


@C:\oracle\ora81\RDBMS\admin\caths.sql

@C:\oracle\ora81\RDBMS\admin\oramts.sql



connect internal


alter rollback segment rb_temp offline;


shutdown;


spool off

##########################################

########## build_db.sql ##################



--
-- $Header: build_db.sql 1.1 94/10/18 15:55:37 gdudey
Osd<desktop/netware> $ Copyr (c) 1994 Oracle
--
-- This file must be run out of the directory containing the
-- initialization file.

startup nomount pfile=\%AVAILABLE_SID%\pfile\initsmpl.ora

--  Create database

create database %AVAILABLE_SID%
    controlfile reuse
    logfile '%seedl_path%\%AVAILABLE_SID%\redo01.log' size %seedl_size%M
reuse,
            '%seedl_path%\%AVAILABLE_SID%\redo02.log' size %seedl_size%M
reuse,
            '%seedl_path%\%AVAILABLE_SID%\redo03.log' size %seedl_size%M
reuse,
            '%seedl_path%\%AVAILABLE_SID%\redo04.log' size %seedl_size%M
reuse
    datafile '%seedd_path%\%AVAILABLE_SID%\system01.dbf' size
%seedd_sysi_size%M reuse autoextend on
      next %seedd_syse_size%M maxsize %seedd_sysm_size%M
    character set %seed_charset%;

create rollback segment rb_temp storage (initial 100 k next 250 k);

-- Create additional tablespaces ...

-- USERs: Create user sets this as the default tablespace
-- TEMP: Create user sets this as the temporary tablespace
-- RBS: For rollback segments

create tablespace users
    datafile '%seedd_path%\%AVAILABLE_SID%\users01.dbf' size
%seedd_usri_size%M reuse autoextend on
      next %seedd_usre_size%M maxsize %seedd_usrm_size%M;
create tablespace rbs
    datafile '%seedd_path%\%AVAILABLE_SID%\rbs01.dbf' size
%seedd_rbsi_size%M reuse autoextend on
      next %seedd_rbse_size%M maxsize %seedd_rbsm_size%M;
create temporary tablespace temp
    tempfile '%seedd_path%\%AVAILABLE_SID%\temp01.dbf' size
%seedd_tmpi_size%M reuse autoextend on
      next %seedd_tmpe_size%M maxsize %seedd_tmpm_size%M;
create tablespace oem_repository
    datafile '%seedd_path%\%AVAILABLE_SID%\oemrep01.dbf' size
%seedd_usri_size%M reuse autoextend on
      next %seedd_usre_size%M maxsize %seedd_usrm_size%M;
create tablespace indx
    datafile '%seedd_path%\%AVAILABLE_SID%\indx01.dbf' size
%seedd_tmpi_size%M reuse autoextend on
      next %seedd_tmpe_size%M maxsize %seedd_tmpm_size%M;
--      next %seedd_usre_size%M maxsize %seedd_usrm_size%M;
alter rollback segment rb_temp online;

-- Change the SYSTEM users' password, default tablespace and
-- temporary tablespace.

alter user system temporary tablespace temp;
alter user system default tablespace users;

-- Create 16 rollback segments.  Allows 16 concurrent users with open
-- transactions updating the database. This should be enough.

create public rollback segment rb1 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb2 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb3 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb4 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb5 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb6 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb7 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb8 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb9 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb10 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb11 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb12 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb13 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb14 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb15 storage(initial 50K next 250K)
  tablespace rbs;
create public rollback segment rb16 storage(initial 50K next 250K)
  tablespace rbs;
#############################################

-----Original Message-----
Sent: Wednesday, October 08, 2003 10:40 PM
To: Multiple recipients of list ORACLE-L
installation)?

Hi:

I am on unix and I can not find the file you menetioned. Looks like your
box is Microsoft one.

essex$ pwd
/oracle/product/9.2.0.1.0/rdbms/admin
essex$ ls -l b*
b*: No such file or directory

Guang

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Received on Thu Oct 09 2003 - 10:29:30 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US