Very Computer

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

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.

Matthias Gresz    :-)