Oracle | DBMS_SYNC_REFRESH

Oracle DBMS_SYNC_REFRESH_INTERNAL 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 Undocumented

AUTHID DEFINER

Dependencies

ALL_OBJECTS	DBMS_ISYNCREF	OBJ$
ALL_PART_KEY_COLUMNS	DBMS_SNAPSHOT_COMMON	PLITBLM
ALL_PART_TABLES	DBMS_SNAPSHOT_LIB	SUMDETAIL$
ALL_TAB_PARTITIONS	DBMS_STANDARD	SYNCREF$_GROUP_STATUS
CANSYNCREFARRAYTYPE	DBMS_SYNC_REFRESH	SYNCREF$_OBJECTS
DBA_OBJECTS	DBMS_SYSTEM	SYNCREF$_OBJECT_STATUS
DBMS_ASSERT	DBMS_SYS_ERROR	SYNCREF$_PARAMETERS
DBMS_IREFRESH	DBMS_UTILITY	SYNCREF$_PARTN_OPS
DBMS_ISNAPSHOT	DUAL	USER$

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted.

Direct access to this package is prevented by means of an Accessible By clause.

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

Subprograms

ABORT_REFRESH	GET_GROUP_ID	REGISTER_MVIEWS
ALTER_REFRESH_STATS_RETENTION	GET_GROUP_ID_LIST	REGISTER_PARTITION_OPERATION
CAN_SYNCREF_TABLE	PREPARE_REFRESH	UNREGISTER_MVIEWS
EXECUTE_REFRESH	PREPARE_STAGING_LOG	UNREGISTER_PARTITION_OPERATION
GET_ALL_GROUP_IDS	PURGE_REFRESH_STATS

ABORT_REFRESH

Undocumented

Overload 1 dbms_sync_refresh_internal.abort_refresh;

exec dbms_sync_refresh_internal.abort_refresh;

      BEGIN dbms_sync_refresh_internal.abort_refresh; END;

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_SYNC_REFRESH_INTERNAL

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

Overload 2 dbms_sync_refresh_internal.abort_refresh(retention IN NUMBER);

TBD

ALTER_REFRESH_STATS_RETENTION

Undocumented dbms_sync_refresh_internal.alter_refresh_stats_retention(retention IN NUMBER);

exec dbms_sync_refresh_internal.alter_refresh_stats_retention(30);

      BEGIN dbms_sync_refresh_internal.alter_refresh_stats_retention; END;

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_SYNC_REFRESH_INTERNAL

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

CAN_SYNCREF_TABLE

Undocumented

Overload 1 dbms_sync_refresh_internal.can_syncref_table( schema_name IN VARCHAR2, table_name IN VARCHAR2, statement_id IN VARCHAR2, cuser IN VARCHAR2);

TBD

Overload 2 dbms_sync_refresh_internal.can_syncref_table( schema_name IN VARCHAR2, table_name IN VARCHAR2, output_array IN OUT sys.cansyncrefarraytype, cuser IN VARCHAR2);

TBD

EXECUTE_REFRESH

Undocumented

Overload 1 dbms_sync_refresh_internal.execute_refresh( group_id IN BINARY_INTEGER, cuser IN VARCHAR2);

TBD

Overload 2 dbms_sync_refresh_internal.execute_refresh( group_id_list IN sys.dbms_utility.number_array, cuser IN VARCHAR2);

TBD

GET_ALL_GROUP_IDS

Undocumented dbms_sync_refresh_internal.get_all_group_ids RETURN sys.dbms_utility.number_array;

TBD

GET_GROUP_ID

Undocumented dbms_sync_refresh_internal.get_group_id( object_name IN VARCHAR2, cuser IN VARCHAR2) RETURN NUMBER;

TBD

GET_GROUP_ID_LIST

Undocumented dbms_sync_refresh_internal.get_group_id_list( object_name_list IN VARCHAR2, cuser IN VARCHAR2) RETURN sys.dbms_utility.number_array;

TBD

PREPARE_REFRESH

Undocumented

Overload 1 dbms_sync_refresh_internal.prepare_refresh( group_id IN BINARY_INTEGER, cuser IN VARCHAR2);

TBD

Overload 2 dbms_sync_refresh_internal.prepare_refresh( group_id_list IN sys.dbms_utility.number_array, cuser IN VARCHAR2);

TBD

PREPARE_STAGING_LOG

Undocumented dbms_sync_refresh_internal.prepare_staging_log( schema_name IN VARCHAR2, base_table_name IN VARCHAR2, psl_mode IN BINARY_INTEGER);

TBD

PURGE_REFRESH_STATS

Undocumented dbms_sync_refresh_internal.purge_refresh_stats( before_timestamp IN TIMESTAMP WITH TIME ZONE);

TBD

REGISTER_MVIEWS

Undocumented dbms_sync_refresh_internal.register_mviews( mv_list IN VARCHAR2, cuser IN VARCHAR2);

TBD

REGISTER_PARTITION_OPERATION

Undocumented dbms_sync_refresh_internal.register_partition_operation( partition_op IN VARCHAR2, schema_name IN VARCHAR2, base_table_name IN VARCHAR2, partition_name IN VARCHAR2, outside_partn_table_schema IN VARCHAR2, outside_partn_table_name IN VARCHAR2, validation IN BOOLEAN);

TBD

UNREGISTER_MVIEWS

Undocumented dbms_sync_refresh_internal.unregister_mviews( mv_list IN VARCHAR2, cuser IN VARCHAR2);

TBD

UNREGISTER_PARTITION_OPERATION

Undocumented dbms_sync_refresh_internal.unregister_partition_operation( partition_op IN VARCHAR2, schema_name IN VARCHAR2, base_table_name IN VARCHAR2, partition_name IN VARCHAR2);

TBD