RE: HOW TO CHANGE DB_BLOCK_SIZE after creating Database

RE: HOW TO CHANGE DB_BLOCK_SIZE after creating Database

 

  


Edmond,

Nick is right, there is no way to adjust after the build without a full
export import.

Regards,

Steve

-----Original Message-----
From: Dodd Nick
[mailto:oracledba-ezmlmshield-x8004714.[Email address protected]
Sent: 28 February 2006 09:47
To: LazyDBA Discussion
Subject: RE: HOW TO CHANGE DB_BLOCK_SIZE after creating Database

Edmond,

I beleive it is impossible to alter the DB_BLOCK_SIZE once a database is
created. You must decide the DB_BLOCK_SIZE when you first create the
Database. Best way to get it changed on your system would be create a
new database with the blocksize you require (alongside the existing DB),
full export from old db - import into new database. Once you are happy
all went well, drop/delete old database.

Nick

-----Original Message-----
From: Edmond - Information Technology
[mailto:oracledba-ezmlmshield-x35856651.[Email address protected]
Sent: 28 February 2006 09:35
To: LazyDBA Discussion
Subject: HOW TO CHANGE DB_BLOCK_SIZE after creating Database


Hello DBA Gurus,

I have installed Oracle V 9.2 and having default database in my server.
I would like to change Oracle DB_Block_Size from 8k to 16k and tried to
change in init.ora file.

When I create spfile from init.ora file(pfile) system is throwing some
error saying that spfile is already used by an instance.

When I try to start the DB through pfile then the DB is saying
'DB_Block_Size' mismatch between init file and control file.

Could anybody suggest how to change block size?

Thanks

Edmond.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page