thanks for your replies folks,

I have to mapp hte columns at runtime for the datapump task, I cannot do mannuall mapping to all becoz i have 30 to 400 tables.

I...

Thanks for u r reply, greatly appreciate u r help.

I have a folder c:\servername\Project\dbo.orders.tab

all the tables scripts are stored here in the project folder which is a shared one.

Now I have to call this files and open them, so...

Thanks for u r reply, I will try this one today.......

Hi Adrian, thanks for u r response, but I do not have two or 3 tables, I have 400 to 500 tables whose modified scripts are stored in one shared...