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

Description:
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 "

Resolution:
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.)