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

    Unable to extend table **MASTER RECORD**

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

    We see these messages in a batch job log, a pc_server log, or the www_server log:

    Oracle error: io_znn_write
    ORA-01653: unable to extend table ABC50.Znn by 128 in tablespace TS3 .

    There are two odd things:
    1. The secondary allocation for the ABC50.Znn table is 1M, not "128".
    2. The tablespace is "TS3D", not "TS3 "

    Sometimes the allocation in the message is odd/incorrect and the tablespace name is truncated.

    You need to look at your file_list (in util a/17/10/2) to see what tablespace the ABC50.Znn table resides in.

    Or you can use SQL like this: select tablespace_name from all_tables where owner = 'ABC50' and table_name = 'Znn'; <the "Z" must be uppercase>

    If this tablespace is "autoextend", then Oracle should automatically create a datafile and the cause of the message may be something else ...

    If you have a "two-task" set-up, with a separate database server for Oracle, your database administrator needs to handle this.

    Otherwise, you can add a datafile to the tablespace, using util o/13/3. (See KB 5854.)

    Additional Information

    pc_server, log, Oracle, tablespace, T, TS, TS1, TS2, TS3, TS4

    • Article last edited: 10/8/2013