Conversion Error - Loading from Sequential file to Oracle
Posted: Wed Apr 15, 2009 1:24 pm
Hi
I have data in a sequential file, and there are some date fields which are NULL. So i used the APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL to handle null while creating the Seq file, but now when im using this to load the table i get the following warning message. Im not sure why i get this message (i believe since i used the new env variable im getting this )
warning message:
Transformer_2,0: Conversion error calling conversion routine timestamp_from_string data may have been lost
can somebody help me.
I have data in a sequential file, and there are some date fields which are NULL. So i used the APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL to handle null while creating the Seq file, but now when im using this to load the table i get the following warning message. Im not sure why i get this message (i believe since i used the new env variable im getting this )
warning message:
Transformer_2,0: Conversion error calling conversion routine timestamp_from_string data may have been lost
can somebody help me.