Copy Table One Database To Another Datbase

Syntax:

COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)]
USING query


Using Dblink:

create table target_table_name as select * from source_table_name@dblink 


Using Copy:

copy from hr/hr@ala to gbdml/gbdml@gbdml create employees_copy using select * from employees ;

Be carefull- SQLPlus COPY supports only the following datatypes:

    CHAR
    DATE
    LONG
    NUMBER
    VARCHAR2