RE: Explain plan of a table you do not own

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Mon, 23 Sep 2002 13:58:24 -0800
Message-ID: <F001.004D7383.20020923135824@fatcity.com>

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
ian_at_SLAC.Stanford.edu

-----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 <patrick.van.der.sande_at_skynet.be> 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: mshakir08816_at_yahoo.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

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 Mon Sep 23 2002 - 16:58:24 CDT