Hello Friends
We are facing a sql loader error in DataStage jobs
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
These jobs are doing a truncate & load. Also a pattern observed is this is happening with the jobs which are inserting into a different schema (other than the source table schema)
We also checked the database version and the client version. They are 11.1.0.7.0 & 11.2.0 respectively.
Our DBA's are suspecting that this is happening due to client version higher than database version. But the same setup in development env is running fine.
Also this problem is observed for a particular moment. After restarting,the job runs fine. This problem is occuring in different jobs everytime
Please help
Thanks
SQL*Loader-951: Error calling once/load initialization
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 72
- Joined: Wed Dec 12, 2007 2:29 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
How are you calling that table in other schema, is it through synonym or by prefixing the schema name or any other way?
server and clients with Minor version difference are generally compatible but may create problems once in a while. But you need to first find out the root cause. Did the DBA tried enabling trace on this database?
server and clients with Minor version difference are generally compatible but may create problems once in a while. But you need to first find out the root cause. Did the DBA tried enabling trace on this database?
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.