3.8 Copying Data from Oracle Database to DRDA Server

This Oracle SQL INSERT command now works with the CALLBACK feature.

For example:

INSERT INTO DRDA_table SELECT * FROM local_table

Alternatively, you could use SQL*Plus COPY command. The COPY command enables you to copy data from Oracle database to a DRDA server. To copy data from your Oracle database to the DRDA server, you can also use:

COPY FROM username@connect_identifier - 
INSERT destination_table -  
USING query 

For example, to select all rows from the local Oracle EMP table, insert them into the EMP table on the DRDA server, and commit the transaction, use:

COPY FROM scott@ORACLE -
INSERT scott.EMP@DRDA -
USING SELECT * FROM EMP

The SQL*Plus COPY command supports APPEND, CREATE, INSERT, and REPLACE commands. However, INSERT is the only command supported when copying to the DRDA server. For more information about the COPY command, refer to SQL*Plus User's Guide and Reference.