DBA_EXTERNAL_TABLES describes all external tables in the database. Its columns are the same as those in ALL_EXTERNAL_TABLES.
- ALL_EXTERNAL_TABLES describes the external tables accessible to the current user.
- USER_EXTERNAL_TABLES describes the external tables owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
| OWNER | VARCHAR2(30) | NOT NULL | Owner of the external table |
| TABLE_NAME | VARCHAR2(30) | NOT NULL | Name of the external table |
| TYPE_OWNER | CHAR(3) | | Owner of the implementation type for the external table access driver |
| TYPE_NAME | VARCHAR2(30) | NOT NULL | Name of the implementation type for the external table access driver |
| DEFAULT_DIRECTORY_OWNER | CHAR(3) | | Owner of the default directory for the external table |
| DEFAULT_DIRECTORY_NAME | VARCHAR2(30) | NOT NULL | Name of the default directory for the external table |
| REJECT_LIMIT | VARCHAR2(40) | | Reject limit for the external table, or UNLIMITED |
| ACCESS_TYPE | VARCHAR2(7) | | Type of access parameters for the external table:
|
| ACCESS_PARAMETERS | CLOB | | Access parameters for the external table |
| PROPERTY | VARCHAR2(10) | | Property of the external table:
|
Oracle data dictionary views
Oracle dynamic performance views
| Last updated: July 30, 2009 |
