Toad World® Forums

Removing trace tables



I stopped a job before completion. How can I remove all these trace tables that were added to my database? (i.e. A_HUNDRED, A_INTEGRITY_TEMP, A_SAVEUPDATES, etc…).
Is there a tool in the Benchmark Factory that removes trace tables/files from the database?

M. R.


You can delete those tables as follow steps

  1. create a blank job,
  2. open Wizard->Benchmark Objects
  3. Select AS3AP, click Next
  4. use default settings, click Next
  5. Select “Delete Benchmark Objects” radio button, Click next, Click Finish
  6. Select a profile and submit the job.
    those tables will be deleted.


Thanks yijqrr_937, it worked!