Unable to extend table **MASTER RECORD**
- 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.)
Additional Information
pc_server, log, Oracle, tablespace, T, TS, TS1, TS2, TS3, TS4
- Article last edited: 10/8/2013