Re: February DBA Tip of the Month

HONG CHEN (SCHEN1_at_prodigy.net) wrote:
: I would like to know the exact way to make use of the 4k db_block_size.
: Do we have to recreate the database in order to use it? How do we
: get the datafiles back from 2k db_block_size to the new databse created?
:

You need to rebuild the database. There is no way to change Oracle's block size for a database after the database is created.

-- 
-bn
random_at_interaccess.com	(PGP 2.6.2 public key available on request)
"There is no .signature -- only ZUUL!"