if a database link is not involved you can use
alter session set current_schema = ;
After you explain it, be sure to reset the current_schema back to what it was.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, September 23, 2002 1:09
How about trying
"table_owner".table_name in your query where you specify the tablename
in your from clause?
Regards,
--- Van der Sande Patrick <[EMAIL PROTECTED]> wrote:
> Dear,
>
> As system I want to generate an explain plan of an end user query.
> In this query a number of tables are def
ALTER SESSION SET CURRENT_SCHEMA = ;
-Mark
On Sat, 2002-09-21 at 15:33, Van der Sande Patrick 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 ... statem