Hi all,
I am extracting the data from teradata and loading into the oracle. the mapping is quite simple and it is one to one mapping but the data involved to be written into table in Oracle is huge and that's why i am using the Bulk load options. I have to pass single space into one of the field of the table in Oracle DB. I have set the env variable $APT_ORACLE_PRESERVE_BLANKS to true and also i have used the env variable $APT_STRING_PADCHAR. But all the records are getting rejected giving the error reason as "Cannot insert Null values into field Event(field name)". The field name is non nullable and i think it should accept single space while loading into the table.
When i tried with the upsert option, the records are getting inserted into the table.
Please provide your thoughts on this so that i can proceed with the suggestions provided by all of you.
load single space into the table's field in Oracle(load opt)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Wed Jun 01, 2005 7:10 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 48
- Joined: Wed Jun 01, 2005 7:10 am