Oracle DBMS_ISYNCREF
Version 18.3.0.1

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. The name is interesting but the nature of the functionality and why it might be valuable a bit obscure at present.
AUTHID DEFINER
Dependencies
ALL_IND_PARTITIONS DBA_INDEXES DBMS_STANDARD
ALL_IND_SUBPARTITIONS DBA_MVIEWS DBMS_SYNC_REFRESH_INTERNAL
ALL_PART_INDEXES DBA_PART_INDEXES DBMS_SYSTEM
ALL_PART_TABLES DBA_TABLES KU$_PARSED_ITEM
ALL_SUBPART_KEY_COLUMNS DBMS_ASSERT KU$_PARSED_ITEMS
ALL_TAB_PARTITIONS DBMS_LOB PLITBLM
ALL_TAB_SUBPARTITIONS DBMS_METADATA SYNCREF$_GROUPS
Documented No
First Available 12.1.0
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtsnap.plb
Subprograms
 
CREATE_INDEX
Undocumented dbms_isyncref.create_index(
owner_in       IN VARCHAR2,
table_name_in  IN VARCHAR2,
new_tablespace IN VARCHAR2,
ot_name        IN VARCHAR2,
pnum           IN NUMBER,
subpnum        IN NUMBER,
is_mv          IN NUMBER,
max_attempts   IN NUMBER);
TBD
 
CREATE_TABLE
Undocumented dbms_isyncref.create_table(
owner_in       IN  VARCHAR2,
table_name_in  IN  VARCHAR2,
new_tablespace IN  VARCHAR2,
pnum           IN  NUMBER,
subpnum        IN  NUMBER,
is_mv          IN  NUMBER,
max_attempts   IN  NUMBER,
num_attempts   OUT NUMBER,
new_table_name OUT VARCHAR2);
conn sys@pdbdev as sysdba

CREATE TABLE zzyzx AS
SELECT * FROM seq$;

DECLARE
 na NUMBER;
 ntn VARCHAR2(128);
BEGIN
  dbms_isyncref.create_table('SYS', 'ZZYZX', 'SYSTEM', 1, 1, 1, 10, na, ntn);
  dbms_output.put_line(TO_CHAR(na));
  dbms_output.put_line(ntn);
END;
/
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_ISYNCREF", line 728
ORA-06512: at line 5
 
LOCKING_PRIMITIVE
Undocumented dbms_isyncref.locking_primitive(
in_group_id       IN NUMBER,
lock_flag_set_val IN NUMBER)
RETURN NUMBER;
TBD

Related Topics
Built-in Functions
Built-in Packages
Indexes
Materialized Views
Partitioning
What's New In 18cR3
What's New In 19cR3

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