Oracle | DBMS_CACHE_EXT_TABLE_CACHE

Oracle DBMS_EXT_TABLE_CACHE_INT 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 Automatic Table Cache internal utilities.

AUTHID DEFINER

Dependencies

DBA_ROLE_PRIVS	DBMS_STANDARD
DBA_ESGMENTS	EXTERNAL_TAB_CACHE$
DBA_TABLES	EXTERNAL_TAB_CACHE_LOCATION$
DBA_TAB_PARTITIONS	EXTERNAL_TAB_CACHE_PROP$
DBA_TS_QUTAS	EXTERNAL_TAB_CACHE_USAGE$
DBA_USERS	EXTERNAL_TAB_CACHE_USER_PROP$
DBKVP_LIB	JSON_ARRAY_T
DBMS_ASSERT	JSON_ELEMENT_T
DBMS_EXT_TABLE_CACHE	JSON_OBJECT_T
DBMS_EXT_TABLE_CACHE_LIB	OBJ$
DBMS_OUTPUT	USER$

Documented No

First Available 26ai

Security Model Owned by SYS with no privileges granted and further protected with an ACCESSIBLE BY clause.

Source None found

Subprograms

ADD_FILE_INT	DROP_INT	KKEXTTCPCLEARINPROGRESS
ADD_ONE_PATH_INT	DROP_PARTITION_BY_KEY_INT	KKEXTTCPSETINPROGRESS
ADD_TABLE_INT	ENSURE_DBA	REMOVE_PARTIAL_PART_INT
CACHE_SUMMARY_UPDATE	GET_AVAILABLE_QUOTA	SET_TABLE_PROPERTY
CLEAR_INT	GET_OBJECTID	SET_USER_PROPERTY
CLEAR_ORPHAN	GET_TABLE_PROPERTY	SET_USER_PROPERTY_NUM
CREATE_INT	GET_TABSIZE	SET_USER_PROPERTY_STR
DEBUG	GET_USER_PROPERTY	TOGGLE_DISABLE_INT
DETECT_ORPHANS	GET_USER_PROPERTY_NUM	VALIDATE
DROP_FILE_INT	GET_USER_PROPERTY_STR

ADD_FILE_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.add_file_int( owner_nq IN VARCHAR2, table_nq IN VARCHAR2, path_name IN VARCHAR2, file_name IN VARCHAR2, cache_name_nq IN VARCHAR2, inc_size IN OUT NUMBER, add_rows IN NUMBER, filetag IN VARCHAR2, file_size IN NUMBER, lastmod IN TIMESTAMP WITH TIME ZONE);

TBD

ADD_ONE_PATH_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.add_one_path_int( owner_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2, fileclob IN CLOB);

TBD

ADD_TABLE_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.add_table_int( owner_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2, table_nq IN VARCHAR2);

TBD

CACHE_SUMMARY_UPDATE (new 26ai)

Undocumented dbms_ext_table_cache_int.cache_summary_update( owner_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2, table_nq IN VARCHAR2;

TBD

CLEAR_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.clear_int( owner_nq IN VARCHAR2, table_name_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2);

TBD

CLEAR_ORPHAN (new 26ai)

Undocumented dbms_ext_table_cache_int.clear_orphan( owner_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2);

TBD

CREATE_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.create_int( owner_nq IN VARCHAR2, table_nq IN VARCHAR2, file_list IN CLOB, col_list IN CLOB, filepart IN BOOLEAN, cache_name_nq IN VARCHAR2);

TBD

DEBUG (new 26ai)

Undocumented dbms_ext_table_cache_int.debug( lvl IN BINARY_INTEGER, msg IN VARCHAR2);

TBD

DETECT_ORPHANS (new 26ai)

Undocumented dbms_ext_table_cache_int.detect_orphans(owner_nq IN VARCHAR2) RETURN CLOB;

SELECT dbms_ext_table_cache_int.detect_orphans(USER);

      

      ORA-06553: PLS-904: insufficient privileges to access object DBMS_EXT_TABLE_CACHE_INT

DROP_FILE_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.drop_file_int( owner_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2 path_name IN VARCHAR2 file_name IN VARCHAR2);

TBD

DROP_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.drop_int( owner_nq IN VARCHAR2, table_nq IN VARCHAR2);

TBD

DROP_PARTITION_BY_KEY_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.drop_partition_by_key_int( owner_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2, path_name IN VARCHAR2, file_name IN VARCHAR2, is_path IN BOOLEAN) RETURN VARCHAR2;

TBD

ENSURE_DBA (new 26ai)

Undocumented dbms_ext_table_cache_int.ensure_dba RETURN BOOLEAN;

BEGIN

        IF dbms_ext_table_cache_int.ensure_dba THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      

      PLS-00904 insufficient privileges to access object DBMS_EXT_TABLE_CACHE_INT

GET_AVAILABLE_QUOTA (new 26ai)

Undocumented dbms_ext_table_cache_int.get_available_quota( owner_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2) RETURN NUMBER;

TBD

GET_OBJECTID (new 26ai)

Undocumented dbms_ext_table_cache_int.get_objectid( owner_nq IN VARCHAR2, objname_nq IN VARCHAR2) RETURN NUMBER;

TBD

GET_TABLE_PROPERTY (new 26ai)

Undocumented dbms_ext_table_cache_int.get_table_property( schema IN VARCHAR2, table_name IN VARCHAR2, property_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_TABSIZE (new 26ai)

Undocumented dbms_ext_table_cache_int.get_tabsize( owner_nq IN VARCHAR2, table_nq IN VARCHAR2) RETURN NUMBER;

TBD

GET_USER_PROPERTY (new 26ai)

Undocumented dbms_ext_table_cache_int.get_user_property( user_name IN VARCHAR2, property_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_USER_PROPERTY_NUM (new 26ai)

Undocumented dbms_ext_table_cache_int.get_user_property_num( user_name IN VARCHAR2, property_name IN VARCHAR2, is_set OUT BOOLEAN) RETURN NUMBER;

TBD

GET_USER_PROPERTY_STR (new 26ai)

Undocumented dbms_ext_table_cache_int.get_user_property_str( user_name IN VARCHAR2, property_name IN VARCHAR2, is_set OUT BOOLEAN) RETURN VARCHAR2;

TBD

KKEXTTCPCLEARINPROGRESS (new 26ai)

Undocumented dbms_ext_table_cache_int.kkexttcpclearinprogress;

exec dbms_ext_table_cache_int.kkexttcpclearinprogress;

      

      PLS-00904: insufficient privileges to access object DBMS_EXT_TABLE_CACHE_INT

KKEXTTCPSETINPROGRESS (new 26ai)

Undocumented dbms_ext_table_cache_int.kkexttcpsetinprogress;

exec dbms_ext_table_cache_int.kkexttcpsetinprogress;

      

      PLS-00904: insufficient privileges to access object DBMS_EXT_TABLE_CACHE_INT

REMOVE_PARTIAL_PART_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.remove_partial_part_int( owner_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2, path_name IN VARCHAR2, keep_list IN CLOB);

TBD

SET_TABLE_PROPERTY (new 26ai)

Undocumented dbms_ext_table_cache_int.set_table_property( schema IN VARCHAR2, table_name IN VARCHAR2, property_name IN VARCHAR2, property_value IN NUMBER);

TBD

SET_USER_PROPERTY (new 26ai)

Undocumented dbms_ext_table_cache_int.set_user_property( user_name IN VARCHAR2, property_name IN VARCHAR2, property_value IN NUMBER);

TBD

SET_USER_PROPERTY_NUM (new 26ai)

Undocumented dbms_ext_table_cache_int.set_user_property_num( user_name IN VARCHAR2, property_name IN VARCHAR2, property_value IN NUMBER);

TBD

SET_USER_PROPERTY_STR (new 26ai)

Undocumented dbms_ext_table_cache_int.set_user_property_str( user_name IN VARCHAR2, property_name IN VARCHAR2, property_value IN VARCHAR2);

TBD

TOGGLE_DISABLE_INT (new 26ai)

Undocumented dbms_ext_table_cache_int.toggle_disable_int( owner_nq IN VARCHAR2, table_name_nq IN VARCHAR2, cache_tab_nq IN VARCHAR2, turn_on IN BOOLEAN);

TBD

VALIDATE (new 26ai)

Undocumented dbms_ext_table_cache_int.validate( owner_nq IN VARCHAR2, table_name_nq IN VARCHAR2, raise_errors IN BOOLEAN);

TBD