Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL loader problem

User444780-OCNov 29 2012 — edited Nov 29 2012
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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 27 2012
Added on Nov 29 2012
8 comments
991 views