ALL_EXTERNAL_LOCATIONS
describes the locations (data sources) of the external tables accessible to the current user.
Related Views
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 of the external table location |
|
|
|
Name of the corresponding external table |
|
|
External table location clause |
|
|
|
Owner of the directory containing the external table location |
|
|
|
Name of the directory containing the external table location |
See Also: