Oracle | DBMS_ISYNCREF

Oracle DBMS_ISYNCREF Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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_MVIEWS	DBMS_STANDARD
ALL_IND_SUBPARTITIONS	DBA_PART_INDEXES	DBMS_SYNC_REFRESH_INTERNAL
ALL_PART_INDEXES	DBA_TABLES	DBMS_SYSTEM
ALL_PART_TABLES	DBMS_ASSERT	KU$_PARSED_ITEM
ALL_SUBPART_KEY_COLUMNS	DBMS_LOB	KU$_PARSED_ITEMS
ALL_TAB_PARTITIONS	DBMS_METADATA	PLITBLM
ALL_TAB_SUBPARTITIONS	DBMS_SNAPSHOT_LIB	SYNCREF$_GROUPS
DBA_INDEXES

Documented No

First Available 12.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtsnap.plb

Subprograms

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