RE: sql developer

From: Jeff Smith <jeff.d.smith_at_oracle.com>
Date: Tue, 10 Feb 2015 12:28:35 -0800 (PST)
Message-ID: <4602d0d4-82f4-4889-9a59-18b195f4ba07_at_default>

Make sure you can see/query the GV$ views vs the V$...  

In version 4.1, not in beta/Early Adopter - we actually show the queries in the Log Panel so you can see what we're doing for yourself.  

From: rajendra.pande_at_ubs.com [mailto:rajendra.pande_at_ubs.com] Sent: Tuesday, February 10, 2015 2:10 PM To: Brian.Zelli_at_RoswellPark.org; oracle-l_at_freelists.org Subject: RE: sql developer  

What version of DB are you connecting to?

The specific functionality maybe version dependent      

From: HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian Sent: Tuesday, February 10, 2015 2:08 PM To: oracle-l (HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org) Subject: sql developer  

Ok, I have the newer sql dev 4.0.3.16 loaded.

I created a dba user for my dev environment and I can click on Tools -> Monitor Sessions and see everything.

I then created a dba user for my prod environment but when I click on Tools -> Monitor Sessions, I get:  

ORA-00942: table or view does not exist    

What did I forget to add?  

Brian    

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 10 2015 - 21:28:35 CET