DSXchange

Hi,

I am having a job which loads data from oracle table using ORAOCI and loads the data into the staing table stg_accounts, and uses a tranformer to check for null values in columns and puts the data to table with another ORAOCI to write the data into the Oracle databse. But while running i am getting a warning as follows, i am not able to understand why this warning is comming: "LOAD_ACCOUNT..Transform_Account: ORA-01653: unable to extend table HUBDEV.STG_ACCOUNT by 16 in tablespace TOOLS".

Can anyone help me why this warning is firing.

Regards,
Rajeev Prabhu

it's an Oracle Pb, try to redesign your query by using explain plan or ask DBA assistance
(Try explain plan first)
All the best

Hi,

Thank you.

Regards,
Rajeev Prabhu

l_homme_de_rio wrote:it's an Oracle Pb, try to redesign your query by using explain plan or ask DBA assistance
(Try explain plan first)
All the best

I wouldn't bother with the explain plan if the table mentioned is the target of your job. If so, it simply needed to grow and ran out of space in the tablespace it lives in.

Tell your DBA. If you've got a good one, you shouldn't even have to tell them, they should know already.