11 Replies Latest reply: Feb 14, 2013 7:49 AM by Chandan.Rattan RSS

    External Tables (Oracle Loader)

    Chandan.Rattan
      Hi While creating the external Table, i am getting error.
      ORA-12899: value too large for column PRC_REC_TYPE (actual: 2, maximum: 1)

      But while checking the CSV file, i found that prc_rec_type is having one 1 length value.

      -- Create table
      create table ET_PGIT_POL_RISK_COVER
      (
      prc_pol_no VARCHAR2(60),
      prc_end_no_idx VARCHAR2(22),
      prc_sec_code VARCHAR2(12),
      prc_risk_id VARCHAR2(12),
      prc_smi_code VARCHAR2(12),
      prc_code VARCHAR2(12),
      prc_desc VARCHAR2(2000),
      prc_rate VARCHAR2(22),
      prc_rate_per VARCHAR2(22),
      prc_cvr_type VARCHAR2(1),
      prc_add_si_yn VARCHAR2(1),
      prc_si_curr_code VARCHAR2(12),
      prc_prem_curr_code VARCHAR2(12),
      prc_si_fc VARCHAR2(22),
      prc_si_lc_1 VARCHAR2(22),
      prc_si_lc_2 VARCHAR2(22),
      prc_si_lc_3 VARCHAR2(22),
      prc_prem_fc VARCHAR2(22),
      prc_prem_lc_1 VARCHAR2(22),
      prc_prem_lc_2 VARCHAR2(22),
      prc_prem_lc_3 VARCHAR2(22),
      prc_eff_fm_dt VARCHAR2(30),
      prc_eff_to_dt VARCHAR2(30),
      prc_brok_comm_appl_yn VARCHAR2(1),
      prc_no_clm_bonus_appl_yn VARCHAR2(1),
      prc_prof_comm_appl_yn VARCHAR2(1),
      prc_cr_uid VARCHAR2(12),
      prc_rate_eft VARCHAR2(12),
      prc_terrorism_yn VARCHAR2(1),
      prc_lvl VARCHAR2(12),
      prc_tot_si_fc VARCHAR2(22),
      prc_first_loss_perc VARCHAR2(22),
      prc_flxi_risk_cover_desc VARCHAR2(2000),
      prc_rec_type VARCHAR2(1)
      )
      organization external
      (
      type ORACLE_LOADER
      default directory MMI_DATA_MIG
      access parameters
      (
      RECORDS DELIMITED BY NEWLINE BADFILE 'ET_PGIT_POL_RISK_COVER.Bad' LOGFILE 'ET_PGIT_POL_RISK_COVER.Log' FIELDS TERMINATED BY ',' MISSING FIELD VALUES ARE NULL REJECT ROWS WITH ALL NULL FIELDS
      )
      location (MMI_DATA_MIG:'COVER_1.csv')
      )
      reject limit UNLIMITED;

      Not able to upload the file here.