Dear Guru's
my job is like
seq stage ----- skeygenerator stage -- oraclestage
i have a single row in seq file and i am genetating a unique key for that record , this record is not inseting into oracle , it is throwing errors
Oracle_Enterprise_47,0: system(sqlldr username@orcl CONTROL=ora.2936956.472810.0.ctl LOG=ora.2936956.472810.0.log BAD=ora.2936956.472810.0.log.bad SILENT=header PARFILE=ora.2936956.472810.0.par ) failed. See log file for Oracle specfic message.
and
Oracle_Enterprise_47,0: Operator's runLocally() failed
and
Oracle_Enterprise_47,0: Operator terminated abnormally: runLocally did not return APT_StatusOk
what could be the reason , table dont have any constraints except not null even primary key is not defined for key column
thanks in adv for ur replies
bye
reddy
unable to insert into oracle
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
Re: unable to insert into oracle
kkreddy wrote:Dear Guru's
my job is like
seq stage ----- skeygenerator stage -- oraclestage
i have a single row in seq file and i am genetating a unique key for that record , this record is not inseting into oracle , it is throwing errors
Oracle_Enterprise_47,0: system(sqlldr username@orcl CONTROL=ora.2936956.472810.0.ctl LOG=ora.2936956.472810.0.log BAD=ora.2936956.472810.0.log.bad SILENT=header PARFILE=ora.2936956.472810.0.par ) failed. See log file for Oracle specfic message.
and
Oracle_Enterprise_47,0: Operator's runLocally() failed
and
Oracle_Enterprise_47,0: Operator terminated abnormally: runLocally did not return APT_StatusOk
what could be the reason , table dont have any constraints except not null even primary key is not defined for key column
thanks in adv for ur replies
bye
reddy
Did you check what you have in "ora.2936956.472810.0.log"
Re: solution
could you please explain how did you got the answer !
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: solution
DataStage will not load the data using sql loader unless you tell it how to work with your indexes. the only time that you cannot have an index option is when there are no indexes on the table. the original log should have said something to the effect of no index option chosen but indexes exist on the table.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com