Re: OMF or not OMF? DBCA or Manual scripts
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Mon, 24 Mar 2014 10:56:48 -0700 (PDT)
Message-ID: <1395683808.82163.YahooMailNeo_at_web124706.mail.ne1.yahoo.com>
We use dbca to create the database but also have it generate the scripts so that if something happens that requires the database to be rebuilt we can go back to the generated scripts and not miss anything. David Fitzjarrell Primary author, "Oracle Exadata Survival Guide" On Monday, March 24, 2014 11:54 AM, Don Seiler <don_at_seiler.us> wrote: Personally I like dbca -silent with a response file template, similar to Frits. On Mon, Mar 24, 2014 at 12:32 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com> wrote: On 24/03/2014 10:56 AM, Mark Bobak wrote: > >My personal opinion, use DBCA. With a new database version, I might use DBCA to generate the script, then read the script, just to see what’s in there, and then run the script. >> >> >>Back in the 7.0, maybe 8.0 days, it wasn’t a big deal to create a database manually. Today, w/ 11gR2, 12cR1, there’s just a lot of options to consider, too many really, to remember from memory. And really, how much value is there in learning and memorizing all that syntax? >> >> >>Just my opinion, >> >> >>-Mark I totally concur. Reading the DBCA generated script is often an eye-opener. > >But the possibility of either forgetting something and the opportunity to debug a hand-coded script does not hold any major appeal any more. > >/Hans > -- Don Seiler http://www.seiler.us
Date: Mon, 24 Mar 2014 10:56:48 -0700 (PDT)
Message-ID: <1395683808.82163.YahooMailNeo_at_web124706.mail.ne1.yahoo.com>
We use dbca to create the database but also have it generate the scripts so that if something happens that requires the database to be rebuilt we can go back to the generated scripts and not miss anything. David Fitzjarrell Primary author, "Oracle Exadata Survival Guide" On Monday, March 24, 2014 11:54 AM, Don Seiler <don_at_seiler.us> wrote: Personally I like dbca -silent with a response file template, similar to Frits. On Mon, Mar 24, 2014 at 12:32 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com> wrote: On 24/03/2014 10:56 AM, Mark Bobak wrote: > >My personal opinion, use DBCA. With a new database version, I might use DBCA to generate the script, then read the script, just to see what’s in there, and then run the script. >> >> >>Back in the 7.0, maybe 8.0 days, it wasn’t a big deal to create a database manually. Today, w/ 11gR2, 12cR1, there’s just a lot of options to consider, too many really, to remember from memory. And really, how much value is there in learning and memorizing all that syntax? >> >> >>Just my opinion, >> >> >>-Mark I totally concur. Reading the DBCA generated script is often an eye-opener. > >But the possibility of either forgetting something and the opportunity to debug a hand-coded script does not hold any major appeal any more. > >/Hans > -- Don Seiler http://www.seiler.us
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 24 2014 - 18:56:48 CET