Developing Sun Master Patient Indexes

ProcedureTo 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;