I am reading from oracle tables using odbc. I am using a user defined sql to pull records from source tables. Target is oracle and i am using odbc to write to target table. I have specified transaction size as 100 and array size as 1 in target stage and transaction handling as none for source stage. Still My job is aborted due to the following error.
Code: Select all
DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-30036: unable to extend segment by 512 in undo tablespace 'UNDO'
But the question why would a Similar job get executed properly without any errors inspite of user defined sql being similar and the row count being more than the present one ??What am i missing?
Thanks.