Oracle DBMS_IREFRESH
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Internal support for Materialized View refreshes
AUTHID DEFINER
Dependencies
DBA_REFRESH DBMS_SNAP_INTERNAL DUAL
DBMS_ASSERT DBMS_SQL JOB$
DBMS_IJOB DBMS_STANDARD RGCHILD$
DBMS_ISNAPSHOT DBMS_SYNC_REFRESH_INTERNAL RGROUP$
DBMS_MVIEW_STATS DBMS_SYSTEM RGROUPSEQ
DBMS_MVIEW_STATS_INTERNAL DBMS_SYS_ERROR SNAP$
DBMS_REFRESH DBMS_SYS_SQL STANDARD
DBMS_SNAPSHOT DBMS_UTILITY USER$
DBMS_SNAPSHOT_KKXRCA    
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 exp_full_database, imp_full_database,
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 1 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 (new 12.2)
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 (new 12.2)
Undocumented dbms_irefresh.user_export(
rg#    IN     BINARY_INTEGER,
mycall IN OUT VARCHAR2);
TBD
 
USER_EXPORT_CHILD (new 12.2)
Undocumented dbms_irefresh.user_export_child(
myowner IN     VARCHAR2,
myname  IN     VARCHAR2,
mytype  IN     VARCHAR2,
mycall  IN OUT VARCHAR2,
mysite  IN     BINARY_INTEGER);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_IREFSTAT
DBMS_MVIEW
DBMS_REFRESH
DBMS_SNAPSHOT_UTL
Materialized Views
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved