• 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