I forgot to write that we are on 8.0.5.

Mr.Hanky,

I have to run Insert statement from the D2K reports 2.5 in Before-Report trigger to insert the rows as per User inputs and then generate the report.

So, I am not sure whether I can use SQL* copy command.

I cannot use a query to an export file and using IMP/EXP, as I am not on 8i.

irehman,

The table in which I am inserting rows is a temp.table without any Indexes.

Thanks both,

Any more ideas?