RE: CREATE DATABASE scripts

I did something similar on 9i recently and I believe there was a check button in DBCA for Create Scripts, in addition to Create Template. Did you follow DBCA through to the last screen? I think it is there.

I tried to use the 9i DBCA to create a custom database with rollback segments instead of the UNDO tablespace, 3 uniform extent sizes, custom tablespaces, locally managed tablespaces, etc. and it crashed & burned every time. A couple weeks of Oracle support and they got nowhere!

Moral of the story: you are correct to generate scripts!

HTH, david

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110
Durham, NC 27703
Tel. (919) 941-4645
Fax (919) 474-0735
Email mailto:dwagoner_at_arsenaldigital.com Web http://www.arsenaldigital.com/  

• NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you.

-----Original Message-----
Sent: Tuesday, December 11, 2001 12:05 PM To: Multiple recipients of list ORACLE-L

Hi,

I am trying to generate some generic CREATE DATABASE scripts from the Oracle Database Configuration assistant and I cannot see the "Generate Database Creation Scripts" option that is mentioned in the HELP. It is not listed on the screen with the "Create Database" and "Save as a Database Template" options.

Can someone let me know how it is done with the 9i configuration assistant or pass on some Oracle 9i CREATE DATABASE scripts.

Thanks,

Lindsay

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stoddard, Lindsay
  INET: lindsay.stoddard_at_osha.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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: David Wagoner
  INET: dwagoner_at_arsenaldigital.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).