You just don't. Different block size tablespaces are there for transportab= le tablespaces only. Absolutely zero benefit outside of that. One day soon I hope this message spreads a bit more broadly. Maybe we shou= ld put it in a FAQ somewhere. :( = Pete = "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook = "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] = On Behalf Of Harvinder Singh Sent: Monday, 21 June 2004 10:06 AM To: oracle-l@xxxxxxxxxxxxx Subject: db block size Hi, It will be great if u can point me to some white papers/articles =3D explaining how to choose the database block size for different kind of =3D tablespaces : index ,data ,temp, undo etc... Env: 10g on WIN2K Thanks --Harvinder =3D20 =3D20 =3D20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------