Home » RDBMS Server » Server Administration » one query plz
one query plz [message #219716] Thu, 15 February 2007 11:44 Go to next message
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
Member
hai to every one,

i want to know how many rows are in each table in the user tables

regards,
pavan
Re: one query plz [message #219717 is a reply to message #219716] Thu, 15 February 2007 11:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Update your stats, look into num_rows.
But this information may always not be reliable.
As the stats get outdated, values of NUM_ROWS are outdated.
The value of NUM_ROWS depends on stats and someone can easily change it using dbms_stats.
Re: one query plz [message #219718 is a reply to message #219717] Thu, 15 February 2007 11:49 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And please search before posting. There many threads talking about this.
http://www.orafaq.com/forum/m/121074/42800/?srch=num_rows#msg_121602
Previous Topic: Tablespace migration : Local to dictionary
Next Topic: Why we find 2 ADMINS ( SYS and SYSTEM )!!?
Goto Forum:
  


Current Time: Mon Dec 05 19:09:22 CST 2016

Total time taken to generate the page: 0.11902 seconds