Hi Tang,

Many thanks for your help, this makes much more sense to me now.

I have tried many different way's of performing the import.

1. Full
2. Partial with indexes=n then running the createindex script to finish the job.
3. Partial with fromuser touser indexes=n then createindex.

All of these work but in total come back to roughly the same timings.

Can anyone suggest another option which may speed things up.

Cheers

Alison