if a database link is not involved you can use alter session set current_schema = <end_user>;
After you explain it, be sure to reset the current_schema back to what it was. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -----Original Message----- Sent: Monday, September 23, 2002 1:09 PM To: Multiple recipients of list ORACLE-L How about trying "table_owner".table_name in your query where you specify the tablename in your from clause? Regards, --- Van der Sande Patrick <[EMAIL PROTECTED]> 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 > > ===== Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. 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).
