Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Next extent size; ORA-1653 error message

    Next extent size; ORA-1653 error message

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    What units is Oracle using to report its extent sizes [in the UTIL-O-14-1 and especially in the ORA-1653 error message]?

    Resolution:
    ** UTIL-O-14-1 is in Megabytes. **
    Supposedly the ORA-1653 depends on how the table is defined. If it's defined in Meg, it will supposedly be meg.; if it's K, it will supposedly be Kilobytes. But my experience, like yours, has been that the value we see here often doesn't make sense. If you have Locally-managed tablespace, then the value you see will depend completely on that and whatever is in the file_list is irrelevant. This SQL will tell you what the secondary allocation is (in bytes) for each table in a particular library:
    SQL> select table_name, next_extent from all_tables where owner like 'USM01%';
    (If the NEXT_EXTENT column is blank, that indicates Locally-managed tablespace.) So I suggest this rule: If the NEXT_EXTENT is blank (indicating Locally-managed), consult your Oracle person. If there's a value, then presume -- regardless of the ORA-1653 message -- that the extent it's trying to get is the NEXT_EXTENT shown. In this specific case we see that the largest free extent in tablespace ts0 is 1340 M. And the largest extent size in mit01 is 250 M (262,144,000 bytes). Thus, you currently have room for 5 such extents.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • New/updated authority record doesn't generate bib links **MASTER RECORD**
      • Nightly reports not generated following backup error
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved