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: Ryan <rgaffuri_at_cox.net>
Date: Thu, 12 Jun 2003 22:26:05 GMT
Message-ID: <167Ga.12035$Id7.10030@news2.east.cox.net>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:vehus991ps3u42_at_corp.supernews.com...
>
> "Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message
> news:1efdad5b.0306121146.aba36b_at_posting.google.com...
> > This is the first time I have used them.
> >
> > I logged is as User A, created an outline based on an update
> > statement. Check DBA_OUTLINES. Its been created. I gave it a category.
> >
> > User B, has its own tablespaces which is a duplicate of the tablespace
> > that USer A defaults to. I was hoping to be able to use the outline
> > created by User A, on the tables used by User B, since they have the
> > same name, indexes etc... Its not using it.
> >
> > So I take it that outlines are tablespace based? Can I created an
> > outline for one tablespace and move it to another tablespace?
>
> Outlines are NOT tablespace based, not at all. Evidently User_b is not
> running statements with identical hash_values. To get identical
hash_values,
> statements should be *EXACTLY* the same.

I copy and pasted the statement. Its the exact same thing.
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
Received on Thu Jun 12 2003 - 17:26:05 CDT

Original text of this message

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