initial storage value
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: initial storage value

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi friends.
    Can we set initial storage parameter value for a table greater than 2gb.

    regards
    anandkl
    anandkl

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Why do you think you can't ? You can
    Reddy,Sam

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    I tried this command and it dint work

    create table mybat(name varchar2(30))
    2 storage (initial 3000M NEXT 3000M minextents 1);
    storage (initial 3000M NEXT 3000M minextents 1)
    *
    ERROR at line 2:
    ORA-02218: invalid INITIAL storage option value
    anandkl

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I thought differently. Like initial storage clause for a table of 2+ GB in Size.

    Oracle says as follows:

    INITIAL
    Specify in bytes the size of the object's first extent. Oracle allocates space for this extent when you create the schema object. Use K or M to specify this size in kilobytes or megabytes.

    The default value is the size of 5 data blocks. The minimum value is the size of 2 data blocks for nonbitmapped segments or 3 data blocks for bitmapped segments, plus one data block for each free list group you specify. The maximum value depends on your operating system. Oracle rounds values up to the next multiple of the data block size for values less than 5 data blocks, and rounds up to the next multiple of 5 data blocks for values greater than 5 data blocks.
    Reddy,Sam

  5. #5
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Sreddy,
    It may be a wrong qtn???.
    please update me on this.....
    IF we have 2 datafiles of 1500m each...having initial 2gb next 100m....
    1.oracle start writing from/after 5blocksize
    2.each file size is less than 2gb so will it continue in 2nd file..?????.
    3.If Single extent cannot be shared among the files...it will fail and give error 1653 right?.
    Thanks.
    Thanigaivasan.

  6. #6
    Join Date
    May 2002
    Posts
    37
    What is the size of your tablespace?
    Actually, what is the size of the datafiles in that tablespace?

    If your datafiles' size is less then intitial extent you are
    specifing, you won't be able to create that tabel.

    Regards.

  7. #7
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Originally posted by thanigai
    Sreddy,
    It may be a wrong qtn???.
    please update me on this.....
    IF we have 2 datafiles of 1500m each...having initial 2gb next 100m....
    1.oracle start writing from/after 5blocksize
    2.each file size is less than 2gb so will it continue in 2nd file..?????.
    3.If Single extent cannot be shared among the files...it will fail and give error 1653 right?.
    Thanks.
    Thanigaivasan.
    As dave said, I think you cannot specify an extent bigger than the size of datafile. Thats what Oracle meant by saying it depends upon the OS. If OS supports datafile greater than 2GB which inturn allow you to specify bigger extent size.
    Reddy,Sam

  8. #8
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Thank you.
    That solves my problem. extent size must be less than the file size irrespective of tablespace size(total file sizes).
    Thanks.
    Thanigaivasan.

  9. #9
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I did test creating a table extent bigger than datafile size of 2GB, its failed and when I modfied extent size from 2100 to 2000 Mb it accepted.

    That clarifies always the a table can't extend its single extent beyond the file size limit.
    Reddy,Sam

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    http://otn.oracle.com/docs/products/...block.htm#2528

    When you specify an INITIAL value, oracle allocates the extent from contiguous blocks. Since there are a finite number of blocks in a data file, you can't allocate more than that finite number.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width