Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Informatica Workflow fails because of TEMP tablespace

647741Jul 17 2008 — edited Sep 26 2008

Hi,

I am trying to do a Complete Oracle 11.5.10 load. However my execution plan fails because the SDE_ORA_Payroll_Fact fails. The error in the session log is as follows:

READER_1_1_1> RR_4035 SQL Error [
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

From the error message it is very clear that the Source Qualifier is unable to select the data from the source tables. i have increased the TEMP tablespace too however I keep getting the error. Because of this error my other mappings are also Stopped. Any solutions to this problem?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2008

Added on Jul 17 2008

#business-intelligence-applications

10 comments

3,204 views