p_manage_01: ORA-1653: unable to extend table
- Article Type: General
- Product: Aleph
- Product Version: 14.2
Description:
The p_manage_01_e and e2 step failed. The errors are the following from the logs:
p_manage_01_e.log:Commit point reached - logical SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued..
p_manage_01_e2.log:Commit point reached - logical SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued..
I checked the alert log and found.
ORA-1653: unable to extend table CUN01.Z98 by 64000 in tablespace TS0_PROD_TAB.
ORA-1653: unable to extend table CUN01.Z98 by 64000 in tablespace TS0_PROD_TAB.
Looks like the ts0_prod_tab has to be extended. Unfortunately, I don't have OEM running at home, so I search around for the alter tablespace command. How do we restart? (hope not from the beginning).
Resolution:
In the case of the ORA-1653 error, the job doesn't cancel, it just halts. Once you add the file to the tablespace, the job will resume.
Note: This is v14. It may be that this is different in later versions of Oracle / Aleph.
- Article last edited: 10/8/2013