4.9 Copying Data from the Non-Oracle Database System to the Oracle Database Server

The CREATE TABLE statement lets you copy data from a non-Oracle database to the Oracle database.

To create a table on the local database and insert rows from the non-Oracle table, use the following syntax:

CREATE TABLE table_name AS query;

The following example creates the table emp in the local Oracle database and inserts the rows from the EMP table of the non-Oracle database:

CREATE TABLE table1 AS SELECT * FROM "EMP"@remote_db;

Alternatively, you can use the SQL*Plus COPY command to copy data from the non-Oracle database to the Oracle database server.

See Also:

SQL*Plus User's Guide and Reference for more information about the COPY command