Re: Advice: Creating new Oracle DB

The only thing which is not reversible after the database is created is the db_block_size or
the database block size.So find an optimal block size for your database. Also check that you have allocate sufficient space for system tablespace 200MB should be
fine so that you do not have to add datafiles to system tablespace.

All other parameters of the database can be changed after the database is created.

Sanjay Mathew
sanjay.mathew_at_burton.co.uk

CDWaddell <cdwaddell_at_aol.com> wrote in article <19970523161801.MAA01168_at_ladder01.news.aol.com>...
> 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? Are there any serious
> performance issues that I should be aware of durring the creation so I
 can
> include them now so they don't nip me in the butt later?
>
> We are converting things from a fairly large paradox database (aprox.
> 1.5gb) into Oracle 7.3 workgroup server. Should I be carefull about the
> tablespaces, rollback segments, extents and so on so that I will not run
> into trouble later.
>
> ANY HELP OR COMMENTS ARE APPRECIATED!
>
> Thanks in advance.
>
> Cary D. Waddell
> CDWaddell_at_AOL.COM
> MHS, Inc. Denver, CO
>
Received on Fri May 23 1997 - 00:00:00 CDT