Object Has Been Deleted Error when describing v$ system object

sjdDBA

Member
All,

I'm having a problem with 11gR2 databases using PL/SQL Developer 8.0.4.1514.

When I try to right click and choose DESCRIBE on a system object (ie v$session, v$sqlarea), I get a pop-up "object has been deleted" (where is the name of the object I'm describing), and then the DESCRIBE window comes up empty.

When I try to run a describe via the PL/SQL Developer command window, I get the following:

Code:
SQL> desc v$session
Name Type Nullable Default Comments
---- ---- -------- ------- --------

SQL> desc v$sqlarea
Name Type Nullable Default Comments
---- ---- -------- ------- --------

SQL>

I can do this via SQL*Plus, so I don't believe it's a client issue (running 11.2.0.1.0 client).

Any thoughts?

Thanks
 
This does indeed not seem to work. On 11.1 there is no problem, but on 11.2 it fails as described. We'll check it out and will fix it.
 
Back
Top