Re: OMF or not OMF? DBCA or Manual scripts
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "don@xxxxxxxxx" <don@xxxxxxxxx>, "fuzzy.graybeard@xxxxxxxxx" <fuzzy.graybeard@xxxxxxxxx>
- Date: Mon, 24 Mar 2014 10:56:48 -0700 (PDT)
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@xxxxxxxxx> 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@xxxxxxxxx>
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
Other related posts:
