Re: Problem with a view: table from it contains wrong number of rows

On Fri, 17 Feb 2006 11:42:34 -0800, schonlinner wrote:

> Hi,
>
> Our database: Oracle 10g Release 2, IBM AIX, 2 proc machine.
>
> I have the following problem and I've run out of ideas :-((
>
> Suppose I have a view:
>
> create or replace view v_200601 as (
> select a,b,c,sum(d) d from mytable group by a,b,c);
>
> Then I do:
> create table t_200601 as (select * from v_200601);
>
> And then the mystery:
> select count(*) from v_200601; ==> 274324
> select count(*) from t_200601; ==> 274278
>

Does the source table have any special data types or objects (spatial, context, intermedia, etc.)? If so, you need to realize that custom objects are implemented as hidden columns and that may be throwing things off.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***