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
===