Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: please help with stored outlines
"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