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.
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);
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