oracleÓαê

drop table tmp_lzw_3283_tar;
create table tmp_lzw_3283_tar
(
    servnumber varchar2(11)
)
;
load data
infile 'tar_3283.txt'
insert into table tmp_lzw_3283_tar
fields terminated by '|'
(
servnumber
)
/*
select count(*),count(distinct servnumber) from tmp_lzw_3283_tar;
  COUNT(*) COUNT(DISTINCTSERVNUMBER)
---------- -------------------------
       263                       254
*/
---¹ØÁªÓû§±í
----È¡È«Æ·ÅÆÓû§Æ·ÅÆÊý¾Ý         
drop table tmp_lzw_3278_tmp_tb0 purge;                                                              
create table tmp_lzw_3278_tmp_tb0 nologging as                                                                       
select /*+ parallel(c,16) */                                                                       &