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/password@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/tiger@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.
Parent topic: Using the Oracle Database Gateway for DRDA