COPY may also work between machines running different versions of the operating system. If COPY fails, test the connection using rcp or ftp. Restrictions in vendor-supplied networking software may also prevent rcp or ftp from functioning properly between systems. The same restrictions may cause COPY to fail.
Note: The rlogin command does not send and receive large packets of data and is not an adequate test for connections.
If COPY does not function between systems, create a database link to the system and user ID indicating the table you want to copy. To do this, enter:
SQL> create table newtable as \
(SELECT * FROM table@database_link_name)
This selects the rows and columns from the original table on the remote system and enters them in the new table.