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

Auditing Purged Data


When you purge data using the purge script, a list of messages appears in the format:

Number of entries removed from table name.

Each time you run the purge script, Oracle Self-Service E-Billing records audit information about the purge in the EDX_PURGE_LOG table in the OLTP instance.

The data recorded in the EDX_PURGE_LOG table includes the following information:

  • When purges occurred
  • Which database tables were purged
  • How much data in the table was removed

NOTE:  Sometimes you cannot see the full purged information on the console screen but data did purge in the tables, that's because the output function does not work through database link. Please refer to EDX_PURGE_LOG for the full removing information.

Administration Guide for Oracle Self-Service E-Billing Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.