select '1','0',
o.obj#,
t.audit$,
sys.dbms_metadata_util.get_audit_default(o.obj#)
from tab$ t, obj$ o
where o.name = '_default_auditing_options_'
and o.owner# = 0
and t.obj# = o.obj#
and trim('-' from replace(t.audit$,chr(0),'-')) IS NOT NULL
SELECT '1'
, '0'
,
O.OBJ#
,
T.AUDIT$
,
SYS.DBMS_METADATA_UTIL.GET_AUDIT_DEFAULT(O.OBJ#)
FROM TAB$ T
, OBJ$ O
WHERE O.NAME = '_DEFAULT_AUDITING_OPTIONS_'
AND O.OWNER# = 0
AND T.OBJ# = O.OBJ#
AND TRIM('-'
FROM REPLACE(T.AUDIT$
, CHR(0)
, '-')) IS NOT NULL
|
|
|