Internally, creating an external table means creating metadata in the data dictionary. Unlike an ordinary table, an external table does not describe data stored in the database, nor does it describe how data is stored externally. Rather, external table metadata describes how the external table layer must present data to the database.
sap wm warehouse management training courses malaysia
A CREATE TABLE ... ORGANIZATION EXTERNAL statement has two parts. The external table definition describes the column types. This definition is like a view that enables SQL to query external data without loading it into the database. The second part of the statement maps the external data to the columns.
sap supply chain management scm training courses malaysia
External tables are read-only unless created with CREATE TABLE AS SELECT with the ORACLE_DATAPUMP access driver. Restrictions for external tables include no support for indexed columns and column objects.
sap s 4 hana training courses malaysia
See also
- Oracle Database Utilities to learn about external tables
- Oracle Database Administrator’s Guide to learn about managing external tables, external connections, and directory objects
- Oracle Database SQL Language Reference for information about creating and querying external tables
Leave a Reply