Re: Oracle 8.1.6 Server

Hello Johnai:

You can pre-create a new 8.1.6 database on your new server using whatever parameters you want - including a db_block_size of 16K. You can also pre-create the tablespaces and decide where you want the datafiles located. Then do either a full export from the 8.0.5 machine and a full import to the 8.1.6 machine or a schema-by-schema export/import. If you use the 8.1.6 database creation assistant note that no matter what size you make the rollback tablespace, it will come out of the creation assistant set to 12M. You'll have to adjust it afterwards..

Van

Johnai <syner_at_pd.jaring.my> wrote in message news:8h0hdv$7ne$1_at_news4.jaring.my...
> Hello,
>
> I am going to install Oracle 8.1.6 to my newserver HP server on windows
 NT.
> Please give me peace of advise. The Server specification : Pentium III
> 550Mhz with 1GB RAM, 9GB Harddisk. This server will replace my exisitng
> server (Pentium III 400, 500MB RAM) with Oracle 8.0.5. Where the data will
> migrat to this new server then.
>
> My question it is the best to recreate the Tablespace, Rollback segment in
> this new server? If I would like to create the db_block size at 16K, what
 is
> procedure for me to do that?
>
>
>
>
>
Received on Tue May 30 2000 - 00:00:00 CEST