This discussion is archived
3 Replies Latest reply: Apr 7, 2013 12:40 PM by rp0428 RSS

How can keep my ALL_TABLES information upto date?

942728 Newbie
Currently Being Moderated
Hello,

I am running the query to get the table counts from sys table ALL_TABLES, I am not getting the latest counts. Meaning , if I insert a row into a table in one of the schema table, it supposed to updated ALL_TABLES to number of rows column. But it is not doing so. I really appreciate any help.

Regards,
VR

Edited by: user7690206 on Apr 7, 2013 9:54 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points