select w.wallet_path, nvl(nm.xname, o.name), sys_xsid_to_raw(w.acl#),
o.owner
from sys.nacl$_wallet w, dba_xs_objects o, sys.nacl$_name_map nm
where w.acl# = o.id (+) and o.id = nm.acl# (+)
SELECT W.WALLET_PATH
, NVL(NM.XNAME
, O.NAME)
, SYS_XSID_TO_RAW(W.ACL#)
,
O.OWNER
FROM SYS.NACL$_WALLET W
, DBA_XS_OBJECTS O
, SYS.NACL$_NAME_MAP NM
WHERE W.ACL# = O.ID (+)
AND O.ID = NM.ACL# (+)
|
|
|