-
I would like to be able to identify which tables have been altered during the previous day (inserts, deletes, updates and structural changes).
I presume that auditing would provide the information I need, but I have no idea how to go about it.
I'm running 8i standard edition on NT
Can anyone help ?
-
audit all on schema_name.table_name;
The audit entries will be inserted in the sys.aud$ table. Keep an eye on the growth of this table.
-
set audit_trail=db in initSID.ora
-
Halo
Do I need to do this for every table ?
Or is there something I can set by say, user ?
-
As he mentioned set this value in your initSID.ora file not for every table
-
I believe you would have to do that for every table.
-
Hi
You have to set initilization parameter file nothing but init.ora file not for every table and u cant set this for every table.U can set this to DB or OS or NONE
-
If I want to turn off audting for a table, what do I do ?
-
Once u set the parameter.You have to issue an audit command on the objects what u want to audit.At the same time u have noaudit command for the object which you dont want to audit.
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
|