Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    p_manage_01: "unable to extend table %s.%s by %s in tablespace %s"

    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    In running p_manage_01, we have gotten the following in the p_manage_01_d1.log:

    ...
    Commit pointSQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.
    ...
    Commit point reached - logical record count 46536
    Commit point reached - logical record count 46636
    Commit point reached - logical record count 46736

    FAILURE Wed Jun 24 00:46:40 EDT 2009 ==================
    step 4
    Cycle: 84

    Oracle error: 01653, 00000, "unable to extend table %s.%s by %s in tablespace %s" // *Cause: Failed to allocate an extent of the required number of blocks for // a table segment in the tablespace indicated. // *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more // files to the tablespace indicated.\n

    Job Suspended !!!

    What table and tablespace is this?

    Resolution:
    Immediately preceding the start of the "Commit point reached - logical record count" lines, we see:

    1* begin l3_Z95 ('VAR'); end;
    ...
    table_type = VAR load_mode = DIRECT option = go
    mv /exlibris/aleph/u19_1/abc01/files/z95.seq /exlibris/aleph/u19_1/abcl01/files/z95.seq.variable

    So the table is the Z95.

    For the "Unable to extend table xxxx by nn%s in tablespace zzzz" message, you need to look in the $data_root/file_list to see what tablespace the table is connected to.

    Or you can use SQL like this:

    select tablespace_name from all_tables where owner = 'ABC01' and table_name = 'Z95';


    This shows:

    abc01@ALEPH0> select tablespace_name from all_tables where owner = 'ABC01' and table_name = 'Z95';
    **** Hit return to continue ****

    TABLESPACE_NAME
    ------------------------------
    TS3D

    So the tablespace is TS3D. Do util o/14/1 to confirm that this tablespace is out of space or low on space.

    See KB 3985 in regard to adding a datafile to a tablespace.


    • Article last edited: 10/8/2013
    • Was this article helpful?