Administration Guide for Oracle Billing Insight > Administering the Database >

Purging User Data

You can purge user data for:

• A specific company ID
• A specific user ID
• All Consumer Edition users
• Inactive users for a specific company ID
• Inactive Consumer Edition 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_ATTRIBSF
• EDX_UMF_SEC_ATTEMPTS
• EDX_UMF_SEC_QUESTION
• USER_SERVICE_AGREEMENT
• EDX_UMF_USER_ACCT_LINK (OLAP only; Consumer Edition only)
• EDX_UMF_USER_ACCT_LINK (Consumer Edition only)
• EDX_RPT_CONTACT_PERSONAL
• ADDRESS_BOOK_PERSONAL
• EDX_UMF_BULK_ENROLL_LOG
• EDX_UMF_EMAIL_VALIDATION
• EDX_RPT_BATCH_SCHED_REQ_PARAMS
• EDX_RPT_BATCH_SCHEDULE_REQ
• EDX_RPT_BATCH_PARAMS
• EDX_RPT_BATCH_CONTENT
• EDX_RPT_BATCH_REPORT
• EDX_RPT_CUSTOM_COLUMNS
• EDX_RPT_CUSTOM_PARAMS
• EDX_RPT_CUSTOM_REPORT
• 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

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 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