Re: Explain Plan for other users

Hi,

Create public/private synonyms for the tables which are part of the explain plan script.

I hope this helps.
Ajit

In article <6ao63e$jd8_at_snews1.newsguy.com>,   "Morgan" <fmorgan_at_supper.zippo.com> wrote:
>
> Hello, does anyone nows if it is possible to be, for example,. connected as
> SYSTEM and do an Explain plan on a SQL that uses SCOTT tables (without
> having to put scott.table_name ) ?
>
> Thanx,
> Morgan

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet