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