Re: please help with stored outlines

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 12 Jun 2003 23:45:21 +0200
Message-ID: <vehus991ps3u42@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.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Thu Jun 12 2003 - 16:45:21 CDT