Getting error when loading trace file in browser

Toad for Oracle
1

This is my first attempt at using TOAD Trace Browser. Toad created a user “TOAD” for me. The connection is correct and the dump file loaction is pointing to the correct location where the trc files should be. However, when I select the LOAD button to load the trace files I get this error:

ORA-29532: Java call terminated by uncaught Java exception: oracle.jdbc.driver.OracleSQLException: ORA-25153: Temporary Tablespace is Empty
ORA-06512: at “TOAD.POPULATE_TOAD_DIR_LISTING”, line 1
ORA-06512: at line 4

It’s similar to others on the internet, but haven’t found any where the Populate Toad Dir Listing is empty. Is there another step I’m missing in setting this up?

Thanks for any assistance.

Dwayne

2

I don’t think it’s a setup problem with trace file browser.

Sounds like you have a temporary tablespace defined that does not have any datafiles associated with it. Check on that.

3

Yes this was my issue, Thanks. We had created the tablespace but no data file. This was done as the result of a restore and the use of a script missing the proper command.