Schema Browser missing "Created" and "Last DDL" info under Tables tab (4271049)

Schema Browser missing "Created" and "Last DDL" info under Tables tab

When I go to the Schema Browser | Tables, I don't see any info for "Created" and "Last DDL."

1. Toad uses either of the following queries to retrieve the Created and Last DDL info.

   Select owner, object_name, created, last_ddl_time
   from sys.DBA_OBJECTS
   where object_type = 'TABLE'
   and owner = '<owner>';

   Select user, object_name, created, last_ddl_time
   from sys.user_objects
   Where object_type = 'TABLE';

Run it to make sure you do have rights to access sys.DBA_OBJECTS or USER_OBJECTS and that there are data.  If you see any ORA errors or if there are no data returned, then you need to look at the issue on Oracle end first - it is not a Toad issue.

2. If you are not getting any ORA error message or if you do have data the returns, run a SQL Tracker session to determine if either of the above query is being called. Refer to the steps outlined under the Additional Information section for how to run a SQL Tracker session.

3. If you do not see either of the queries being execute, it is likely a corrupt User Application Data file issue.

4. Close Toad and go to the following locations:

For Win Vista, 7, 2008 - C:Users\<user>\AppData\Local\Quest Software\Toad for Oracle 
For Win XP - C:\Documents and Settings\<user>\Local Settings\Application Data\Quest Software\Toad for Oracle

5. Rename the 11.X folder to 11.X_OLD

6. Rename the SettingsLocations.ini to SettingsLocations.ini_OLD

7. Start Toad and you should see your Created and Last DLL info

How to run a SQL Tracker session a. In the Toad main menu, go to Database | Monitor | SQL Tracker b. At the SQL Tracker window, select "Toad.exe" c. Click on the green arrow button to start tracking Note: Everything you do in Toad now will be captured by the SQL Tracker, but you don't want to see everything just the relevant part. Use the Clear Output (i.e. it looks like a white paper with the top right corner folder) icon to clear unnecessary data before you make your run. d. Go back to Toad and make your run to cause the issue e. Go back to SQL Tracker to get what Toad captured