Oracle - Audit Trail

Does oracle have Audit Trail as an inbuilt functionality?

Do i need to create separate table for Audit Log purpose to capture INSERT,开发者_StackOverflow社区 UPDATE and DELETE changes?

---

Yes, Oracle does support auditing. You won't need to create the audit tables yourself, but you will need to configure the audit settings (i.e. which tables/users/queries to audit).

http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/security.htm#i16445