Re: ORA-00942: table or view does not exist for v$session.
From: trub3101 <trub3101_at_sky.com>
Date: Thu, 8 Jul 2010 07:03:38 -0700 (PDT)
Message-ID: <a0c13a79-9c2e-4b9a-9e2a-8dcc8215472e_at_w31g2000yqb.googlegroups.com>
On 8 July, 14:41, Eugene Pokopac <epoko..._at_gmail.com> wrote:
> Probably just a "privilege" issue. V$SESSION is usually a Public
> Synonym for the SYS.V_$SESSION table. Have your DBA grant an explicit
> SELECT privilege on the SYS.V_$SESSION table and see if that works.
>
> ORA-00942 table or view does not exist
>
> Cause: The table or view entered does not exist, a synonym that is not
> allowed here was used, or a view was referenced where a table is
> required. Existing user tables and views can be listed by querying the
> data dictionary. Certain privileges may be required to access the
> table. If an application returned this message, the table the
> application tried to access does not exist in the database, or the
> application does not have access to it.
>
> Action: Check each of the following:
>
> the spelling of the table or view name.
> that a view is not specified where a table is required.
> that an existing table or view name exists.
> Contact the database administrator if the table needs to be created or
> if user or application privileges are required to access the table.
>
> Also, if attempting to access a table or view in another schema, make
> certain the correct schema is referenced and that access to the object
> is granted.
Date: Thu, 8 Jul 2010 07:03:38 -0700 (PDT)
Message-ID: <a0c13a79-9c2e-4b9a-9e2a-8dcc8215472e_at_w31g2000yqb.googlegroups.com>
On 8 July, 14:41, Eugene Pokopac <epoko..._at_gmail.com> wrote:
> Probably just a "privilege" issue. V$SESSION is usually a Public
> Synonym for the SYS.V_$SESSION table. Have your DBA grant an explicit
> SELECT privilege on the SYS.V_$SESSION table and see if that works.
>
> ORA-00942 table or view does not exist
>
> Cause: The table or view entered does not exist, a synonym that is not
> allowed here was used, or a view was referenced where a table is
> required. Existing user tables and views can be listed by querying the
> data dictionary. Certain privileges may be required to access the
> table. If an application returned this message, the table the
> application tried to access does not exist in the database, or the
> application does not have access to it.
>
> Action: Check each of the following:
>
> the spelling of the table or view name.
> that a view is not specified where a table is required.
> that an existing table or view name exists.
> Contact the database administrator if the table needs to be created or
> if user or application privileges are required to access the table.
>
> Also, if attempting to access a table or view in another schema, make
> certain the correct schema is referenced and that access to the object
> is granted.
Thanks for your quick replies Michel and Eugene!
Top stuff! The script is now works!
Thanks again
tb3101
Received on Thu Jul 08 2010 - 09:03:38 CDT