DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: V$SQLAREA - strange error

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Check the TEMP tablespace assigned to the user running the query.

    select temporary_tablespace from dba_users where username= '';

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Spot On! Brilliant.
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width