Loading Between Tables That Have the Same Schema
You can easily move data from an external table to a database table if the tables have the same schema.
About this task
You can load data from one table to another table that
has the same schema (for example, worldemp) with a simple INSERT statement.
INSERT INTO worldemp SELECT * FROM emp_ext;