Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Change DB_BLOCK size

Re: Change DB_BLOCK size

From: dave mausner <dmausner_at_ameritech.x.net>
Date: Thu, 27 Jan 2000 02:36:23 GMT
Message-ID: <8EC7D0AB6dlm@206.141.192.241>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US