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,
unable to extend index CUSTOMER_NN01 by 128 in tablespace
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
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.
You need to talk to your friendly and helpful DBA and have him/her allocate that required space.
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am