Take the full export of the databaseand recreate the database with new data
block size then import all objects to newly created database.

Regards,
Rajendra Prakash
----- Original Message -----
From: MOHAN KRISHNARAJ <mohan.[Email Address Removed] LazyDBA.com Discussion <[Email Address Removed] Monday, December 30, 2002 9:58 AM
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] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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