Re: Explain plan of a table you do not own

From: Mohammed Shakir <mshakir08816_at_yahoo.com>
Date: Mon, 23 Sep 2002 12:08:42 -0800
Message-ID: <F001.004D711D.20020923120842@fatcity.com>

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).

Received on Mon Sep 23 2002 - 15:08:42 CDT