Hi,
I am writing to an Oracle table, if I use the option "Upsert" the job completes fine and loads around 200K records.
If I use Load with Truncate option, it gives me this error
"main_program: Fatal Error: Invalid character encountered in table TempTable"
Any one with ideas,
Thanks,
Fatal Error Invalid character encountered in table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
-
- Participant
- Posts: 31
- Joined: Mon Dec 01, 2003 6:24 am
- Location: London
If you are using the LOAD option then Datastage will be using SQL Loader to insert records into the DB.
If you check your logs then you should find reference to a SQL Loader Log file called something like ora.23480.494029.0.log
This file will be located on the resource scratchdisk defined in your Configuration File and might provide you with some more info to help solve your problem.
If you check your logs then you should find reference to a SQL Loader Log file called something like ora.23480.494029.0.log
This file will be located on the resource scratchdisk defined in your Configuration File and might provide you with some more info to help solve your problem.