create table A_1
(
  A1_CONK          VARCHAR2(15) not null,
  A1_KDM_FLG       VARCHAR2(100),
  A1_PRODUCT_GROUP VARCHAR2(30),
  A1_CONTACT_NAME  VARCHAR2(101),
  A1_SPEAKER_FLG   VARCHAR2(1),
  A1_CUG           VARCHAR2(200),
  A1_ACTMGR_FLG    VARCHAR2(1)
)
tablespace TBS_A
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 80K
    minextents 1
    maxextents unlimited
);

OPTIONS(SKIP=1)
LOAD DATA
INFILE '/x.dat'
BADFILE '/x.bad'
DISCARDFILE '/x.dsc'

truncate  INTO TABLE ACE2_2
FIELDS TERMINATED BY "~"
TRAILING NULLCOLS
(A2_CONK
,A2_KDM_FLG
,A2_PRODUCT_GROUP
,A2_CONTACT_NAME
,A2_SPEAKER_FLG
,A2_CUG
,A2_ACTMGR_FLG)

CONK~KDM_FLAG~PRODUCT_GROUP~CONTACT_NAME~SPEAKER_FLAG~CUG~ACCOUNT_MANAGER_FLAG