15:46:35 SQL> @update_tb_big.sql
8960000 rows updated.
Commit complete.
15:54:14 SQL>
sh-4.2$ cat update_tb_big.sql update tb_big set colc=11; commit;
sh-4.2$ cat ctas_tb_big.sql create table tb_big2 as select cola,colb,22 as colc
, cold,cole,colf,colg,colh,coli
from tb_big;
15:58:56 SQL> @ctas_tb_big.sql
Table created.
15:59:22 SQL>