Warnings in job

rajeev_prabhuat · Post by **rajeev_prabhuat** » Thu Dec 02, 2004 3:17 am

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

l_homme_de_rio · Post by **l_homme_de_rio** » Thu Dec 02, 2004 4:21 am

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

rajeev_prabhuat · Post by **rajeev_prabhuat** » Thu Dec 02, 2004 4:48 am

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

chulett · Post by **chulett** » Thu Dec 02, 2004 6:59 am

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.