Developing Sun Master Indexes

ProcedureTo Delete Database Tables

  1. Open a standard SQL editor and connect to the master index database using the user you created in Step 2: Create a Master Index Database and User.

  2. Open drop.sql in the NetBeans editor.

  3. Copy and paste the entire text of drop.sql into the SQL editor.

  4. Run the script against the database.

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


    PURGE RECYCLEBIN;