| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: creating a 9.2 database
Did you run 9.0 or 9.2? The last page for my installer
has two check boxes
-----Original Message-----
Sent: Friday, November 01, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L
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-----
Sent: Friday, November 01, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
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?
-----Original Message-----
[ mailto:Reginald.W.Bailey_at_jpmorgan.com
<mailto:Reginald.W.Bailey_at_jpmorgan.com> ]
Sent: Thursday, October 31, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
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" <adriano.f_at_uol.com.br>@fatcity.com on 10/31/2002 02:59:10 PM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.comReceived on Fri Nov 01 2002 - 14:15:10 CST
<http://www.orafaq.com>
-- Author: INET: Reginald.W.Bailey_at_jpmorgan.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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.com -- Author: Adams, Matthew (GECP, MABG, 088130) INET: MATT.ADAMS_at_APPL.GE.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).
 |
 |