Hi,
You have to define it at the time of creating the database.Only way I can
think of is taking a full export / cold backup of your database ,create a
new database with desired block size and import the objects.
Basu
----- 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