| Minimum datafile size [message #239006] |
Mon, 21 May 2007 03:55  |
sirisha.2712
Messages: 5
Registered: May 2007
Location: Mumbai
|
Junior Member |
|
|
Hello
what is the Minimum datafile size required for creating a non-system tablespace?
I am trying to create a tablespace by giving the syntax like,
SQL> create tablespace t1
2 datafile '/home/data/t1.dbf' size 72k;
create tablespace t1
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace t1
2 datafile '/home/data/t1.dbf' size 73k;
Tablespace created.
The blocksize for my database is 4096, as i have heard that the minimum size of the datafile is decided by blocksize, but i want to know that how it is calculated as by giving the above syntax the other values will be default. I am trying the syntax in oracle 9.2.0.1.0 version.
|
|
|
|
|
|
| Re: Minimum datafile size [message #239016 is a reply to message #239012] |
Mon, 21 May 2007 04:56  |
sirisha.2712
Messages: 5
Registered: May 2007
Location: Mumbai
|
Junior Member |
|
|
Thanks Michel
But I am still confused that why did oracle didn't round up 72k size why only 73k size and also if the database blocksize is different then also the minimum datafile size is different for different blocksize, is there any calculation for calculating the datafile size.
|
|
|
|
|
|
| Re: Minimum datafile size [message #239072 is a reply to message #239038] |
Mon, 21 May 2007 07:29 |
sirisha.2712
Messages: 5
Registered: May 2007
Location: Mumbai
|
Junior Member |
|
|
Thanks Michel
I just want to confirm something,
As you explained,
File header: min 4k
Bitmap: min 64k
Segment header: min 4k
Segment data block: min 1 block: 4k
Total: 76k this is for 4k blocksize
and for 2k blocksize it will be in the same way right which will be total of 70k so we can create the file with 69k that means,
File header : min is 1 blocksize
Bitmap: min 64k
Segment header : min is 1 blocksize
segment data block : min is 1 block
is this the only format how the datafile size is calculated in locally managed tablespace.
But in dictionary managed, 2 blocksize is the minimum datafile size.
So how much data can be stored in both LMT & DMT minimum sized datafile?
|
|
|
|
|
|
| Re: Minimum datafile size [message #239283 is a reply to message #239085] |
Mon, 21 May 2007 22:33 |
sirisha.2712
Messages: 5
Registered: May 2007
Location: Mumbai
|
Junior Member |
|
|
Sorry
if i am disturbing you but it's just the curiosity that i wanted to know the minimum size and how much data can be stored if we create i know its of no use if we create that size datafile.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Minimum datafile size [message #510644 is a reply to message #510603] |
Tue, 07 June 2011 00:54 |
 |
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
markevaughan wrote on Mon, 06 June 2011 23:18In my DB, I've got datafiles on multiple disks. The db_block_size parameter is 8192. Some datafiles require a minimum size of 5MB, where others have a minimum of 129MB. What makes the difference? It seems that, based upon what was previously written, all of the datafiles should have the same minimum size. I'm a newbie so sorry if this is way too basic.
Answer depends on:
- Oracle version
- Tablespace setting
- DDL on objects of this tablespace
- DML on objects of this tablespace that led to object extensions
In addition, it is not wise to think an answer that is 4 years old is still up to date now.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
