8 Replies Latest reply: Nov 29, 2012 6:45 PM by User444780-OC RSS

    SQL loader problem

    User444780-OC
      Hi,

      Oracle Version : 11.2.0.3
      OS version : Sun Solaris.

      Here is my CTL file.
      OPTIONS (SKIP=1)
      LOAD DATA
      INFILE '/dbmisc/NCOG/NcogFullOrderDataWestProd_20121127.csv'
      BADFILE '/dbmisc/NCOG/Step03-NCOG_SampleFile1.bad'
      DISCARDFILE '/dbmisc/NCOG/Step03-NCOG_SampleFile1.dsc'
      APPEND
      INTO TABLE ssp_flow.NCOG_Order_test
      FIELDS TERMINATED BY ',' optionally enclosed by '"' TRAILING NULLCOLS
      (MasterOrderNumberType_1  ,
      RESUBMIT_2 filler,
      ORDERS_3 filler,
      REPINFO_CODE_4 filler,
      DATA_SAL_NUM_5 filler,
      REP_INFO_8 filler,
      VOICE_ORDER_NUM_9 filler,
      CANCEL_VDER_10 filler,
      ORDER_TYPE_11 filler,
      SVC_REQ_ID_12 filler,
      DATA_DUE_DATE_13 DATE "MM/DD/YYYY",
      VOICE_DUE_DATE_14 filler,
      MEDIA_TYPE_15 filler,
      CLIENT_ID_16 ,
      VOICE_DAN_17 filler,
      LOB_18 ,
      CUST_CODE_19 filler,
      REP_ID_21 filler,
      SLS_PRSN_NUM_22 filler,
      PRIM_SLS_PRSN_23 filler,
      ORDER_CrnDATE_25 filler,
      SUP_ORDE_26 filler,
      SOFTSWITCH_27 filler,
      STACKED_RO_28 filler,
      IS_STACKED_29 filler,
      SERVER_NAME_30 filler,
      SSP_ORD_NUM_31 ,
      VIDEO_ORD_NUM_REPLY_32 ,
      SSP_STATUS_34 ,
      SSP_WARNINGS_ERRORS_35 CHAR(1000000) ,
      NOCV_WAR6 filler,
      VIDEO_DUE_DATE_37 DATE "MM/DD/YYYY",
      GREENFIELD_38 filler,
      VASIP_ORDER_39 filler,
      VASIP_HOLD_40 filler,
      SHADOW_Q_41 ,
      VOICE_PRODUCTS_42 filler CHAR(1000000),
      BTN_43 filler,
      CLIENT_APP_NAME_44 ,
      CLIENT_AVER_46 filler,
      TRACKINGBER_47 filler,
      SERVICEAdd_STATE_48 filler,
      DATA_PROCTS_49 filler,
      VIDEO_PRCTS_50 filler CHAR(1000000),
      STATE_51 ,
      MASTER_ORDER_TYPE_52 ,
      AGENCY_LION_53 filler,
      DATA_PACKAGES_54 filler,
      VIDEO_PACKAGES_55 filler,
      DATA_ORD_TP_57 ,
      VIDEO_ORD_TP_58 ,
      VIDEO_OREQ_59 filler,
      DATA_ORD_NUM_60 filler,
      ADDITIONNFO_61 filler,
      COG_WARNRS_62 filler,
      FIBER_64 filler,
      CANCEL_REON_65 filler,
      ADDRESS_ID_66 filler,
      SQE_ADDRESS_ID_67 filler,
      HOUSE_NUMBER_68 filler,
      STREET_NAME_69 filler,
      CITY_70 filler,
      PREV_FTTP_71 filler,
      DATA_JACKD_72 filler,
      VIDEO_JACD_73 filler,
      PENDING_O_74 filler,
      ISP_CHANGE_75 filler,
      OTHER_PRPE_76 filler,
      COMMENTS_77 filler CHAR(1000000),
      WINBACK_TYPE_78 filler,
      ORDER_ACTION_79 filler,
      NEW_EMAIL_INFO_80 filler,
      HEADER_STATUS_81 filler,
      VIDEO_HOLD_82 filler,
      HOLD_REASON_83 filler,
      BILLINGE_84 filler,
      DATA_DUON_85 filler,
      VIDEO_DN_86 filler,
      CC_VALIED_87 filler,
      NEW_BTN_88 filler,
      REP_RC_DESC_90 filler,
      EMPLOYEMBER_91 filler,
      BQT_RESPONSE_92 filler,
      INSTALLDE_93 filler,
      TERMINADE_94 filler,
      MOVEGROE_95 filler CHAR(1000000),
      CHANGEGE_96 filler,
      DISCGRP_NODE_97 filler,
      DATA_CANODE_98 filler,
      VIDEO_CODE_100 filler,
      UPDATEGODE_102 filler,
      PPV_NOD_103 filler,
      MASTER_OR_104 filler,
      VOICE_OR_TYPE_106 filler,
      FOLLOW_UP_SFX_107 filler,
      FIBER_ACODE_108 filler,
      SERVICE_ASS_109 filler,
      MON_110 filler,
      SERVICE_TN_111 filler,
      SUPP_DUE_112 filler,
      SUPP_CANR_113 filler,
      RECONFIGE_114 filler,
      FIBER_CODE_115 filler,
      RERELEASE_116 filler,
      PRIM_REASON_CD_117 filler,
      CAN_119 ,
      SUCCESS_IND_120 filler,
      ORDER_RENODE_121 filler,
      STATUS_R_NODE_122 filler,
      ORDER_ACDE_123 filler,
      PCAN_124 ,
      BQT_REQUEST_125 filler,
      VAC_SUS_SVC_126 filler CHAR(1000000),
      FIOS_VOICE_127 filler,
      ORDER_SIGNALS_128 filler CHAR(1000000),
      ONEBILL_TU_129 filler,
      APP_NAME_130 filler,
      APP_ID_131 filler,
      vzQESessionId_132 filler,
      repVZID_133 filler,
      transactNum_134 filler,
      miscinfo_135 filler,
      VZQE_BTN_136 filler,
      VZQE_BAN_137 filler,
      VZQE_CAN_138 filler,
      VZQE_PCAN_139 filler,
      TransactDate_140 filler,
      addressLine1_141 filler,
      addressLine2_142 filler,
      city_143 filler,
      addressLine1_145 filler,
      addressLine2_146 filler,
      city_147 filler,
      state_148 filler,
      REP_LOGIN_CODE_149 filler,
      PCAT_ID_150 filler CHAR(1000000),
      PACKAGE_ID_151 filler,
      VZQE_ACKREQ_ID_152 filler,
      VIDEO_END_USER_153 filler,
      OOF_IND_154 filler,
      APP_SERVER_TIME_STAMP_155  "to_timestamp_tz (:APP_SERVER_TIME_STAMP_155, 'MM/DD/YYYY hh24:mi:ss tzr')",
      CIRCUIT_ID_156 filler,
      LEC_BILLING_158 filler,
      CREDIT_STATUS_159 filler,
      IS_HOLD_ORDER_160 filler,
      ORDER_STATUS_CODE_161 ,
      CC_BILLING_162 filler,
      INVOICE_ING_163 filler,
      INVOICE_INT_164 filler,
      PAST_ORD_DATE_165 filler,
      SUBMITTED_166 filler,
      PRIMARY_S_ID_167 filler,
      isHFWS_171 filler,
      isAdditinalONT_172 filler,
      FIOS_VOICE_ORDER_TYPE_173 ,
      FIOS_VOICE_DUE_DATE_174 DATE "MM/DD/YYYY",
      FIOS_VOICE_ORDER_NUM_175 ,
      FTTP_Migtion_176 filler,
      VIDEO_DEANT_177 filler,
      DATA_DEPNT_178 filler,
      CREORT_VALTION_179 filler,
      IS_ICREDUT_180 filler,
      IS_VEPS_TIMEOUT_181 filler,
      ReferralAgencyID_182 filler,
      MkgCampPreeNo_183 filler,
      MkgCampPrnName_184 filler,
      MkgCampPrn_BTN_185 filler,
      MkgCampPrrDate_186 filler,
      MkgCampPrType_187 filler,
      MkgCampProion_188 filler,
      SERVICEID_189 filler,
      ACCOUNTID_190 filler,
      VOICE_DPTION_196 filler,
      MkgCampCID_197 filler,
      SuppVoiype_199 filler,
      BAN_200 ,
      TN_201 filler,
      isFVWinbOrder_204 filler,
      CONFIRMACODE_205 filler,
      IsDeposisent_206 filler,
      vzQeId_207 filler,
      StackedRumber_208 filler,
      workWithNumber_209 filler,
      SplitBillIntent_210 filler,
      MoveServedOrder_211 filler,
      changeGrOrder_212 filler,
      ToServicdOrder_213 filler,
      RemoveSedOrder_214 filler,
      BSGOrderType_215 filler,
      lineOfBuCode_216 filler,
      ZoneOfferIntent_217 filler,
      OtherOfferIntent_218 filler,
      IsMigrateOrder_219 filler,
      hoaMigrationType_220 filler,
      IsEligibversion_221 filler,
      IsCPEUpgrade_222 filler,
      isTermFeived_223 filler,
      responsiCode_224 filler,
      SipFlag_225 filler,
      LIFE_LINE_226 filler,
      ORDER_ROFFIX_227 filler,
      TREATMENFIER_228 filler,
      PREVIOUSVALUE_229 filler,
      ONTFunctalType_230 filler,
      FTTP_231 filler,
      IsVoiceMated_232 filler,
      que_233 filler,
      vacationype_234 filler,
      FiberSerag_235 filler,
      FiberSerlag_236 filler,
      FiosBVoig_237 filler,
      FiosVoicg_238 filler,
      BTNforBQT_239 filler,
      PromoIntfo_240 filler,
      mTNValidd_241 filler,
      OneBillElled_242 filler,
      ilecAccomber_243 filler,
      DataiCreckFlag_244 filler,
      iCreditCheckFlag_245 filler,
      VideoiCrckFlag_246 filler,
      VASIPService_247 filler,
      isClockRetain_248 filler,
      Data_isTstart_249 filler,
      isTOSAccndle_250 filler,
      isTOSRejected_251 filler,
      FirstBilssage_252 filler,
      ChangeFrom_253 filler,
      AppointmtCode_255 filler,
      Fiber_Reount_256 filler,
      Fiber_reumber_257 filler,
      Fiber_restory_258 filler,
      Fiber_demount_259 filler,
      Fiber_deNumber_260 filler,
      FIOS_refmount_261 filler,
      FIOS_refNumber_262 filler,
      FIOS_refistory_263 filler,
      FIOS_depAmount_264 filler,
      FIOS_depumber_265 filler,
      Video_remount_266 filler,
      Video_rember_267 filler,
      Video_retory_268 filler,
      Video_de_269 filler,
      Video_deumber_270 filler,
      Install_ount_271 filler,
      Install_ber_272 filler,
      Install_unt_273 filler,
      Install_mber_274 filler,
      Install_nt_275 filler,
      Install_er_276 filler,
      Video_isart_277 filler,
      ApptCode_278 filler,
      appointmor_279 filler,
      ApptInd_280 filler,
      appt_Ind_281 filler,
      Install_t_282 filler,
      Install_sit_283 filler,
      Install_it_284 filler,
      Video_Isit_285 filler,
      Fios_IsDit_286 filler,
      Fiber_Isosit_287 filler,
      FBETracknfo_288 filler,
      StopQBSESP_289 filler,
      isPartiar_290 filler,
      ribsMigr91 filler,
      termFeeW_292 filler,
      QBSEstimtal_293 filler,
      DROP_TYPE_295 filler,
      isFirstBill_296 filler,
      billCycle_297 filler,
      BillRounr_298 filler,
      BillingDate_299 filler,
      billingCber_300 filler,
      oBIntent_301 filler,
      oBStatus_302 filler,
      wirelessate_303 filler,
      ssnLastFts_304 filler,
      TAR_306 filler,
      taxDistrde_307 filler,
      aCO_308 filler,
      coClliCode_309 filler,
      isAddres310 filler,
      orderInf11 filler,
      isTaxExempt_312 filler,
      taxExempt_313 filler,
      MkgCampPd_314 filler,
      TechnDisTime_315 filler,
      OrderInfon_316 filler,
      OrderInfle_317 filler,
      OrderInfme_318 filler,
      OrderInfe_319 filler,
      OrderInf_320 filler,
      OrderInfe_321 filler,
      Products22 filler,
      Producode_323 filler,
      Producse_324 filler,
      ToProdime_325 filler,
      ToProdode_326 filler,
      ToProdde_327 filler,
      OrderIuffix_328 filler,
      BRBNDetails_329 filler CHAR(1000000),
      OrderIass_345 filler,
      OrderIOtion_347 filler,
      CofeeD_349 filler,
      VZOTDer_351 filler,
      Releasn_355 filler,
      Simplite_357 filler,
      Voicet_358 filler,
      Voice2_359 filler,
      Voicen_360 filler,
      TechDie_361 filler,
      TechDie_362 filler,
      TechDi3 filler,
      TechDicat_364 filler,
      Techni65 filler,
      Techni366 filler,
      Techni67 filler,
      OrderB68 filler,
      Cliente_369 filler,
      COMOHo1 filler,
      HoldOr2 filler,
      VoiceP filler,
      IsInactONT_376 filler,
      RecurriCH_377 filler,
      UnUsedCde_378 filler,
      Arrivalme_379 filler,
      Arrival_380 filler,
      From_Date_381 filler,
      To_Date_382 filler,
      Cust_Dee_383 filler,
      TranspoCode_384 filler,
      Data_Node_385 filler,
      CancelGode_386 filler,
      financi filler,
      tosConfi8 filler,
      IsFiosVon_389 filler,
      FiosVoic390 filler,
      IsBoc_391 filler,
      SpecialHde_392 filler,
      BillFormat_393 filler,
      Disconne_397 filler,
      PrimaryR398 filler,
      Secondar99 filler,
      AccountId_400 ,
      LecVoice01 filler,
      Network_402 filler,
      FiosVoic_403 filler,
      FVMigrat filler,
      Discne_405 filler,
      DryLLr_406 filler,
      Supp07 filler,
      MixedMedia_408 filler,
      ManualTn_409 filler,
      ManualTnType_410 filler,
      ManualTnStatus_411 filler,
      TnAssigned_412 filler,
      OfficeCode_413 filler,
      RCWorkStation_414 filler,
      PLBNtion_424 filler,
      ClieeName_427 filler,
      noTruired_428 filler,
      noTrason_429 filler,
      Falleason_430 filler,
      NCOG_GUID_431 filler,
      FiosteOption_432 filler,
      DebirdBilling_433 filler,
      NewAccountInd_434 filler,
      dryL_435 filler,
      dryLor_436 filler,
      Custest_438 filler,
      BANKBR_439 filler,
      BANK_440 filler,
      DEPOD_441 filler,
      Trane_442 filler,
      depo_443 filler,
      RDD_ate_444 filler,
      Confber_445 filler,
      Paymated_446 filler,
      VRUCode_447 filler,
      Seco49 filler,
      CancnText_450 filler,
      Cancts_451 filler CHAR(1000000),
      Tran454 filler,
      ACCOP_455 filler,
      ORDE_FTTP_456 filler,
      IsLet_464 filler,
      Emaie_465 filler,
      OthrData_467 filler,
      Vac_ode_468 filler,
      Vac_reDate_469 filler,
      Vac_PcatID_470 filler,
      Vac_vate_471 filler,
      Vac_t_Add_472 filler,
      Vac_lete_473 filler,
      Cust74 filler,
      OrderIntent_475 filler,
      Splils_476 filler,
      submitOST_477 filler,
      RPM_Delete_478 filler,
      AccoN_479 filler,
      BillR_TN_480 filler,
      Autoype_482 filler,
      BoxNumber_483 filler,
      Rout_484 filler,
      Assir_485 filler,
      Comm_486 filler,
      Housx_487 filler,
      Stre88 filler,
      Stre489 filler,
      Unitype_490 filler,
      Unitalue_491 filler,
      ElevtionType_492 filler,
      Elevlue_493 filler,
      Strupe_494 filler,
      Stru495 filler,
      Terr_496 filler,
      StretID_497 filler,
      ZipCode_498 filler,
      Thorre_499 filler,
      KitVersion_503 filler,
      SplisonCode_504 filler,
      CPESall_505 filler,
      Orde10 filler,
      DueDnTime_511 filler,
      EONT_512 filler,
      OmtType_513 filler CHAR(1000000),
      DslIdicator_514 filler,
      RefelesId_515 filler,
      VzWService_516 filler,
      dtvI7 filler,
      Voicype_518 filler,
      IsONled_519 filler,
      IsInNT_520 filler,
      IsGher_521 filler,
      IsAdalONT_522 filler,
      Selfsult_523 filler,
      CancelChange_524 filler,
      isXPsed_525 filler,
      WireCenter_532 filler,
      SSP_rNumber_533 filler,
      DTV_rderNumber_534 filler,
      SSP_ntNumber_535 filler,
      DTV_tNumber_536 filler,
      SSP_TVStatus_537 filler,
      DTV_dTVStatus_538 filler,
      IsRealTimeSave_539 filler,
      RealferValue_540 filler,
      ThunderInd_542 filler,
      Thunype_543 filler,
      Thunte_544 filler,
      Thunption_545 filler,
      Chan_546 filler,
      ThunstsInd_547 filler,
      TIME_STAMP_88888 filler,
      GUID_99999 filler,
      Insert_Date  "to_timestamp(sysdate)",
      IS_Processed  constant 'N')
      {code}
      
      
      Thansk & Regards,
      Venkata Poorna Prasad.S                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
        • 1. Re: SQL loader problem
          User444780-OC
          here is the output file of log .
          value used for ROWS parameter changed from 64 to 1
          
          Record 1276: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 1285: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 1354: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 1374: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column SSP_WARNINGS_ERRORS_35.
          second enclosure string not present
          Record 1375: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column DATA_DUE_DATE_13.
          ORA-01843: not a valid month
          
          Record 1908: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 2354: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 2360: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column CANCTS_451.
          second enclosure string not present
          Record 2475: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 2560: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column COMMENTS_77.
          second enclosure string not present
          Record 2561: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column DATA_DUE_DATE_13.
          ORA-01858: a non-numeric character was found where a numeric was expected
          
          Record 4911: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 4987: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column CANCTS_451.
          second enclosure string not present
          Record 5218: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 6179: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 6198: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column CANCTS_451.
          second enclosure string not present
          Record 6243: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column COMMENTS_77.
          second enclosure string not present
          Record 6251: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column MASTERORDERNUMBERTYPE_1.
          no terminator found after TERMINATED and ENCLOSED field
          Record 6548: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          Record 6994: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column CANCTS_451.
          second enclosure string not present
          
          Record 7636: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column NOCV_WAR6.
          second enclosure string not present
          Record 7637: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column MASTERORDERNUMBERTYPE_1.
          no terminator found after TERMINATED and ENCLOSED field
          Record 7704: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column APP_SERVER_TIME_STAMP_155.
          ORA-01882: timezone region not found
          
          \MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
          
          Table SSP_FLOW.NCOG_ORDER_TEST:
            8110 Rows successfully loaded.
            51 Rows not loaded due to data errors.
            0 Rows not loaded because all WHEN clauses were failed.
            0 Rows not loaded because all fields were null.
          
          
          Space allocated for bind array:                1006198 bytes(1 rows)
          Read   buffer bytes: 1048576
          
          Total logical records skipped:          1
          Total logical records read:          8161
          Total logical records rejected:        51
          Total logical records discarded:        0
          
          Run began on Thu Nov 29 13:51:36 2012
          Run ended on Thu Nov 29 13:52:40 2012
          
          Elapsed time was:     00:01:04.27
          CPU time was:         00:00:19.12
          Please help me how to solve my problem.

          Thansk & Regards,
          Venkata Poorna Prasad.S
          • 2. Re: SQL loader problem
            User444780-OC
            Here is the bad file output.
            "0C0483184","","100","","VPS","","","","D","","01/07/2013","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW04","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfhdp01","3540579566674652-1354058846888","","","","CA","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0C0483184","","","","","0C0483184","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 18:27:26 EDT","","","","","","","","","","","","","","","","ZDCOG311688401","","","","","","","","","","","","","","913129963","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","913129917","","F","Y","","","","","","","","","","","","","166.68.48.96","","","","0124909e-af0e-48e6-9ddf-b23407572ac4","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 3:27:27 PM","0124909e-af0e-48e6-9ddf-b23407572ac4"
            "0F6598133","","100","","VPS","","","","D","","12/03/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW03","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfrdp03","63800031-1354021918613","","","","FL","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0F6598133","","","","","0F6598133","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 08:11:58 EDT","","","","","","","","","","","","","","","","ZDCOG311580134","","","","","","","","","","","","","","851406768","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","851406728","","F","Y","","","","","","","","","","","","","166.68.42.23","","","","01ed86cd-e901-4478-a3bb-827e56f30f66","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 5:11:58 AM","01ed86cd-e901-4478-a3bb-827e56f30f66"
            "0C0461027","","100","","VPS","","","","D","","11/28/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW04","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfrdp03","V9-118312-1354021386606","","","","CA","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0C0461027","","","","","0C0461027","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 08:03:06 EDT","","","","","","","","","","","","","","","","ZDCOG311579348","","","","","","","","","","","","","","1019625891","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","1019625862","","F","Y","","","","","","","","","","","","","166.68.42.23","","","","05cb166d-089a-4a97-b694-796306961d0d","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 5:03:06 AM","05cb166d-089a-4a97-b694-796306961d0d"
            "0C0482672","","","","","","","","Cancel","","01/07/2013","","FDV","XRM","","C","","","","","","Yes","No","","","NOV_NWF-SACP1LRCDGW03","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfhdp02","3540579566674652-1354058805040","","","","CA","D","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0C0482672","","","","","0C0482672","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 18:26:45 EDT","","","","","","","","","","","","","","","","ZDCOG311686648-01","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","","","","","F","Y","","","","","","","","","","","","","166.68.48.101","","","","0d1af519-021a-4b04-bdd3-3dbde4088bf3","","","","","","","","","","","","","","","","","Clec Request","Clec Request","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-CA-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 3:26:45 PM","0d1af519-021a-4b04-bdd3-3dbde4088bf3"
            "0F6605249","","100","","VPS","","","","D","","12/11/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW04","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfhdp01","TP90000012004255-1354047392977","","","","FL","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0F6605249","","","","","0F6605249","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 15:16:32 EDT","","","","","","","","","","","","","","","","ZDCOG311655360","","","","","","","","","","","","","","1132277428","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","1132277386","","F","Y","","","","","","","","","","","","","166.68.48.96","","","","0fdeeaf1-83b2-42cc-9e4b-7cb2a55317d4","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 12:16:33 PM","0fdeeaf1-83b2-42cc-9e4b-7cb2a55317d4"
            "0F6602587","","100","","VPS","","","","D","","11/30/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW03","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfrdp04","TP90000012012678-1354038306357","","","","FL","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0F6602587","","","","","0F6602587","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 12:45:06 EDT","","","","","","","","","","","","","","","","ZDCOG311627577","","","","","","","","","","","","","","1164009888","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","414983232","","F","Y","","","","","","","","","","","","","166.68.42.28","","","","0ff6d3e0-e667-431f-8719-be496f092a21","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 9:45:07 AM","0ff6d3e0-e667-431f-8719-be496f092a21"
            "0F6603850","","100","","VPS","","","","D","","12/03/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW03","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfhdp03","TP90000012014482-1354042790887","","","","FL","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0F6603850","","","","","0F6603850","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 13:59:50 EDT","","","","","","","","","","","","","","","","ZDCOG311641614","","","","","","","","","","","","","","880882198","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","880882143","","F","Y","","","","","","","","","","","","","166.68.48.106","","","","10ca6785-41b5-4692-aedd-ab1dcd41727e","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 10:59:51 AM","10ca6785-41b5-4692-aedd-ab1dcd41727e"
            "0C0487285","","","z408428","z408428","","0C0487285","","C","","","","VOICE","EIQ","","C","","","z408428","z408428","","No","No","","N","NOV_NWF-SACP1LRCDGW04","","","Red","<SSP>SSP_OrderingService: Error while executing Adapter of SSP Web Service : 1354066864816_SCPA7_bs_srv_03: :General Exception caught in getPackageProducts(): ORA-00018: maximum number of sessions exceeded
            </SSP>","Success","","","","","Yes","82546;38882","6619497130","COFEEANYWHERE","138.83.26.250","tpa-002fe8e7-7f42-4546-b1ce-7066e8b76e71","","H7574 1;H7573 1","H7574 1;H7573 1","CA","C","NL69","H7617 1","H7617 1","C","","","","","","","","3007254","","45907","YORK PL","LANCASTER","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","0C0487285","C","","","R","0C0487285","","","","","","","","A064059414","","","","","A064059414","","","","BAN:0050505401211|ProfileCAN:A064059414|CAN:1167109600|ProfileBillingTN:6619497130|VideoCAN:1114729028|SSPAccountId:261021439|OrderBillingTN:6619497130|DSLServiceID:261021440|LATA:730|AddressID:3007254|WireCenter:10769|DataPending:N|FDVPending:N|VideoPending:N|VoicePending:N|SSPProfileBillCycle:28|BillPeriodInd:28|BlngAndSrvcAddrSame:Y|FIOSMaxOrders:N||DeletedProfileBundleProdKeywords:|DeletedProfileBundleBundleToSAccepted:|DeletedProfileBundleTerm:|DeletedProfileBundleBundleTrackerCode:OrderBundleLeadOfferIndicator:|OrderBundleETFIndicator:|OrderBundleisClockRetain:|OrderBundleProdKeywords:Double:PSTNLEC:HSI:3M:LEC:FRDM|OrderBundleBundleToSAccepted:|OrderBundleTerm:1|OrderBundleBundleTrackerCode:24701|OrderBundleIsInactiveONT:N|ProfileInfoPCAN:A064059414|ProfileSSPAccountID:261021439|EmpBundleSelected:False|UpStreamSpeed:0|DownStream","","COFEEANYWHERE","EIQ","990071607","Z408428","","","6619497130","0050505401211","1167109600","A064059414","11/27/2012","","","","45907 YORK PL","","LANCASTER","CA","z408428","H7574;H7573","H7617","","","","11/27/2012 20:40:57 EST","","","","N","Release","","","","","","z408428","","","","","","","","","","","","","","","","","","Has Data","","","","","","0050505401211","6619497130","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","6619497130","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","W","","W","W","","","","","","","VOICE_ONLY_ORDER","","","","","","","","","28","","","","","12/12/9999","","","","","","","","","","","","","","","","","","","","","","","","","OrderStartTime: 11/27/2012 08:34:11 EST | DueDateSelectionTime:  | SQESelfInstallTestResult:  | ARSelfInstallTestResult: FAILURE | DDIsSelfInstallOrder:  | DataIsSelfInstallable:  | VideoIsSelfInstallable:  | FDVIsSelfInstallable:  |","","","","","","Fios:N;TH:N;HSI:Y;DTV:N;DDReq:110;Split:N;Over::00:00:00:00;ONT:;CofS: CofM:;H:N;;;DI:;WI:;SI:;;V-SI:;D-SI:;;;SI Offers: N;","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","0100","","","","TRUE","","","","","","261021439","Y","C","","","","","","","","","","","01","NL69 ST","","TPAP1LREIQW22V","","","","11127273-855b-4529-919c-81f45dc701dd","","","","","","","","","","","","","","","","","","","","","Y","C","","PLB_NON-REGISTERED","N","","","","","","","C+C+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","Has Data","","","","","","","","","","","","","","","","","","","","93534","","3.11.115.3388","","","","11/27/2012 08:34:11 EST","","OrderStartTime: 11/27/2012 08:34:11 EST | DueDateSelectionTime:  | SQESelfInstallTestResult:  | ARSelfInstallTestResult: FAILURE | DDIsSelfInstallOrder:  | DataIsSelfInstallable:  | VideoIsSelfInstallable:  | FDVIsSelfInstallable:  |","","Y","","","","C","","","","","NO","","","","","","","769","","","","","","","","","28285","","","","","","","11/27/2012 5:40:57 PM","11127273-855b-4529-919c-81f45dc701dd"
            "0C0476879","","100","","VPS","","","","D","","12/03/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW04","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfhdp02","3540484826501882-1354048576382","","","","CA","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0C0476879","","","","","0C0476879","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 15:36:16 EDT","","","","","","","","","","","","","","","","ZDCOG311658716","","","","","","","","","","","","","","989485965","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","989485935","","F","Y","","","","","","","","","","","","","166.68.48.101","","","","1508b958-4796-4fde-a2b0-8b6617d76e3a","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 12:36:16 PM","1508b958-4796-4fde-a2b0-8b6617d76e3a"
            "0C0478624","","100","","VPS","","","","D","","11/30/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW03","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfhdp02","3540512608362702-1354051336625","","","","CA","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0C0478624","","","","","0C0478624","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 16:22:16 EDT","","","","","","","","","","","","","","","","ZDCOG311667929","","","","","","","","","","","","","","849346628","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","849346570","","F","Y","","","","","","","","","","","","","166.68.48.101","","","","153b13f2-47ed-4d99-84c6-5676674eb798","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 1:22:16 PM","153b13f2-47ed-4d99-84c6-5676674eb798"
            "0F6598271","","100","","VPS","","","","D","","12/01/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW03","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfrdp04","TP90000012013485-1354022896763","","","","FL","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0F6598271","","","","","0F6598271","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 08:28:16 EDT","","","","","","","","","","","","","","","","ZDCOG311581747","","","","","","","","","","","","","","1017329152","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","1017329106","","F","Y","","","","","","","","","","","","","166.68.42.28","","","","1799a6ae-0fa3-40f9-8d2c-70728c6ffdd3","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 5:28:17 AM","1799a6ae-0fa3-40f9-8d2c-70728c6ffdd3"
            "0F6604421","","100","","VPS","","","","D","","12/01/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW04","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfhdp03","TP90000012009588-1354044675994","","","","FL","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0F6604421","","","","","0F6604421","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 14:31:15 EDT","","","","","","","","","","","","","","","","ZDCOG311646844","","","","","","","","","","","","","","1156496655","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","225161457","","F","Y","","","","","","","","","","","","","166.68.48.106","","","","1cdbd53c-85ca-45d2-91fe-476d3ef5411e","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 11:31:16 AM","1cdbd53c-85ca-45d2-91fe-476d3ef5411e"
            "0C0440879","","","V108998","V108998","","","","Cancel","","","","VOICE","EIQ","","C","","V108998","V108998","Mark Brajevich","","Yes","No","","","NOV_NWF-SACP1LRCDGW03","","","","","Success","","","","","","","","COFEEANYWHERE","138.83.18.228","sac-613d4794-1551-4e53-9e56-033bf7f18c23","","","","CA","C","6650","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","0C0440879","","","","","0C0440879","","","","","","","","A061216644","","","","","","","","","BAN:|ProfileCAN:A061216644|CAN:1178860876|ProfileBillingTN:7148467423|VideoCAN:|SSPAccountId:|OrderBillingTN:7148467423|LATA:730|AddressID:348395|WireCenter:10880|DataPending:N|FDVPending:N|VideoPending:N|VoicePending:Y|SSPProfileBillCycle:1|BillPeriodInd:07|BlngAndSrvcAddrSame:Y|FIOSMaxOrders:N||DeletedProfileBundleProdKeywords:|DeletedProfileBundleBundleToSAccepted:|DeletedProfileBundleTerm:|DeletedProfileBundleBundleTrackerCode:ProfileInfoPCAN:A061216644||UpStreamSpeed:0|DownStreamSpeed:0|","","","","","","","","","","","","","","","","","","","","v108998","","","","","","11/27/2012 13:15:27 EST","","","","","","","","","","","V108998","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","","","","Y","C","","","","","","","","","","","","6650 ST","","144.28.174.61","","","","1cec6d3e-01e9-4cbf-bd8d-097bc1e98347","","","","","","","","","","","","","","","","","Wants to Keep Copper Too","**09:01A 11/27 60470 **COMPLETE
            "0F6603535","","100","","VPS","","","","D","","12/03/2012","","FDV","XRM","","C","","","VPS","","","No","No","","","NOV_NWF-SACP1LRCDGW04","","","Green",":Request Accepted","","","","","","","","","XRM","wlsfhdp04","6006012332503765-1354041603485","","","","FL","D","","","","D","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","0F6603535","","","","","0F6603535","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","SYSTEM","","","","","","11/27/2012 13:40:03 EDT","","","","","","","","","","","","","","","","ZDCOG311638404","","","","","","","","","","","","","","1189787788","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","C","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Has Data","","","","","","TRUE","","","","Customer Service Change","Port Out to CLEC","1189787783","","F","Y","","","","","","","","","","","","","166.68.48.126","","","","1e5d55ca-acad-4d1a-b33f-fb61e2b10db5","","","","","","","","","","","","","","","","","","","","","","F","","","","","","","","","","D+F+LV-X-X-X+DSL-X-X-X+FV-X-X-X+DA-X-X-X+VA-X-X-X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","11/27/2012 10:40:03 AM","1e5d55ca-acad-4d1a-b33f-fb61e2b10db5"
            {code}
            
            
            Thanks & Regards,
            Venkata Poorna Prasad.S                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
            • 3. Re: SQL loader problem
              Srini Chavali-Oracle
              Pl do not post duplicates - SQL loader problem - continue the discussion in your original thread

              HTH
              Srini
              • 4. Re: SQL loader problem
                jgarry
                $ oerr ora 1882
                01882, 00000, "timezone region %s not found"
                // *Cause: The specified region name was not found.
                // *Action: Please contact Oracle Customer Support.

                Also, see MOS Time Zone IDs for 7 Time Zones Changed in Time Zone Files Version 3 and Higher, Possible ORA-1882 After Upgrade [ID 414590.1] but probably not, so contact support and search your error on MOS.
                • 5. Re: SQL loader problem
                  User444780-OC
                  Hi Srini,

                  I would like to continue with this thread .

                  Can you please help me how to resolve the errors.

                  Thanks & Regards,
                  Venkata Poorna Prasad.S
                  • 6. Re: SQL loader problem
                    Srini Chavali-Oracle
                    Pl see Joel's response above

                    Srini
                    • 7. Re: SQL loader problem
                      User444780-OC
                      Hi Srini,

                      We got the csv file from mssql server 2010.


                      How to solve these below errors. I searched in google but not able to find the solutin .
                      Record 4987: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column CANCTS_451.
                      second enclosure string not present
                      Record 6198: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column CANCTS_451.
                      second enclosure string not present
                      Record 6251: Rejected - Error on table SSP_FLOW.NCOG_ORDER_TEST, column MASTERORDERNUMBERTYPE_1.
                      no terminator found after TERMINATED and ENCLOSED field
                      Thanks & Regards,
                      Venkata Poorna Prasad.S
                      • 8. Re: SQL loader problem
                        User444780-OC
                        Hi Srini,

                        My date problem solved by putting like this in ctl file
                        APP_SERVER_TIME_STAMP_155   " to_timestamp_tz(:APP_SERVER_TIME_STAMP_155, 'MM/DD/YYYY HH24.MI.SS tzd')",
                        Here i am having one more problem i.e.

                        There is on column INSERT_DATE which is having timestamp data type and defaul as sysdate.

                        but it is showing same time as below when i truncate and insert again .
                        SQL> select distinct(INSERT_DATE) from ssp_flow.NCOG_Order_test;
                        
                        INSERT_DATE
                        ---------------------------------------------------------------------------
                        29-NOV-12 12.00.00.000000 AM
                        
                        SQL> truncate table ssp_flow.NCOG_Order_test ;
                        
                        Table truncated.
                        
                        SQL> alter table ssp_flow.NCOG_Order_test modify insert_date timestamp(6) default sysdate;
                        
                        Table altered.
                        
                        SQL> select distinct(INSERT_DATE) from ssp_flow.NCOG_Order_test where rownum < 3;
                        
                        INSERT_DATE
                        ---------------------------------------------------------------------------
                        29-NOV-12 12.00.00.000000 AM
                        in ctl file i define like this
                        Insert_Date  "to_timestamp(sysdate)",
                        Cna u please help me how to get the housr,minuts values here .
                        Thansk & Regards,
                        Venkata Poorna Prasad.S