I have two instances in a sun server. one is pro and the other is archive one. the archive is a clone of the prod. After database links are created for both, i tried to transfer some selected rows from a prod table to an archive table by using OO4O. I could not make it work. If you has any working sql scripts that can move selected data from one instance to another, please let me have it. I would appreciate it very much. Our oracle ver is 713 , UNIX env.

Thanks.

Jeanie :(