DSXchange

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

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

Take the problem to your DBA.

Speak to DBA ....

nagarjuna wrote:Speak to DBA ....

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

Thanks,

Ranjan :D