Oracle | DBMS_SYNC_REFRESH

Oracle DBMS_SYNC_REFRESH_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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.

All functionality is protected by an ACCESSIBLE BY clause as demonstrated below.

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