Re: Change DB_BLOCK size

markp7832_at_my-deja.com escribió:
> =

> 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.

I think Burt was asking if the size will be maintained or not. I think yo= ur
tables will be resized to 16k because the export, unless you indicate not=  to do
it, will compress them in one extension. As, I suppose, your default init= ial
will be more than 16k (2*block_size) the your tables will be create with = an
initial (and unique) extension of 16k.

Regards.
-- =

Julio Negueruela

'Hay algunas cosas que son tan serias =

que solo puedes bromear con ellas.' (Bohr) Received on Thu Jan 27 2000 - 08:40:53 CST