AFAIK, dbca will not generate tablespace create scripts with LMTs.
so edit the storage clause of each tablespace before running the script set.

Paul

-----Original Message-----
Sent: Monday, June 18, 2001 2:55 PM
To: Multiple recipients of list ORACLE-L


Joe's got the right idea.  I do this regularly.  By letting dbassist 
write the base scripts I don't have to worry about my fat fingers typing 
the wrong stuff for the auto-generated parts.   Then customize as 
necessary for your needs.  Works great.
Rodd

Original Message dated 6/18/01, 1:26:09 PM
Author: JOE TESTA <[EMAIL PROTECTED]>
Re: Re: Oracle Database setup document:


assuming one of the newer versions, you can always use dbassist, at the 
end have it save the scripts instead of creating database., tweak to your 
heart's contents and run them.
 
joe


>>> [EMAIL PROTECTED] 06/18/01 01:16PM >>>
Dear All,

I will be shortly setting up 2 new Oracle Databases for my company, for 
the 
development system, before we hopefully go into production in 3 months 
time.

What I would like to do is document the proposed setup off these 
databases 
before I start doing the actual work.

Therefore, is there anywhere where a standard Oracle Database setup 
document 
exists, with all off the relevant parameters and set-up considerations 
documented as part of this document, that I can use as a basis for my 
document?

Or do you guys, just go and set-up your databases, by modifying your last 
create database scripts?

If anyone can help me, it would be most appreciated.

Cheers,
Justin


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Justin Coleman
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Rodd Holman
  INET: [EMAIL PROTECTED]

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: [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.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

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: [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).

Reply via email to