Why not just create another tablespace with the new block size (32K) and
move the tables. Indexes can be rebuilt into the new tablespaces also.

--Dan



-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Tuesday, April 20, 2004 2:56 PM
To: LazyDBA.com Discussion
Subject: db_block_size increase?

Gurus,

I am running v9.2.0.1 on HP-UX on a (small=350GB) test datamart.

For testing purpose, I want to increase my db_block_size from 8K to 32K.

My plan is to generate an export (to DMP file) of my datamart schema,
change the value for db_block_size from 8K to 32K, rebuild my database
and
import the data for my datamart schema.

Does this sounds like a reasonable approach? Are there "gotchas" that I
should be aware of?

Thanks in advance for your input.

kl.

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page