Re: Explain Plan for other users

Hi Morgen;

one way would be:

ALTER SESSION SET CURRENT_SCHEMA=SCOTT; Keep in mind that setting current schema is an undocumented, unsupported feature, that normally is used for import and that can be changed by oracle at any time.

Morgan 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
 

-- 
Regards

Matthias Gresz    :-)