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
|