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

Purging User Data

You can purge user data for:

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

NOTE:  When you purge a user, all scheduled recurring payments and one-time payments for this user cancel.

Purging user data removes information from the following OLTP tables:

• EDX_BSL_SEC_PROF_ATTRIBS
• EDX_BSL_SEC_PROF_ROLES_LINK
• EDX_BSL_USER_PROF_ATTRIBS
• EDX_UMF_SEC_ATTEMPTS
• EDX_UMF_SEC_QUESTION
• USER_SERVICE_AGREEMENT
• EDX_UMF_USER_ACCT_LINK
• ADDRESS_BOOK_PERSONAL
• EDX_UMF_BULK_ENROLL_LOG
• EDX_BSL_UMF_USER
• EDX_UMF_SEC_PWD_HISTORY
• EDX_BSL_AUTH_SECPROFILE

Purging user data also removes information from the EDX_UMF_USER_ACCT_LINK OLAP table.

To purge user data

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