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
[EMAIL PROTECTED]
"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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
