Job is getting aborted Coz of lack of table space,

sagar deshmukh · Post by **sagar deshmukh** » Wed Mar 18, 2009 4:20 am

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

tehavele · Post by **tehavele** » Wed Mar 18, 2009 5:11 am

What's the exact error mesage you are getting ?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Mar 18, 2009 6:18 am

How important is / are the missing rows?

ETL is expected to finish its activity in full and successful.

What tablespace is it running out of? Data or undo or temp (or rollback) or any other?

ray.wurlod · Post by **ray.wurlod** » Wed Mar 18, 2009 3:08 pm

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

Yes. You have more data than the Oracle tablespace allows for. Therefore the tablespace size must be increased.

DSXchange

Job is getting aborted Coz of lack of table space,

Job is getting aborted Coz of lack of table space,

Re: Job is getting aborted Coz of lack of table space,

Re: Job is getting aborted Coz of lack of table space,