In that case, you can:

CREATE DATABASE LINK linkname CONNECT TO username IDENTIFIED BY password USING 'connect_string';

CREATE SYNONYM OTHERUSERNAME_TABLENAME for TABLENAME@Linkname;

Then you can select from that other user's table:

SELECT * FROM OTHERUSERNAME_TABLENAME;

Then you can use the syntax I already gave you. When you are done, you can:

DROP DATABASE LINK linkname;

>Hello Mark,
>
>Thanks for your help!.
>
>>Are you copying the rows to another table in the same Oracle instance? What I >mean is this in the same Oracle instance? If so, the TO user needs SELECT >privilege on the table of the FROM user. Then you can issue the following SQL:
>
>No, the database are in different instances.
>
>Thanks,
>Sergio