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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark Oracle 22.214.171.124 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