transfer data

[jn1971]

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 :(

[marist89]

I don't get the connection with OO4O.

On the archive instance, you would have a database link named something like "prod":
insert into arch_table_a select * from table_a@prod

[jn1971]

thanks for your help.