RE: Toad 11 bug - attn. TOAD dev. team

This is not a bug.  The Num Rows data that Toad shows is from the info in user/all/dba_tables, which we get from Oracle.

To update it, you need to tell Oracle to analyze your table again.


1)      Rt-Click the table in the SB.

2)      Choose "Analyze Table"

3)      A new window opens.

4)      In the new window, go to the Options tab.   Check "Use DBMS Stats."  Check either "Compute" or "Estimate".

5)      Go back to the "Tables" tab (still in the new window) and click the green arrow.

6)      When it is done, you can close the window, refresh the SB and Num Rows should be updated.

From: [email protected] [mailto:[email protected]] On Behalf Of mr2001
Sent: Thursday, September 29, 2011 11:51 AM
To: [email protected]
Subject: [toad] Toad 11 bug - attn. TOAD dev. team



Message from: mr2001


Hello,

I installed TOAD 11 on a Windows XP computer. I noticed the following bug:

1. I uploaded approx. 1,200,000 records into Customers table from an Access database through an ODBC connection (in several batches).
2. I checked RECORD COUNT on Customers, it correctly shows 1,200,000 records (right-click on Customers table, chose Record Count from menu).
3. However, when I click on TABLES node in TOAD in order to show tables summary, TOAD reports only approx. 600,000 in Num Rows column for this table.

I closed the connection and reopened it. Num Rows still incorrect
I closed the whole application and reopend it - finally Num Rows column shows a correct count.

Can you please investigate this bug?

Regards,
M.R.


_______________________________________

Historical Messages


Author: mr2001
Date: Thu Sep 29 09:51:14 PDT 2011
Hello,

I installed TOAD 11 on a Windows XP computer. I noticed the following bug:

1. I uploaded approx. 1,200,000 records into Customers table from an Access database through an ODBC connection (in several batches).
2. I checked RECORD COUNT on Customers, it correctly shows 1,200,000 records (right-click on Customers table, chose Record Count from menu).
3. However, when I click on TABLES node in TOAD in order to show tables summary, TOAD reports only approx. 600,000 in Num Rows column for this table.

I closed the connection and reopened it. Num Rows still incorrect
I closed the whole application and reopend it - finally Num Rows column shows a correct count.

Can you please investigate this bug?

Regards,
M.R.

__
_______________________________________