Developing Sun Master Indexes (Repository)

Deleting Master Index Database Tables (Repository)

Scripts are provided to drop the default database tables and indexes created in Step 8: Create the Master Index Database Structure (Repository). This is useful while testing the master index application implementation.

ProcedureTo Delete Database Tables (Repository)

  1. Right-click Drop app_name Database (where app_name is the name of the master index application).

  2. Select Run.

  3. On the confirmation dialog box, click OK.

  4. If the database is running on the Oracle 10g platform, open a SQL prompt and run the following command.


    PURGE RECYCLEBIN;