unable to extend index CUSTOMER_NN01 by 128 in tablespace

vinaymanchinila · Post by **vinaymanchinila** » Fri Sep 23, 2005 11:58 am

Hi

Trying to load 10 million rows, using a simple EE job which reads from production and writes to development table.
I am getting the following error and the job aborts, is there that I can do something, or do we have a parameter which alows us to drop the indexes and build them after the load!

sqlcode is: -1654 esql complaint: ORA-01654: unable to extend index CUSTOMER_NN01 by 128 in tablespace SALESIDX

Thanks,

ArndW · Post by **ArndW** » Fri Sep 23, 2005 12:12 pm

You can disable indices in a PX load job - but not for the reasons that there is not enough space left. Usually you disable constraints and indices during a bulk load to make it go quicker, then subsequently re-enable and re-build them. In your case that would abort as well.

You need to talk to your friendly and helpful DBA and have him/her allocate that required space.

vinaymanchinila · Post by **vinaymanchinila** » Fri Sep 23, 2005 12:15 pm

You bet !
Thanks Andrw

vinaymanchinila · Post by **vinaymanchinila** » Fri Sep 23, 2005 12:33 pm

Hey Andrw,
Just curious, how do we disable indexes and rebuild them in context with a EE job?
Is it described int he documentation any where?
Thanks,

ray.wurlod · Post by **ray.wurlod** » Fri Sep 23, 2005 4:57 pm

Sure is - it's in the Oracle DBA manuals, because it's something you do in Oracle.

To do it from DataStage you would need to be running with DBA privilege or something quite close. Since paranoia is a necessary prerequisite to being a good DBA you are unlikely to get that. But the DBA can supply you with a procedure or script that you can invoke.

vinaymanchinila · Post by **vinaymanchinila** » Mon Sep 26, 2005 6:58 am

Thanks Ray,
Got the above issue resolved after talking to our DBA who assigned more tablespace.