Oracle DBMS_ISYNCREF
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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_SYNC_REFRESH
ALL_IND_SUBPARTITIONS DBA_MVIEWS DBMS_SYSTEM
ALL_PART_INDEXES DBA_PART_INDEXES KU$_PARSED_ITEM
ALL_PART_TABLES DBA_TABLES KU$_PARSED_ITEMS
ALL_SUBPART_KEY_COLUMNS DBMS_ASSERT PLITBLM
ALL_TAB_PARTITIONS DBMS_LOB SYNCREF$_GROUPS
ALL_TAB_SUBPARTITIONS DBMS_METADATA  
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
Indexes
Materialized Views
Packages
Partitioning
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