3.9 Copying Data from DRDA Server to Oracle Database
The CREATE TABLE
command enables you to copy data from a DRDA server to Oracle database.
To create a table on your Oracle database and to insert rows from a DRDA server table, use:
CREATE TABLE table_name AS query
A SQL INSERT
into an Oracle table can be done selecting data from the gateway as follows:
INSERT INTO local_table SELECT * FROM drda_table
The following example creates the table EMP
in your local Oracle database and inserts the rows from the EMP
table on the DRDA server:
CREATE TABLE EMP AS SELECT * FROM scott.EMP@DRDA
Alternatively, you can use the SQL*Plus COPY
command to copy data from a DRDA server to Oracle database. 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