Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing the block size
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
![]() |
![]() |