Hi Jurij,

Thanks a lot. It worked.
But since I have a lots and lots of region the sql loader control file has become too large.

Can I do this in shell script or perl program. If yes can somebody please post a sample program which i can change to use it for loading.

I will post the same question in a seperate thread also.

Please Help.

Thanks
Anurag