can I audit a truncate on a specific table in Oracle8?

[xanuda]

Hi all:

I want to audit a truncate command on just three tables in a database.
I have been reading ORacle manuals and books, but I can't see how to do that,
I can turn on auditing for ALL truncates on ALL tables, but that will be
too much info (and overhead). Is there a way to do auditing on a truncate
on a specific table(s) only?

thanks

Gene

[Js]

Re: can I audit a truncate on a specific table in Oracle8?

Hi,

If you are using 9i then you can create a trigger of truncate event.
And maintain a log for this activity.


Thanks,
Js