There are
two check boxes at the end of the DBCA steps. One is to create a template, the other is to create scripts. The tricky thing about the 9i DBCA is
that the options are different if you choose New Database rather than the other
choices. I’ve checked and edited
the scripts after using the Create New Database option.
HTH,
David
Wagoner
-----Original
Message-----
From: Adams, Matthew (GECP, MABG,
088130) [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 01, 2002
12:59 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: creating a 9.2
database
I did this (create a template, exit and
re-run, select
template, go to step 7 (last screen)). Nowhere did I see an
option to have the script to a file. Do you know which
step this is found in?
----
Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 31, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: creating a 9.2 database
I must disagree. There is no
$ORACLE_HOME/admin/<SID>/scripts. There is no
admin directory under $ORACLE_HOME. In 9.2.0 you must create a
template
first by using the default configuration, save it, then exit the
OUI. Then
start it up again and use the existing template. Go through
the normal
prompts and then select the option to have it generate a shell
script file
near the end of the process. Have it save the script file in
a directory
of your choosing or it will put it in
$ORACLE_HOME/assistants/dbca/templates by default.
RWB
"Adriano Freire"
<[EMAIL PROTECTED]>@fatcity.com on 10/31/2002 02:59:10
PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
cc:
normally in
$ORACLE_HOME/admin/<SID>/scripts
----- Original Message -----
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 31, 2002 5:40 PM
I always like to create my databases by
hand via
the create database statement. However, whenever a new
version comes out I use the dbca assistant to generate the
create database script so I can see what Oracle does by
default (although I usually don't run this generated
script.)
I'm trying to do this with my new 9.2
installation, but
at the end (step 7), it doesn't seem to allow the
generation of the script without creating the database.
Is dbca creating a script to run and if
so, where is
it storing it?
9.2.0 on HP-UX 11i
Matt
----
Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
