ALL_EXTERNAL_TABLES describes the external tables accessible to the current user.
DBA_EXTERNAL_TABLES describes all external tables in the database.
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 | |
ACCESS_TYPE |
VARCHAR2(7) |
Type of access parameters for the external table:
|
|
ACCESS_PARAMETERS |
VARCHAR2(4000) |
Access parameters for the external table | |
PROPERTY |
VARCHAR2(10) |
Property of the external table:
|
See Also: