Oracle | DBMS_IREFRESH

Oracle DBMS_IREFRESH Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Internal support for Materialized View refreshes

AUTHID DEFINER

Dependencies

DBA_REFRESH	DBMS_SCHEDULER	DBMS_UTILITY
DBA_SCHEDULER_JOBS	DBMS_SNAPSHOT	DUAL
DBA_SCHEDULER_JOB_CLASSES	DBMS_SNAPSHOT_KKXRCA	JOB$
DBMS_ASSERT	DBMS_SNAPSHOT_LIB	JOB_DEFINITION
DBMS_IJOB	DBMS_SNAP_INTERNAL	JOB_DEFINITION_ARRAY
DBMS_ISCHED	DBMS_SQL	RGCHILD$
DBMS_ISNAPSHOT	DBMS_STANDARD	RGROUP$
DBMS_LOCK	DBMS_SYNC_REFRESH_INTERNAL	RGROUPSEQ
DBMS_MVIEW_STATS	DBMS_SYSTEM	SNAP$
DBMS_MVIEW_STATS_INTERNAL	DBMS_SYS_ERROR	USER$
DBMS_REFRESH	DBMS_SYS_SQL

Documented No

Exceptions

Error Code	Reason
ORA-23405	refresh group number <integer> does not exist

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the EXP_FULL_DATABASE and IMP_FULL_DATABASE roles

Source {ORACLE_HOME}/rdbms/admin/prvtsnps.plb

Subprograms

ADD

Undocumented

Overload 1 dbms_irefresh.add( name IN VARCHAR2, item IN VARCHAR2, duser IN VARCHAR2, siteid IN BINARY_INTEGER, export_db IN VARCHAR2);

TBD

