Administration Guide for Oracle Billing Insight > Administering the Database >

Purging Data in Batch Mode

You can purge all related transactional data in batch mode for:

• A specific company ID
• A specific user ID
• All Consumer Edition users

NOTE:  Payment history data is excluded, as some clients have restrictions on deleting any payment for a particular number of months. The scheduled payments will be canceled as users are removed from database.

Purging data for a specific company ID removes the following information:

• Payment accounts
• Payment invoice
• Payment notification
• Hierarchies
• Statements and invoice
• Accounts and services
• Scheduled payments for the users in this company (canceled)
• User profiles
• Company itself
• Recurring payment

Purging data for a specific user ID or for all B2C users removes the following information:

• Payment accounts
• Payment invoice
• Payment notification
• Hierarchy user assignment
• Cancel scheduled payments for this user
• User profile
• Recurring payment

Complete the following task to purge data in batch mode.

To purge data in batch mode

1. Go to the following directory:
   • UNIX. EDX_HOME/bin
   • Windows. EDX_HOME\bin
2. Run the following command:
   • UNIX. ./purge_data.sh -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name Input
   • Windows. purge_data.bat -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name Input

     where Input is one of the following:

   • Purge data in batch mode for a specific company ID: -company "Company ID"
   • Purge data in batch mode for a specific user ID: -user User ID
   • Purge data in batch mode for all B2C users: -b2c