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

Purging Data in Batch

You can purge all related transactional data in batch for:

• A specific company ID
• A specific user ID
• All Consumer Edition (B2C) users

NOTE:  Payment history data is excluded, as some clients have restrictions on deleting any payment for x number of months. The scheduled payments will be cancelled 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 (cancelled)
• 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.

This task is a step in Process of Purging Sample Data.

To purge data in batch

• 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 data in batch for a specific company ID: -company "Company ID"
  • Purge data in batch for a specific user ID: -user User ID
  • Purge data in batch for all B2C users: -user -b2c