V$SQLAREA - strange error

[JMac]

I'm trying to trace SQL statements and when I query V$SQLAREA - even with a simple query - I get an error message thus:

prjctl1> select count(*) from v$sqlarea;
select count(*) from v$sqlarea
*
ERROR at line 1:
ORA-00959: tablespace 'PRC1_TEMP' does not exist

Yes - PRC1_TEMP does NOT exist. It did in the past but was renamed. But why is this producing such an error?

I'm logged in as SYSTEM as MS Project Central insists that SYSTEM owns the DB.

[jovery]

Check the TEMP tablespace assigned to the user running the query.

select temporary_tablespace from dba_users where username= '';

Regards

[JMac]

Spot On! Brilliant.
Thanks