[oracle_br] Insert - Select

[Raphael Franco]

Oracle 10g SE R2


Pessoal porque não gravam os mesmos dados na tabela que o select ??
Insiro isso:


insert into as_vinte_maiores_tab
    select segment_name, object_type, a.owner, tamanho, tablespace_name,sysdate 
data
    from (select rownum, segment_name, owner,tablespace_name, 
sum(bytes/1024/1024) Tamanho
    from dba_segments group by rownum, segment_name, owner,tablespace_name
    order by sum(bytes/1024/1024) desc) a,
    dba_objects b
    where a.segment_name = b.object_name
    and rownum < 20;



Porém o resultado de:

select * from as_vinte_maiores_tab;

são diferentes de:


    select segment_name, object_type, a.owner, tamanho, tablespace_name,sysdate 
data
    from (select rownum, segment_name, owner,tablespace_name, 
sum(bytes/1024/1024) Tamanho
    from dba_segments group by rownum, segment_name, owner,tablespace_name
    order by sum(bytes/1024/1024) desc) a,
    dba_objects b
    where a.segment_name = b.object_name
    and rownum < 20;



att.
Phael


[As partes desta mensagem que não continham texto foram removidas]