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

About Purging Data

Oracle Self-Service E-Billing provides a script for purging data from the databases:

• UNIX. EDX_HOME/bin/purge_data.sh
• Windows. EDX_HOME\bin\purge_data.bat

You run the purge script from the shell command using the specific input for the type of data you want to remove, as described in the following procedures:

• Viewing Help for Running the Purge Script
• Purging Payment Account and Transactional Data
• Purging Hierarchies and Hierarchy Assignments
• Purging User Data
• Purging Statement and Invoice Fact Data
• Purging Validation Codes
• Purging Administrator Activity
• Purging Locked Administrators in Command Center
• Process of Purging Sample Data

You can also purge all related transactional data in batch mode. For information about purging data in batch mode, see Purging Data in Batch Mode.

Each time you run the purge script, Oracle Self-Service E-Billing records audit information about the purge. For information about viewing purge audit information, see Auditing Purged Data.

NOTE:  Avoid running the purge script during busy traffic periods. Always consult your DBA before purging any data from the database.