At Datasource Consulting, we operate with a high level of integrity, an expert level of knowledge, and a relentless focus on delivering value to our clients.

Enjoy the following blog articles and let us know if there are topics which interest you that aren’t found in our articles. We enjoy hearing from our readers.

ORA-01652 Informatica

Posted by Tom Nats on Apr 25, 2016 1:52:56 PM

Kept getting this error when trying to query the REP_SESS_TBL_LOG view in the PowerCenter repository:

ORA-01652: unable to extend temp segment by 64 in tablespace TEMP " in the database.

The stats were run (even though they were run the day before) and that didn't help.

Ran this command it fixed the issue:

pmrep>connect -r Production -d Domain_TSA_Prod -n Administrator -x xxxxxxx
Connected to repository Production in Domain_TSA_Prod as user Administrator
connect completed successfully.
pmrep>updatestatistics
updatestatistics completed successfully.
pmrep>exit

Not quite sure what it does as the PowerCenter documentation says very little on this..

===
Updates statistics for repository tables and indexes.
The command returns “updatestatistics completed successfully” or returns “updatestatistics failed” message.
The UpdateStatistics command uses the following syntax:
updatestatistics
===

Topics: Informatica PowerCenter

Written by Tom Nats