Home -> Mailing Lists -> Oracle-L -> View strange when use create table as

View strange when use create table as

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 8 Oct 2016 18:54:43 -0300
Message-ID: <CAJdDhaOBEMykexJjENh0jw3GaFhq+G6p63vobqBj7FpOJw0Y8A_at_mail.gmail.com> 





Hello,



I have a view that works fine and takes 5 minutes when I do:



spool eri.txt


select * from v_view;


spool off



But, it takes 5 hours when I do :



create table eri_test


as select * from v_view;



The result is 670.000 lines.



I don´t believe that the disk is too slow as to take 5 hours.



Any idea or comment ?



Regards


Eriovaldo


--
http://www.freelists.org/webpage/oracle-l


Received on Sat Oct 08 2016 - 23:54:43 CEST












Original text of this message