Re: Change DB_BLOCK size

From: <markp7832_at_my-deja.com>
Date: Wed, 26 Jan 2000 21:48:49 GMT
Message-ID: <86nq3v$vt0$1@nnrp1.deja.com>

In article <86ni6e$p48$1_at_bgtnsc03.worldnet.att.net>, "Buck Turgidson" <jcmanNOSPAM_at_worldnet.att.net> wrote:
> 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?
>

The only way to change the Oracle Database Blocksize is to re-create the database. And if you do re-create the database then importing an export from your old 4096 database into the rebuilt 8192 database will work just fine.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 15:48:49 CST