Re: Change DB_BLOCK size

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 26 Jan 2000 21:58:48 +0100
Message-ID: <948920446.13077.0.pluto.d4ee154e@news.demon.nl>

The DATABASE will need recreation, you can't change the blocksize without recreating it.
This implies export/import.

Hth,

--
Sybrand Bakker, Oracle DBA
Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net> wrote in message news:86ni6e$p48$1_at_bgtnsc03.worldnet.att.net...
> The minimum size for a table is 2 * DB_BLOCK_SIZE. We have a lot of
unused
> tables in our app that we have created at 8192 that will never contain
rows.
> If we increase our DB_BLOCK size from 4096, will these tables need manual
> re-creation, or will the export/import handle it?
>
>
Received on Wed Jan 26 2000 - 14:58:48 CST