Overload 2 dbms_irefresh.add( g# IN BINARY_INTEGER, tab IN dbms_utility.uncl_array, lax IN BOOLEAN, siteid IN BINARY_INTEGER, export_db IN VARCHAR2);

TBD

CHANGE

Undocumented dbms_irefresh.change( rg# IN BINARY_INTEGER, next_date IN DATE, interval IN VARCHAR2, implicit_destroy IN BOOLEAN, rollback_seg IN VARCHAR2, push_deferred_rpc IN BOOLEAN, refresh_after_errors IN BOOLEAN, purge_option IN BINARY_INTEGER, parallelism IN BINARY_INTEGER, heap_size IN BINARY_INTEGER);

TBD

CHECK_TAB

Undocumented dbms_irefresh.check_tab( tab IN dbms_utility.uncl_array, default_user IN VARCHAR2);

TBD

COMPUTE_REFRESH_JOBCLASS (new 23ai)

Undocumented dbms_irefresh.compute_refresh_jobclass(jobclass OUT VARCHAR2);

DECLARE

       outVal dbms_id;

      BEGIN

        dbms_irefresh.compute_refresh_jobclass(outVal);

        dbms_output.put_line(outVal);

      END;

      /

      DEFAULT_JOB_CLASS

      

      PL/SQL procedure successfully completed.

DESTROY

Remove a fresh group dbms_irefresh.destroy(rg# IN BINARY_INTEGER);

exec dbms_irefresh.destroy(781);

      

      PL/SQL procedure successfully completed.

DROP_USER_GROUPS

Undocumented dbms_irefresh.drop_user_groups(uname IN VARCHAR2);

TBD

DUMP_REFRESH_INFO

Undocumented dbms_irefresh.dump_refresh_info(str IN VARCHAR2);

TBD

ENQUOTE_LITERAL

Places single quote around the string submitted in the str parameter dbms_irefresh.enquote_literal(str IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_irefresh.enquote_literal('SQL Injection Attack String');

      

      ENQUOTED

      -------------------------------------------------

      'SQL Injection Attack String'

FULL_EXPORT

Undocumented dbms_irefresh.full_export( rg# IN BINARY_INTEGER, mycall IN OUT VARCHAR2);

TBD

FULL_EXPORT_CHILD

Undocumented dbms_irefresh.full_export_child( myowner IN VARCHAR2, myname IN VARCHAR2, mytype IN VARCHAR2, mycall IN OUT VARCHAR2, mysite IN BINARY_INTEGER);

TBD

GET_BASENAME

Undocumented dbms_irefresh.get_baseName( name IN VARCHAR2, realown IN OUT VARCHAR2, realnam IN OUT VARCHAR2, def_user IN VARCHAR2);

TBD

GET_NAME

Undocumented dbms_irefresh.get_name( name IN VARCHAR2, myowner IN OUT VARCHAR2, robj IN OUT VARCHAR2, downer IN VARCHAR2);

TBD

LOCK_GROUP

Undocumented dbms_irefresh.lock_group(rg# IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

MAKE

Undocumented

Overload 1 dbms_irefresh.make( rowner IN VARCHAR2, rname IN VARCHAR2, implicit_destroy IN BOOLEAN, job IN BINARY_INTEGER, rollback_seg IN VARCHAR2, push_deferred_rpc IN BOOLEAN, refresh_after_errors IN BOOLEAN, purge_option IN BINARY_INTEGER, parallelism IN BINARY_INTEGER, heap_size IN BINARY_INTEGER);

TBD

Overload 2 dbms_irefresh.make( rowner IN VARCHAR2, rname IN VARCHAR2, tab IN dbms_utility.uncl_array, next_date IN DATE, interval IN VARCHAR2, implicit_destroy IN BOOLEAN, lax IN BOOLEAN, job IN BINARY_INTEGER, rollback_seg IN VARCHAR2, PUSH_DEFERRED_rpc IN BOOLEAN, REFRESH_AFTER_errors IN BOOLEAN, purge_option IN BINARY_INTEGER, parallelism IN BINARY_INTEGER, heap_size IN BINARY_INTEGER);

TBD

MAKE_REPAPI

Undocumented

Overload 1 dbms_irefresh.repAPI( owner IN VARCHAR2, name IN VARCHAR2, siteid IN BINARY_INTEGER, refresh_seq IN BINARY_INTEGER, export_db IN VARCHAR2, rg# OUT BINARY_INTEGER, flag IN BINARY_INTEGER, refgroup IN BINARY_INTEGER);

TBD

Overload 2 dbms_irefresh.repAPI( refgroup IN BINARY_INTEGER, owner IN VARCHAR2, name IN VARCHAR2, siteid IN BINARY_INTEGER, refresh_seq IN BINARY_INTEGER, export_db IN VARCHAR2, flag IN BINARY_INTEGER);

TBD

REFGROUP

Undocumented dbms_irefresh.refGroup( name IN VARCHAR2, siteid IN BINARY_INTEGER, RETURN BINARY_INTEGER);

TBD

REFRESH

Forces a refresh group refresh dbms_irefresh.refresh(rg# IN BINARY_INTEGER);

exec dbms_irefresh.refresh(784);

SUBMIT_JOB

Undocumented dbms_irefresh.submit_job( rowner IN VARCHAR2, gname IN VARCHAR2, next_date IN DATE, internal IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

SUBTRACT

Undocumented dbms_irefresh.subtract( rg# IN BINARY_INTEGER, tab IN dbms_utility.uncl_array, lax IN BOOLEAN, siteid IN BINARY_INTEGER);

TBD

USER_EXPORT

Undocumented dbms_irefresh.user_export( rg# IN BINARY_INTEGER, mycall IN OUT VARCHAR2);

TBD

USER_EXPORT_CHILD

Undocumented dbms_irefresh.user_export_child( myowner IN VARCHAR2, myname IN VARCHAR2, mytype IN VARCHAR2, mycall IN OUT VARCHAR2, mysite IN BINARY_INTEGER);

TBD