ORA-1631. - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: ORA-1631.

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    that's not true in 8 and 8i, it is true in 7

    one of my temp table for datawarehouse loading (oracle 8.1.7) has 5612 extents with db_block_size of 8k

  2. #12
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Shestakov
    LINK:
    http://otn.oracle.com/docs/products/...20_io.htm#3480

    Table of # extents (depend from DB_BLOCK_SIZE)

    Block Size (KB) Maximum Number of Extents
    2 -- 121
    4 -- 255
    8 -- 504
    16 -- 1032
    32 -- 2070
    I think you need to go back and re-read your link.
    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."

  3. #13
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Pando is right.

    In oracle 7 each table (index, cluster) can has
    only 1 header block. in this case 121 extent was limit of number of extents for 2kb db_block_size.
    When oracle changed rowid structure, it change also structure of header blocks.
    In 8i and 9i (i don't sure about oracle 8) each object can has linked list of header blocks and number of extents still not depend from db_block_size.
    --------------------------------------------
    Question to dba_dada. What version of Oracle db u are using?

    [Edited by Shestakov on 03-25-2002 at 03:33 PM]

  4. #14
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    For the accurate picture about this unlimited/depending-on-the-blocksize max number of extents:

    Those limits (121 for 2K etc...) were lifted in Oracle 7.3, which introduced the ability for "unlimited" number of extents, regardles of DB_BLOCK_SIZE. It has nothing to do wth change of the ROWID format (which happend in 8.0), in 7.3 they simply introduced the ability for a segment to have more than one header block (linked list of header blocks), which allowed unlimited number of extents to be written in the extent map of the header block(s).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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