Re: How many rows?

I've also found something that illustrates what Brandon Allen wrote below (directly from "Expert Oracle Database Architecture"):

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6611962171229#70611902328667

On 11/10/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
>
> I don't have any experience with external tables, but I wonder if you did an
> "alter table your_external_table project column all" and then ran the two
> selects again if that would make them match? For more info on the "project
> column all" and "project column referenced" clauses:
>
> http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm
>
>
> ________________________________
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Bobak, Mark
>
>
> Oracle 9.2.0.6 64-bit on Sparc-Solaris 9.
>
> I have an external table. If I select * from table, I get 3,371 rows. If I
> select count(*), I get 3,631??

-- 
Alberto Dell'Era
"Per aspera ad astra"
--
http://www.freelists.org/webpage/oracle-l