ALL_EXTERNAL_LOCATIONS describes the locations (data sources) of the external tables accessible to the current user.
DBA_EXTERNAL_LOCATIONS describes the locations (data sources) of all external tables in the database.
USER_EXTERNAL_LOCATIONS describes the locations (data sources) of 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 location |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the corresponding external table |
LOCATION |
VARCHAR2(4000) |
External table location clause | |
DIRECTORY_OWNER |
CHAR(3) |
Owner of the directory containing the external table location | |
DIRECTORY_NAME |
VARCHAR2(30) |
Name of the directory containing the external table location |