ALL_EXTERNAL_TAB_CACHE_LOCATIONS
ALL_EXTERNAL_TAB_CACHE_LOCATIONS describes the files in cloud storage that are accessible to the current user and belong to cached external tables.
Related Views
-
DBA_EXTERNAL_TAB_CACHE_LOCATIONSdescribes all files in cloud storage that belong to cached external tables. -
USER_EXTERNAL_TAB_CACHE_LOCATIONSdescribes the files in cloud storage that are owned by the current user and belong to cached external tables. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the file |
CACHE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the external table cache to which the file belongs |
TABLE_NAME |
VARCHAR2(4000) |
Name of the external table on which the cache is based | |
PATH |
VARCHAR2(3000) |
NOT NULL |
Cloud storage path of the file |
FILE_NAME |
VARCHAR2(3000) |
NOT NULL |
Name of the file |
CACHED |
VARCHAR2(3) |
Indicates whether the file has been cached (YES) or not (NO) |
|
STALE |
VARCHAR2(3) |
Indicates whether the cached content is stale (YES) or not (NO) |
|
CACHE_SIZE |
NUMBER |
Amount of tablespace consumed by the file (in bytes) | |
FILE_SIZE |
NUMBER |
Size of the file (in bytes) | |
USAGE_COUNT |
NUMBER |
Number of times the file is used in queries | |
ETAG |
VARCHAR2(4000) |
ETAG of the file | |
FILE_LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
Time at which the file was last modified | |
LAST_REFRESHED |
TIMESTAMP(6) WITH TIME ZONE |
Last refresh time of the external table cache | |
LAST_ACCESSED |
TIMESTAMP(6) WITH TIME ZONE |
Last access time of the file or external table cache | |
FILE_KEYFoot 1 |
NUMBER |
NOT NULL |
Numerical ID of the file or external table cache |
Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.2.
Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.9.