Problem in Loading an Oracle Table using Load Option in Data
Posted: Mon Jun 25, 2007 5:45 am
Hi,
There is a particular problem which we have encountered.
When we try to load data from
Oracle Table A(Using Oracle Enterprise Stage) To Oracle Table B(Oracle Enterprise Stage)
Using the Write Method= Load, When the column names in both the tables are same then there is no error
say
Table A Table B
a number a number
b number b number
c number c number
but if say
Table A Table B
a number d number
b number e number
c number f number
Then there is an error generated. Is it because the control file is not getting generated in the required format.
What would be possible cause as since the job aborts we do not see any ctl file or log file that is generated in the /Scratch directory.
regards,
varsha
There is a particular problem which we have encountered.
When we try to load data from
Oracle Table A(Using Oracle Enterprise Stage) To Oracle Table B(Oracle Enterprise Stage)
Using the Write Method= Load, When the column names in both the tables are same then there is no error
say
Table A Table B
a number a number
b number b number
c number c number
but if say
Table A Table B
a number d number
b number e number
c number f number
Then there is an error generated. Is it because the control file is not getting generated in the required format.
What would be possible cause as since the job aborts we do not see any ctl file or log file that is generated in the /Scratch directory.
regards,
varsha