Administration Guide for Oracle Billing Insight > Administering the Database >

Purging Validation Codes

You can purge the validation codes automatically generated by Oracle Billing Insight when a new user enrolls.

You can specify the number of days before which the code must have been generated. Purging validation codes removes that information from the EDX_UMF_SEC_VALIDATIONCODE table.

To purge validation codes

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 -validationcode -keepdays Number of days
   • Windows. purge_data.bat -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name -validationcode -keepdays Number of days