Oracle | DBMS_ISYNCREF

Oracle DBMS_ISYNCREF 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. 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