| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
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 |
|
 Copyright © 2002, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
HTML