Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: please help with stored outlines

Re: please help with stored outlines

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 13 Jun 2003 09:11:49 +0100
Message-ID: <3eea133f$0$19598$cc9e4d1f@news.dial.pipex.com>


"Ryan" <rgaffuri_at_cox.net> wrote in message news:577Ga.12036$Id7.10856_at_news2.east.cox.net...
> However its using different copies of the same tables. The tables have the
> same names, they are just owned by a different user and stored in a
> different tablespace. is it possible to use the outline for this purpose?

I can't see how this would be possible, (doesn't mean it isn't). Suppose User B has objects of a different type with the same name, it would be somewhat daft for Oracle to try to use the same (invalid) execution plan.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Fri Jun 13 2003 - 03:11:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US