Re: Explain plan of a table you do not own

ALTER SESSION SET CURRENT_SCHEMA = <shcema_name>;

-Mark

On Sat, 2002-09-21 at 15:33, Van der Sande Patrick wrote:
> Dear,
>
> As system I want to generate an explain plan of an end user query.
> In this query a number of tables are defined which do not have a public synonym.
>
> The explain plan ... statement does not succeed because of a "Table or View does not exist".
>
> Can somebody tell me how to bypass this without having to create public synonym ?
>
> Is it possible in 1 single SQL command ?
> I do not want to work with a third party tool !
>
> Kind Regards,
>
> Ing. Patrick Van der Sande
> Managing Director
> ANDES Consulting BVBA
> www.andes-consulting.be
>

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"It is not enough to have a good mind.  The main thing is to use it
well."
 						-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: mark_at_bobak.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).