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@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 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

Other related posts: