-
select SQLBIND ,SQLTEXT from AUD$ via dblink
Hi
Is there any way of selecting
select SQLBIND ,SQLTEXT from AUD$ from remote database.?
Thank YOU ..
-
Yes, but I would target DBA_AUDIT_TRAIL instead of AUD$
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Thanks a lot PAVB.
The idea is to move old records, say older then 1 month from many databases AUD$ files into one and keep it there for a while just in case for reporting purposes.
Though SQL_BIND/SQL_TEXT fields are converted to NVARCHAR2(2000) instead of clob type it 's a good work around if there is no other way.
Thanks again..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|