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.
updatestatistics completed successfully.
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: