Re: Advice: Creating new Oracle DB

From: Mary Travis <Mary.B.Travis_at_bridge.bellsouth.com>
Date: 1997/05/23
Message-ID: <5m4ogq$hmn@atglab10.atglab.bls.com>#1/1

cdwaddell_at_aol.com (CDWaddell) wrote:

>Hi,

>I'm in the process of creating a new Oracle 7.3 database, my first one,
>and am wondering if there is anything I should know in advance abuot the
>DB creation process. Is there anything that may come back and haunt me if
>I'm to leave something out in the creation?
<snip>

Cary,
I've been bitten by not specifying MAXDATAFILES on the CREATE DATABASE statement. As it turned out, the default on my platform was a measly 20 datafiles that could be associated with the database instance. This is one parameter that it is certainly easier to pick a good number for in the beginning.
Mary
Mary Travis
BellSouth Telecommunications
email: Mary.B.Travis_at_bridge.bellsouth.com Received on Fri May 23 1997 - 00:00:00 CDT