/* Formatted on 2008/06/13 12:33 (Formatter Plus v4.8.8) */
CREATE TABLE load_tablec (branch VARCHAR2(50),country VARCHAR2(50),
current_support_user_id VARCHAR2(50),
current_support_user_name VARCHAR2(50),
customer_group VARCHAR2(50),department VARCHAR2(50),effort_minutes   varchar2(50),
LOCATION  VARCHAR2(50),
priority VARCHAR2(50),
 problem_category VARCHAR2(50),
  problem_description CLOB,
  problem_item VARCHAR2(400),
  problem_summary    VARCHAR2(400),
  relog_date DATE,
  ROLE VARCHAR2(50),
  severity    VARCHAR2(50),
  solution CLOB,
  solved_date DATE,    state VARCHAR2(50)    ,
  status    VARCHAR2(50),
  ticket_logged_by_user_id VARCHAR2(50),
   ticket_logged_by_user_name VARCHAR2(50),
   ticket_logged_datetime DATE,
      ticket_no INTEGER,
       wonswon INTEGER,
       within_sla_response INTEGER,
        out_of_sla_response INTEGER,
        within_sla_resolve INTEGER,
        outof_sla_resolve INTEGER)
        ORGANIZATION external
   (
     TYPE oracle_loader
     DEFAULT DIRECTORY EXT_DIR
     ACCESS PARAMETERS
     (
       RECORDS DELIMITED BY NEWLINE CHARACTERSET WE8ISO8859P9
        BADFILE 'EXT_DIR':'emp.bad' 
              LOGFILE 'EXT_DIR':'emp.log' 
       READSIZE 1048576 
       skip 1
       FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LRTRIM
       MISSING FIELD VALUES ARE NULL
       REJECT ROWS WITH ALL NULL FIELDS 
(branch CHAR(50),
country varchar(50),
current_support_user_id varchar(50),
current_support_user_name varchar(50),
customer_group varchar(50),
department varchar(50),
effort_minutes   varchar(50),
LOCATION  varchar(50),
priority varchar(50),
problem_category varchar(50),
problem_description varchar2(4000),
problem_item varchar(50),
problem_summary    varchar(50),
relog_date  DATE(20) 'DD-MON-YYYY HH24:MI:SS',
ROLE varchar(50),
severity    varchar(50),
solution varchar2(4000),
solved_date  DATE(20) 'DD-MON-YYYY HH24:MI:SS',   
state varchar(50)    ,
status    varchar(50),
ticket_logged_by_user_id varchar(50),
ticket_logged_by_user_name varchar(50),
ticket_logged_datetime DATE(20) 'DD-MON-YYYY HH24:MI:SS',
ticket_no INTEGER,
wonswon INTEGER,
within_sla_response INTEGER,
out_of_sla_response INTEGER,
within_sla_resolve INTEGER,
outof_sla_resolve INTEGER)
)
location
     (
       'reportc.csv'
     )
   )REJECT LIMIT UNLIMITED

SQL> l
  1  CREATE TABLE load_tablec (branch VARCHAR2(50),country VARCHAR2(50),
  2  current_support_user_id VARCHAR2(50),
  3  current_support_user_name VARCHAR2(50),
  4  customer_group VARCHAR2(50),department VARCHAR2(50),effort_minutes   varchar2(50),
  5  LOCATION  VARCHAR2(50),
  6  priority VARCHAR2(50),
  7   problem_category VARCHAR2(50),
  8    problem_description CLOB,
  9    problem_item VARCHAR2(400),
 10    problem_summary    VARCHAR2(400),
 11    relog_date DATE,
 12    ROLE VARCHAR2(50),
 13    severity    VARCHAR2(50),
 14    solution CLOB,
 15    solved_date DATE,    state VARCHAR2(50)    ,
 16    status    VARCHAR2(50),
 17    ticket_logged_by_user_id VARCHAR2(50),
 18     ticket_logged_by_user_name VARCHAR2(50),
 19     ticket_logged_datetime DATE,
 20        ticket_no INTEGER,
 21         wonswon INTEGER,
 22         within_sla_response INTEGER,
 23          out_of_sla_response INTEGER,
 24          within_sla_resolve INTEGER,
 25          outof_sla_resolve INTEGER)
 26          ORGANIZATION external
 27     (
 28       TYPE oracle_loader
 29       DEFAULT DIRECTORY WORK_DIR
 30       ACCESS PARAMETERS
 31       (
 32         RECORDS DELIMITED BY NEWLINE CHARACTERSET WE8ISO8859P9
 33          BADFILE 'EXT_DIR':'emp.bad'
 34                LOGFILE 'EXT_DIR':'emp.log'
 35         READSIZE 1048576
 36         skip 1
 37         FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LRTRIM
 38         MISSING FIELD VALUES ARE NULL
 39         REJECT ROWS WITH ALL NULL FIELDS
 40  (branch CHAR(50),
 41  country varchar(50),
 42  current_support_user_id varchar(50),
 43  current_support_user_name varchar(50),
 44  customer_group varchar(50),
 45  department varchar(50),
 46  effort_minutes   varchar(50),
 47  LOCATION  varchar(50),
 48  priority varchar(50),
 49  problem_category varchar(50),
 50  problem_description varchar2(4000),
 51  problem_item varchar(50),
 52  problem_summary    varchar(50),
 53  relog_date  DATE(20) 'DD-MON-YYYY HH24:MI:SS',
 54  ROLE varchar(50),
 55  severity    varchar(50),
 56  solution varchar2(4000),
 57  solved_date  DATE(20) 'DD-MON-YYYY HH24:MI:SS',
 58  state varchar(50)    ,
 59  status    varchar(50),
 60  ticket_logged_by_user_id varchar(50),
 61  ticket_logged_by_user_name varchar(50),
 62  ticket_logged_datetime DATE(20) 'DD-MON-YYYY HH24:MI:SS',
 63  ticket_no INTEGER,
 64  wonswon INTEGER,
 65  within_sla_response INTEGER,
 66  out_of_sla_response INTEGER,
 67  within_sla_resolve INTEGER,
 68  outof_sla_resolve INTEGER)
 69  )
 70  location
 71       (
 72         'reportc.csv'
 73       )
 74*    )REJECT LIMIT UNLIMITED
SQL> /

Table created.