Urgent: 'ORA-01653: unable to extend table xyz.Products by 8192

[gtcol]

Hi all
I had run a bulk procedure with create and insert statements yesterday. But its throwing 'ORA-01653: unable to extend table xyz.Products by 8192 in tablespace xyz' now after running more than half of the procedure. Please advice how I can overcome this situation without having to restart the procedure as it takes lots of hours to complete and I am running out of dates.

Thanks,
gtcol

[paragp1981]

your tablespace doesnt have free space to accomodate inserts you are doing .
increase some space in that perticuler tablespace.
Your procedure must have come out with said error add space and re-run procedure..

[gtcol]

your tablespace doesnt have free space to accomodate inserts you are doing .
increase some space in that perticuler tablespace.
Your procedure must have come out with said error add space and re-run procedure..

I do understand its space issue. Any ideas I can add more datafiles and not have to rerun the procedure??

Thanks,
gtcol

[malay_biswal]

You have to rerun after adding datafile or modifying storage parameter of tablespace.

[gtcol]

Thanks Malay&Parag,
Did exactly the way you have advised. Couldn't find any other workaround.

Rgds,
gtcol