SQL*Loader-2026: the load was aborted because SQL Loader can

om.ranjan · Post by **om.ranjan** » Thu Oct 01, 2009 10:56 am

Hi,

I have created a Job in DataStage to load data into a Target using ORACLE enterprise stage .( In source table has approx. 200 million of records)

The job is throwing below error message. .

ORA-01653: unable to extend table <schema_name.table_name>BK by 128 in tablespace D_UTMDM_1M_01

SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

0 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.

Date conversion cache disabled due to overflow (default size: 1000)

Could anyone please look into the issue? I'm not sure weather this issue related to ORACLE tablespace OR ????

Thanks,
Ranjan

chulett · Post by **chulett** » Thu Oct 01, 2009 11:08 am

Well... it says right in the error that it is a (lack of) tablespace issue.

Take the problem to your DBA.

nagarjuna · Post by **nagarjuna** » Thu Oct 01, 2009 11:58 am

Speak to DBA ....

om.ranjan · Post by **om.ranjan** » Thu Oct 01, 2009 12:04 pm

nagarjuna wrote:Speak to DBA ....

Tablespace has been extended, job are running fine now..

Thanks,

Ranjan :D