KejianQiu

Clean IM Audit DB using Oracle Developer

Blog Post created by KejianQiu Employee on Jul 2, 2018

If IM using Oracle DB for its database and audit database needs cleaning, you can go with these steps below:

1. Login SQL Developer with imatuser/password
2. Bring up SQL Worksheet
3. Run the OOTB procedure as:
exec garbagecollectauditing12('identityEnv',TO_DATE('04/01/2018','MM/DD/YYYY'));

Remember to change the IM environment ID and cut off date to something that fit your environment.
4. Commit change.

Outcomes