Hi
Any change in the block size requires recreation of the database. You
should also ensure that the paramters related to block size in the init.ora
are sized appropriately

vittal
----- 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

DISCLAIMER
---------------------------------------------------------------------------
This email message and any attachments is confidential and intended only for
the use of an individual or entity named above and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law. If you are not the intended recipient, you are notified that any
dissemination, distribution or copying of this email is strictly prohibited.
If you have received this email in error, please notify us immediately by
return email or [Email Address Removed] and destroy the original message.
Opinions, conclusions, and other information in this message that do not
relate to the official business of SPAN, shall be understood to be neither
given nor endorsed by SPAN
________________________________________
Mails are Scanned and Filtered for Virus
[Email Address Removed]Oracle LazyDBA home page