Re: [Beginner]Can't see records in large table
From: Harry Tuttle <SOZRBLNTLEEE_at_spammotel.com>
Date: Thu, 16 May 2013 22:30:59 +0200
Message-ID: <avku00F5q3vU1_at_mid.individual.net>
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.
Date: Thu, 16 May 2013 22:30:59 +0200
Message-ID: <avku00F5q3vU1_at_mid.individual.net>
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