Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: About recreation of BD Oracle
On Thu, 24 Jun 1999 09:36:35 GMT, ehdeza_at_my-deja.com wrote:
>My Name is Ernesto.
>
>I need know, how can i change the DB_BLOCK_SIZE parameters in mi file
>initbs3.ora the 2K a 8K. Ah, very important, in the moment at the
>creation of the database the DB_BLOCK_SIZE used is 2K.
>
>Thanks for all
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
The block size is the amount of os blocks in an oracle block. This is
something physical. You can't change it with oracle. The only way is
make a new db.
Create the exact tablespaces. Run a full export with data.
Import it.
Received on Thu Jul 15 1999 - 14:30:30 CDT