Re: OMF or not OMF? DBCA or Manual scripts
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Mon, 24 Mar 2014 11:32:11 -0600
Message-ID: <53306C1B.1040808_at_gmail.com>
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.
Date: Mon, 24 Mar 2014 11:32:11 -0600
Message-ID: <53306C1B.1040808_at_gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 24 2014 - 18:32:11 CET