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,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Van der Sande Patrick
INET: patrick.van.der.sande_at_skynet.be
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).
Received on Sat Sep 21 2002 - 14:33:19 CDT
