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 (found in the EDX_HOME/bin directory (or the EDX_HOME\bin directory on Windows):

• UNIX. purge_data.sh
• Windows. 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:

• 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. For information about purging data in batch mode, see Purging Data in Batch.

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.

Viewing Help for Running the Purge Script

Complete the following task to view help with general usage information for the purge script.

To get help for using the Oracle Self-Service E-Billing purge script

• Run the following shell script (found in the EDX_HOME/bin directory or the EDX_HOME\bin directory on Windows), where EDX_HOME is the directory where you installed Oracle Self-Service E-Billing:

  UNIX:

  ./purge_data.sh -help

  Windows:

  purge_data.bat -help