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: Changing the block size

Re: Changing the block size

From: Your Name Here <yourname_at_monsanto.com>
Date: Fri, 8 Jan 1999 13:06:05 -0600
Message-ID: <775kv5$682@mhstl1.monsanto.com>


Since you have data in the database, the only way to fix the problem is to export the entire database to an export dump file, recreate the database with the correct block size in the init.ora, and import the export dump file.

Zachary Agatstein wrote in message
<76ticl$220s2_at_tmpsp002.tmpprv.allied.com>...
>I tried to increase the database block size from 2k to 4k, by changing a
>parameter in initxxxx.ora file, and rebooting the system. The database,
>however, has been populated. It gave me an error and prevented from
>mounting an instance. Is there a way to do it?
>
>Many thanks in advance.
>
>Zach A.
>
>
Received on Fri Jan 08 1999 - 13:06:05 CST

Original text of this message

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