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
Internal utilities providing support for autonomous maintenance and creation of zone maps.
This procedure was present in 20c and appears to not be ready for use in 21c and continues to fail in 23.1 Beta
dbms_auto_zonemap_internal.zmap_execute;
exec dbms_auto_zonemap_internal.zmap_execute;
BEGIN dbms_auto_zonemap_internal.zmap_execute; END;
*
ERROR at line 1:
ORA-40216: feature not supported
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 66
ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 233
ORA-06512: at line 1
ZMAP_GET_AUTOZM_MODE
Presumably returns the current auto zonemap mode
This function was not present in 20c and appears to not be ready for use in 21c and continues to fail in 23.1 Beta
DECLARE
retVal dbms_id;
BEGIN
retVal := dbms_auto_zonemap_internal.zmap_get_autozm_mode;
dbms_output.put_line(retVal);
END;
/
DECLARE
*
ERROR at line 1:
ORA-40216: feature not supported
ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 295
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 148
ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 274
ORA-06512: at line 4
dbms_auto_zonemap_internal.zmap_report(
start_time IN TIMESTAMP WITH TIME ZONE,
end_time IN TIMESTAMP WITH TIME ZONE,
report_xml IN OUT sys.xmltype,
section IN VARCHAR2,
level IN VARCHAR2);