Administration Guide for Oracle Billing Insight > Administering the Database >
Purging Sample Data
You must purge sample data from the Oracle Billing Insight database after performing any necessary installation test runs. Oracle Billing Insight provides a script for purging all sample data in the Oracle Billing Insight database, except for the partitions created with sample data. CAUTION: Once you load production data, do not run the sample data purge; the script purges all data in the Oracle Billing Insight database. If you want to purge the data associated with a specific company, consumer user, or consumer billing account, and so on, use the instructions for the related purge option.
To purge sample data
- Using SQL*Plus, log into the Oracle Billing Insight instance as the OLTP schema owner.
- Run the following commands:
SQL> set serveroutput on
SQL> exec edx_pkg_batch_purge.pr_purge_sample;
SQL> exit;
|