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