Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Change DB_BLOCK size
markp7832_at_my-deja.com wrote in <86nq3v$vt0$1_at_nnrp1.deja.com>:
>In article <86ni6e$p48$1_at_bgtnsc03.worldnet.att.net>,
>>
>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.
there is no requirement that a table have at least 2*dbbs bytes. in fact,
a minimal table will always have more than anyway.
--
dave mausner
Received on Wed Jan 26 2000 - 20:36:23 CST