create table sap_prdt_tst
    (
MATERIAL_NUMBER varchar2(20),
WEIGHT_UNIT varchar2(5),
WARRANTY_CODE varchar2(5),
NET_WEIGHT number(20,3),
PRODUCT_LINE varchar2(5),
EXPORT_CON_CLASS varchar2(17),
OBS_COMMENT varchar2(255),
PRODUCT_HIERACHY varchar2(10),
MATERIAL_GROUP varchar2(10),
LASTUPDATE varchar2(29)
)
   organization external
   (type oracle_loader
    default directory MIGRATION_DIR
    access parameters
    (
     records delimited BY '\n'
     BADFILE MIGRATION_DIR:'prdts_xt.bad'
     LOGFILE MIGRATION_DIR:'prdts_xt.log'
     NODISCARDFILE
       CHARACTERSET UTF8
       STRING SIZES ARE IN CHARACTERS 
           READSIZE 134217728
           NOBADFILE
           NODISCARDFILE
           NOLOGFILE
           SKIP 1
     fields terminated by '|'
     missing field values are null
     (
     MATERIAL_NUMBER char(20),
WEIGHT_UNIT char(5),
WARRANTY_CODE char(5),
NET_WEIGHT char(20),
PRODUCT_LINE char(5),
EXPORT_CON_CLASS char(17) ,
OBS_COMMENT char(300),
PRODUCT_HIERACHY char(10),
MATERIAL_GROUP char(10),
LASTUPDATE char(29)date_format date mask "yyyy-mm-dd"
)
   )
    location ('sap_products.txt')
   )
   parallel 4
   reject limit unlimited
   nomonitoring;

create table sap_prdt_tst
    (
      MATERIAL_NUMBER varchar2(70),
      WEIGHT_UNIT varchar2(5),
      WARRANTY_CODE varchar2(5),
      NET_WEIGHT number(20,3),
      PRODUCT_LINE varchar2(5),
      EXPORT_CON_CLASS varchar2(20),
      OBS_COMMENT varchar2(355),
      PRODUCT_HIERACHY varchar2(10),
      MATERIAL_GROUP varchar2(10),
      LASTUPDATE varchar2(29)
)
   organization external
   (type oracle_loader
    default directory MIGRATION_DIR
    access parameters
    (
     records delimited BY '\n'
     BADFILE MIGRATION_DIR:'prdts_xt.bad'
     LOGFILE MIGRATION_DIR:'prdts_xt.log'
     NODISCARDFILE
     CHARACTERSET UTF8
     STRING SIZES ARE IN CHARACTERS 
     READSIZE 134217728
     SKIP 1
     fields terminated by '|'
     missing field values are null
     (
     MATERIAL_NUMBER char(70),
     WEIGHT_UNIT char(5),
     WARRANTY_CODE char(5),
     NET_WEIGHT char(20),
     PRODUCT_LINE char(5),
     EXPORT_CON_CLASS char(20) ,
     OBS_COMMENT char(355),
     PRODUCT_HIERACHY char(10),
     MATERIAL_GROUP char(10),
     LASTUPDATE char(29)date_format date mask "yyyy-mm-dd"
)
   )
    location ('sap_products.txt')
   )
   parallel 4
   reject limit unlimited
   nomonitoring;