Oracle | DBMS_IREFRESH

Oracle DBMS_IREFRESH Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Internal support for Materialized View refreshes

AUTHID DEFINER

Dependencies

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

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

DESTROY

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

exec dbms_irefresh.destroy(42);

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

Undocumented dbms_irefresh.enquote_literal(str IN VARCHAR2) RETURN VARCHAR2;

SQL> SELECT dbms_irefresh.enquote_literal('SELECT * FROM dual')

        2  FROM dual;

      

      DBMS_IREFRESH.ENQUOTE_LITERAL('SELECT*FROMDUAL')

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

      'SELECT * FROM dual'

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(42);

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