Job is getting aborted Coz of lack of table space,
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
Job is getting aborted Coz of lack of table space,
Hi I am loading data into the Oracle table.But the data volume is relatively huge so the job is getting aborted....as per DBA we are running at the highest table space....is there any performance tuning that we can do to avoid this problem
Re: Job is getting aborted Coz of lack of table space,
What's the exact error mesage you are getting ?
Tejas
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Job is getting aborted Coz of lack of table space,
Yes. You have more data than the Oracle tablespace allows for. Therefore the tablespace size must be increased.sagar deshmukh wrote:Hi I am loading data into the Oracle table.But the data volume is relatively huge so the job is getting aborted....as per DBA we are running at the highest table space....is there any performance tuning that we can do to avoid this problem
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.