Re: [Beginner]Can't see records in large table

From: Harry Tuttle <>
Date: Thu, 16 May 2013 22:30:59 +0200
Message-ID: <>

Guyren Howe wrote on 16.05.2013 22:12:
> Most of the larger tables are owned by a user called flexadmin.
> However, if I log in as flexadmin and do:
> select table_name, num_rows from user_tables;
> This user has over 500 tables, but the tables all have 0 rows.

num_rows will only have a value if you analyze the tables. It's only an estimate.

What happens if you run a select count(*) on one of them? Received on Thu May 16 2013 - 22:30:59 CEST

Original text of this message