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