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

1. Using SQL*Plus, log into the Oracle Billing Insight instance as the OLTP schema owner.
2. Run the following commands:

   SQL> set serveroutput on

   SQL> exec edx_pkg_batch_purge.pr_purge_sample;

   SQL> exit;