Oracle DBMS_ISYNCREF
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
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

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