Re: View strange when use create table as
From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Mon, 10 Oct 2016 14:05:29 -0400
Message-ID: <CAGYrQyuPpaJsLEKFo61NoZFodTwEPAkitABKphx8udzaDm=2Ug_at_mail.gmail.com>
Date: Mon, 10 Oct 2016 14:05:29 -0400
Message-ID: <CAGYrQyuPpaJsLEKFo61NoZFodTwEPAkitABKphx8udzaDm=2Ug_at_mail.gmail.com>
Did you tried ctas nologging?
2016-10-08 17:54 GMT-04:00 Eriovaldo Andrietta <ecandrietta_at_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-lReceived on Mon Oct 10 2016 - 20:05:29 CEST