Hi
If the block size of the database has to change then recreate a new
database with the new block size. Export the entire database/tablespaces
from the old database to the new database.

Note: Database block size cannot be altered once it is defined. Hope this
will help you

Thanks & Regards
SudhaSrikanthan



-----Original Message-----
From: MOHAN KRISHNARAJ [mailto:mohan.[Email Address Removed] Monday, December 30, 2002 9:59 AM
To: LazyDBA.com Discussion
Subject: CHANGE OF BLOCK SIZE



Hi,

Currently i have the database with block size 2kb. Would like to change
to 8kb. Is there any possibility to do that..

TIA
Mohan Krishnaraj,
TATA INFOTECH LTD.,
BANGALORE, INDIA.
ph: 0091-80-5284681 xtn:251




--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page