Oracle DBMS_IREFRESH
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
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