Oracle | DBMS_CACHE_EXT_TABLE

Oracle DBMS_EXT_TABLE_CACHE Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose External Table Cache Support utilities.

AUTHID CURRENT_USER

Dependencies

ALL_EXTERNAL_LOCATIONS	DBMS_EXT_TABLE_CACHE_INT
ALL_EXTERNAL_TABLES	DBMS_RANDOM
ALL_EXTERNAL_TAB_CACHES	DBMS_STANDARD
ALL_EXTERNAL_TAB_CACHE_LOCATIONS	DBMS_SYS_ERROR
ALL_POLICIES	DBMS_UTILITY
ALL_TABLES	JSON_ARRAY_T
ALL_TAB_COLUMNS	JSON_ELEMENT_T
ALL_TAB_PARTITIONS	JSON_OBJECT_T
DBMS_ASSERT	USER_SEGMENTS
DBMS_CACHE

Documented No

First Available 26ai

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(DEFAULT, NONE);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsexttc.sql

Subprograms

ADD_BY_LIKE (new 26ai)

Undocumented dbms_ext_table_cache.add_by_like( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2, /* external table name */ path_filters IN CLOB, esc_char IN VARCHAR2 DEFAULT NULL, force IN BOOLEAN DEFAULT FALSE);

TBD

ADD_FILE (new 26ai)

Undocumented dbms_ext_table_cache.add_file( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2, /* external table name */ file_url IN VARCHAR2, /* file to be added */ force IN BOOLEAN DEFAULT FALSE);

TBD

ADD_LATEST_FILES (new 26ai)

Undocumented dbms_ext_table_cache.add_latest_files( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2, /* external table name */ since IN DSINTERVAL_UNCONSTRAINED, max_files IN NUMBER := 0, force IN BOOLEAN DEFAULT FALSE);

TBD

ADD_TABLE (new 26ai)

Undocumented dbms_ext_table_cache.add_table( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2, /* external table name */ percent_files IN NUMBER DEFAULT NULL, force IN BOOLEAN DEFAULT FALSE);

TBD

CLEAR (new 26ai)

Undocumented dbms_ext_table_cache.clear( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2); /* external table name */

TBD

CREATE_CACHE (new 26ai)

Undocumented dbms_ext_table_cache.create_cache( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2, /* external table name */ partition_type IN VARCHAR2); /* partition on file */

TBD

DEBUG (new 26ai)

Undocumented dbms_ext_table_cache.debug( level IN BINARY_INTEGER, msg IN VARCHAR2);

TBD

DISABLE (new 26ai)

Undocumented dbms_ext_table_cache.disable( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2); /* external table name */

TBD

DROP_BY_LIKE (new 26ai)

Undocumented dbms_ext_table_cache.drop_by_like( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2, /* external table name */ path_filters IN CLOB, esc_char IN VARCHAR2 DEFAULT NULL);

TBD

DROP_CACHE (new 26ai)

Undocumented dbms_ext_table_cache.drop_cache( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2); /* external table name */

TBD

DROP_FILE (new 26ai)

Undocumented dbms_ext_table_cache.drop_file( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2, /* external table name */ file_url IN VARCHAR2); /* cached file to dropped */

TBD

DROP_ORPHANS (new 26ai)

Undocumented dbms_ext_table_cache.drop_orphans(owner IN VARCHAR2); /* owner of external tables */

TBD

ENABLE (new 26ai)

Undocumented dbms_ext_table_cache.enable( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2); /* external table name */

TBD

GET_TABLE_PROPERTY (new 26ai)

Undocumented dbms_ext_table_cache.get_table_property( owner IN VARCHAR2, table_name IN VARCHAR2, property_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_USER_PROPERTY (new 26ai)

Undocumented

Overload 1 dbms_ext_table_cache.get_user_property( property_name IN VARCHAR2, owner IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;

TBD

Undocumented

Overload 2 dbms_ext_table_cache.get_user_property( property_name IN VARCHAR2, property_value_str OUT VARCHAR2, is_set OUT BOOLEAN, owner IN VARCHAR2 DEFAULT NULL);

TBD

Undocumented

Overload 3 dbms_ext_table_cache.get_user_property( property_name IN VARCHAR2, property_value_num OUT NUMBER, is_set OUT BOOLEAN, owner IN VARCHAR2 DEFAULT NULL);

TBD

REFRESH_TABLE (new 26ai)

Undocumented dbms_ext_table_cache.refresh_table( owner IN VARCHAR2, /* owner of XT */ table_name IN VARCHAR2); /* XT name */

TBD

RETIRE_FILES (new 26ai)

Undocumented dbms_ext_table_cache.retire_files( owner IN VARCHAR2, /* owner of external table */ table_name IN VARCHAR2, /* external table name */ before IN DSINTERVAL_UNCONSTRAINED);

TBD

SET_TABLE_PROPERTY (new 26ai)

Undocumented dbms_ext_table_cache.set_table_property( owner IN VARCHAR2, table_name IN VARCHAR2, property_name IN VARCHAR2, property_value IN NUMBER);

TBD

SET_USER_PROPERTY (new 26ai)

Undocumented

Overload 1 dbms_ext_table_cache.set_user_property( property_name IN VARCHAR2, property_value IN NUMBER, owner IN VARCHAR2 DEFAULT NULL);

TBD

Undocumented

Overload 2 dbms_ext_table_cache.set_user_property( property_name IN VARCHAR2, property_value_str IN VARCHAR2, owner IN VARCHAR2 DEFAULT NULL);

TBD

VALIDATE (new 26ai)

Undocumented dbms_ext_table_cache.validate( owner IN VARCHAR2 DEFAULT NULL, table_name IN VARCHAR2 DEFAULT NULL, raise_errors IN BOOLEAN DEFAULT TRUE);

TBD