import a CSV datafile using Oracle Loader

# This script will import a CSV datafile

# Remove any previous failure logs
#
rm -f /home/oracle/impt_data/*.log
rm -f /home/oracle/impt_data/*.bad

sqlplus / as sysdba <<-!
set lines 2000
set pages 0
create or replace directory imp_data as '/home/oracle/imp_data';
grant read,write on directory impx_data to myschema;
connect myschema/xxxxx;
alter session set NLS_DATE_FORMAT = "MM/DD/YY";
drop table external_impdata_201255321;
drop table impdata_201255321;

create table external_data_test
("X_NR" NUMBER(*,0),
"X_ORG_FK" NUMBER(*,0),
"X_JAHR" NUMBER(*,0),
"X_MONAT" NUMBER(*,0),
"X_TAG" NUMBER(*,0),
"X_DATUM" NUMBER(*,0),
"X_JAHR_MONAT" NUMBER(6,0),
"X_DATUM_KURZ" NUMBER(8,0),
"X_WOCHE" NUMBER,"DAT_WAIVER" NUMBER(1,0),
"X_OLD_PLAN" NUMBER(10,2),
"X_OVER_PLAN" NUMBER(10,2),
"X_AUTO_WAIVER" NUMBER(1,0))organization  external
(type ORACLE_LOADER default directory mycsv access parameters ( RECORDS DELIMITED BY newline FIELDS TERMINATED BY ","  OPTIONALLY ENCLOSED BY '"')location ('export.csv')) reject limit unlimited;