Deleting Master Index Database Tables and Indexes

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

To Delete Database Tables and Indexes

1. To drop the indexes created by the Create User Indexes script:

   1. Right-click Drop User Indexes.

   2. Select Run.

   3. On the confirmation dialog box, click OK.

2. To drop the database tables:

   1. Right-click Drop Person Database.

   2. Select Run.

   3. On the confirmation dialog box, click OK.

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

   PURGE RECYCLEBIN;