also copy but look what the doc says (7.3.4)
Code:Copying Data from One Database to Another Use the SQL*Plus COPY command to copy data between databases and between tables on the same database. With the COPY command, you can copy data between databases in the following ways: copy data from a remote database to your local database copy data from your local (default) database to a remote database (on most systems) copy data from one remote database to another remote database (on most systems) Note: In general, the COPY command was designed to be used for copying data between Oracle and non-Oracle databases. You should use SQL commands (CREATE TABLE AS and INSERT) to copy data between Oracle databases




Reply With Quote