ORAOCI8 Stage Error ORA-01438: value larger than specified.
Posted: Thu Jul 07, 2005 8:16 am
Hi Group ,
I am trying to load a large data to Oracle using OCI stage .
while loading i get this error :
MasterSnap..ORAOCI_LOAD.IDENT1: ORA-01438: value larger than specified precision allows for this column
While i know that this error is due to truncation of data ( that is i am trying to insert more data than this column can take )
How can i know which is the column needs to be changed ?
i can try to insert one row but the there are 300 columns so even trying to make a insert statement will take 2 hrs .
Also is there a way which i can re-direct that rejected row in another seq file.
Thanks in Advance
MasterSnap..ORAOCI_LOAD.IDENT1: ORA-01438: value larger than specified precision allows for this column
MasterSnap..ORAOCI_LOAD.IDENT1: The value of the row is: ID = 11177 CONTRACT = 111-2006096-999 STATE_CODE = 05 CNTY_CODE = 071 CITY_CODE = 2770 INSPECTOR = NULL INSPEC_DATE = NULL ASSET_VENDOR = NULL A_GUAR_RESID = NULL A_OP_LEASE_VALUE = NULL PROP_STATUS = 90 ASSET_MAKE = NULL AS_TRUE_VALUE = NULL FEATURE_RECORDS = NULL A_SIC_CODE = 8011 A_COLLATERAL_CD = NULL A_COLLATERAL_CONTRACTS = NULL A_DELIVERY_DATE = NULL EQUIP_CODE = 100200 EQUIP_COST = 401261 EQUIP_COST_PCT = NULL EQUIP_DESC = Chairs A_BRANCH = AA A_REGION = 001
I am trying to load a large data to Oracle using OCI stage .
while loading i get this error :
MasterSnap..ORAOCI_LOAD.IDENT1: ORA-01438: value larger than specified precision allows for this column
While i know that this error is due to truncation of data ( that is i am trying to insert more data than this column can take )
How can i know which is the column needs to be changed ?
i can try to insert one row but the there are 300 columns so even trying to make a insert statement will take 2 hrs .
Also is there a way which i can re-direct that rejected row in another seq file.
Thanks in Advance
MasterSnap..ORAOCI_LOAD.IDENT1: ORA-01438: value larger than specified precision allows for this column
MasterSnap..ORAOCI_LOAD.IDENT1: The value of the row is: ID = 11177 CONTRACT = 111-2006096-999 STATE_CODE = 05 CNTY_CODE = 071 CITY_CODE = 2770 INSPECTOR = NULL INSPEC_DATE = NULL ASSET_VENDOR = NULL A_GUAR_RESID = NULL A_OP_LEASE_VALUE = NULL PROP_STATUS = 90 ASSET_MAKE = NULL AS_TRUE_VALUE = NULL FEATURE_RECORDS = NULL A_SIC_CODE = 8011 A_COLLATERAL_CD = NULL A_COLLATERAL_CONTRACTS = NULL A_DELIVERY_DATE = NULL EQUIP_CODE = 100200 EQUIP_COST = 401261 EQUIP_COST_PCT = NULL EQUIP_DESC = Chairs A_BRANCH = AA A_REGION = 001