| Table Name | Description |
| ALL_EXTERNAL_LOCATIONS | Description of the external tables locations accessible to the user |
| Column ID | Column name | Data type | Length | Precision | NULL | Description |
| 1 | OWNER | VARCHAR2 | 30 | (null) | N | Owner of the external table location |
| 2 | TABLE_NAME | VARCHAR2 | 30 | (null) | N | Name of the corresponding external table |
| 3 | LOCATION | VARCHAR2 | 4000 | (null) | Y | External table location clause |
| 4 | DIRECTORY_OWNER | CHAR | 3 | (null) | Y | Owner of the directory containing the external table location |
| 5 | DIRECTORY_NAME | VARCHAR2 | 30 | (null) | Y | Name of the directory containing the location |