The methods for loading external data into the database are as follows:
Method | Description |
---|---|
CREATE TABLE AS...WITH DATA | Accesses table definitions and data from an existing foreign table and creates a new permanent table inside the database |
CREATE TABLE AS...FROM READ_NOS | Accesses data directly from the object store and creates a permanent table inside the database |
INSERT SELECT | Stores values from external data in a persistent database table using an INSERT SELECT statement |