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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SYNC_REFRESH
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx