Moving Data between Tables

posted Sep 13, 2012, 10:34 AM by Sachchida Ojha
You can use CREATE TABLE AS or INSERT...SELECT to load external and web external table data into another (non-external) database table, and the data will be loaded in parallel according to the external or web external table definition.

If an external table file or web external table data source has an error, any operation that reads from that table fails. Similar to COPY, loading from external and web external tables is an all or nothing operation.