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
______________________________________________________________________
Oracle LazyDBA home page