Message no. 401
Sent by Ii Harvey (idharvey) on Monday, April 9, 2007 9:49am
Subject: questions about project 9

Dear Dr. Liu:

When trying to create a DATA FILE with SIZE 100K, when setting the
initial storage at 100K, I got the error:

ORA-03214: File Size specified is smaller than minimum required.

So I did some research. 
Turns out that the minimum datafile size for locally managed tablespace
with uniform extent size is 1 extent + 2 blocks + 1 byte.
(http://rootshell.be/~yong321/oranotes/DatafileSizeHeaderOverhead.txt)

Also found that:
File size in table space = multiple of extents size
A segment is a container for objects (such as tables, indexes....).
An extent is a part of a segment. It consists of one or more contiguous
db blocks.
Space for data on a harddisk is allocated in extents. An extent belongs
to a tablespace. 
(http://www.adp-gmbh.ch/ora/concepts/extents.html)


Extents are allocated in multiple blocks. If extent size provided in the
storage clause 
is not multiple of block size, then it is rounded to the nearest block. 
(http://rbelbahri.wordpress.com/2007/01/28/setting-storage-for-star-schema-in-oracle/)


The default Block Size is 8192. Consequently, when the DEFAULT STORAGE
is set at 100K, the extent is rounded up to 104K. 

Adding 2 blocks plus 1 byte (16385 bytes) to 104K results in a minimum
file size of 122881 bytes. 

I found that this was indeed the minimum file size required to get the
script to run 
without error.


So, my question is, is this an acceptable solution to Project 9? 

Would this be part of what we are supposed to learn from this project? 

If the answer to the above questions is yes, is this information okay to
share in the problems and solutions discussion if this question comes up?

Thanks,

Danny