Administration Guide for Oracle Self-Service E-Billing > Administering the Database >

Purging Administrator Activity

You can purge the audit history of the administrator activity from the ADMIN_ACTIVITY table.

You can purge the administrator activity for:

• A specific administrator
• All administrators

To purge administrator activities

• Run the following command from the EDX_HOME/bin directory (the EDX_HOME\bin directory on Windows):

  UNIX:

  ./purge_data.sh -connstr OLTP schema username/OLTP schema password@OLTP TNS name Input

  Windows:

  purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP TNS name Input

  where Input is one of the following:

  • Purge administrator activity for a specific user ID: -adminactivity -user User ID
  • Purge administrator activity for all user IDs: -adminactivity -user -all