RE: where can I find sample db creation script (9.2.0.1.0 installation)?
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 $ 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 n
RE: where can I find sample db creation script (9.2.0.1.0 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 $ 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:/
Re: where can I find sample db creation script (9.2.0.1.0 installation)?
Hi, There's no db creation scripts for 9i seed database,9i DBCA uses template to create sample database.DBCA templates located in $ORACLE_HOME/assistants/dbca/templates,they are a set of XML files.If you want db creation scripts ,DBCA can be used to generate them. Regards, Zhai On Wed, 08 Oct 2003 18:39:31 -0800, Guang Mei <[EMAIL PROTECTED]> wrote: 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 On Wed, 8 Oct 2003, Bob Metelsky wrote: %ORACLEHOME%\rdbms\admin\build.db is one of them check this script which calls several others bob -Original Message- Sent: Wednesday, October 08, 2003 5:39 PM To: Multiple recipients of list ORACLE-L installation)? Hi: I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time. I let the installation to create a sample db. Now I am trying to see where I can find the db creation script, so I can study it and use it to create db instance manually. I can only find a bounch of log files in $ORACLE_ADMIN//create directory, such as cloneDBCreation.log lockAccount.log postDBCreation.log postScripts.log ultraSearchCfg.log So does anyone know where I can find the script? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Bob Metelsky INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhai Jingmin INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: where can I find sample db creation script (9.2.0.1.0 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 On Wed, 8 Oct 2003, Bob Metelsky wrote: > %ORACLEHOME%\rdbms\admin\build.db is one of them check this script which > calls several others > > bob > > -Original Message- > Sent: Wednesday, October 08, 2003 5:39 PM > To: Multiple recipients of list ORACLE-L > installation)? > > Hi: > > I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time. > I > let the installation to create a sample db. Now I am trying to see where > I > can find the db creation script, so I can study it and use it to create > db > instance manually. I can only find a bounch of log files in > $ORACLE_ADMIN//create directory, such as > > cloneDBCreation.log lockAccount.log postDBCreation.log > postScripts.log ultraSearchCfg.log > > > So does anyone know where I can find the script? Thanks. > > Guang > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Guang Mei > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Bob Metelsky > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: where can I find sample db creation script (9.2.0.1.0 installation)?
%ORACLEHOME%\rdbms\admin\build.db is one of them check this script which calls several others bob -Original Message- Sent: Wednesday, October 08, 2003 5:39 PM To: Multiple recipients of list ORACLE-L installation)? Hi: I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time. I let the installation to create a sample db. Now I am trying to see where I can find the db creation script, so I can study it and use it to create db instance manually. I can only find a bounch of log files in $ORACLE_ADMIN//create directory, such as cloneDBCreation.log lockAccount.log postDBCreation.log postScripts.log ultraSearchCfg.log So does anyone know where I can find the script? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Bob Metelsky INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).