EBS Customizations (MOSC)

MOSC Banner

How to backup, clear and migrate Audit data?

edited May 28, 2014 8:33AM in EBS Customizations (MOSC) 1 comment

Hello ,

Backup:

Please perform the following action plan:

Get full backup of your database before going further in the following action plan.

1. Get the old tables of the previous auditing:

select owner, object_type, object_name from dba_objects where object_name like '%_A';

WHERE EXIST in the AUDITED tables.

For all audit tables that will get back from this query, you will take backup of, like create table xyz_A_bkp as select * from xyz_A

Clear:

2. Go to all auditing groups and Disable this group using the option : Disable - Purge Table and then run the concurrent request "AuditTrail Update Tables"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center