Home » Other » Training & Certification » Resetting default db_block_size (Oracle 9i/10g)
Resetting default db_block_size [message #349224] Fri, 19 September 2008 06:39 Go to next message
bnprao
Messages: 2
Registered: September 2008
Location: India
Junior Member


Hi All,

Is there any method of startingup the database after changing the default block size ?

I am aware that the default db_block_size should never be changed unless/until you recreate the database again.
But my question is does the database startup after I have changed the db_block_size from 4096 to 8192?
Re: Resetting default db_block_size [message #349237 is a reply to message #349224] Fri, 19 September 2008 07:35 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any method of startingup the database after changing the default block size ?

You can't change the default block size.

Quote:
But my question is does the database startup after I have changed the db_block_size from 4096 to 8192?

No, just try it.

Regards
Michel
Previous Topic: 1Z0-147
Next Topic: Need help in Oracle application Framework
Goto Forum:
  


Current Time: Sun Apr 20 11:43:11 CDT 2014

Total time taken to generate the page: 0.05013 seconds