Loading Between Tables That Have the Same Schema

You can load data from one table to another with the same schema (for example, worldemp) with a simple INSERT statement.

INSERT INTO worldemp SELECT * FROM emp_ext;

If you used the database server to unload the data with a SELECT...INTO EXTERNAL statement and you have not yet dropped the external table, you do not have to create an external table.