• 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