Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Increasing DB_BLOCK_SIZE from 2k to 8k in Oracle 8i

Re: Increasing DB_BLOCK_SIZE from 2k to 8k in Oracle 8i

From: sybrandb <sybrandb_at_gmail.com>
Date: Mon, 18 Jun 2007 05:07:43 -0700
Message-ID: <1182168463.460989.74970@o61g2000hsh.googlegroups.com>


On Jun 18, 1:06 pm, pvr.murthy..._at_gmail.com wrote:
> Hi,
>
> We are running Oracle 8i on Windows 2003. While imporing / Exporting
> it is giving I/O errors. Now we would like to increase the default
> db_block_size from 2 k to 8k. Can anybody give a solution please.
>
> Is it possible to arrive this parameter during installation. If so
> either by choosing Typical / Custom / Hybrid installation options.
>
> P.V.RAMANA MURTHY
Your first sentence says it all, you never read the manual. We are running a desupported version of Oracle on a version of Windows, for which 8i was never certified. Increasing the blocksize (which can be set BTW during database *creation* only) won't resolve anything.

YOYO.

--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Jun 18 2007 - 07:07:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US