We start using Oracle 11g from Aug 2011, I'm not aware the audit trail is enabled by default. I will try to setup schedule jobs to purge audit trail regularly, before that, I don't want to keep record more than one month ago. Can I simply delete the record by timestamp? Is it ntimestamp#?
This thread is already answered.
i have to implement this purge in audition.
If you have a question open a new thread for it.
If relevant you can reference this thread from your new one.
Not only is is inappropriate to hijack a thread for your own question you will get more help in a thread of your own. A lot of the forum members that could help you won't bother looking at threads that have already been answered and won't even see your question.