I think you may find that even MINIMUM EXTENT
you choose is rounded up, so that the value stored as
the tablespace default is a multiple of 5 blocks.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Howard J. Rogers wrote in message
<3be055b5$0$15807$afc38c87_at_news.optusnet.com.au>...
>I think I remember that article. And I think it says that 8i (and all
>Oracle versions) will still perform the "round up to 5 blocks" trick
>*unless* you specify MINIMUM EXTENT (for Oracle 8) or use locally managed
>tablespaces (for 8i).
>
Received on Wed Oct 31 2001 - 14:25:06 CST
