Re: please help with stored outlines

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Fri, 13 Jun 2003 14:29:38 GMT
Message-ID: <mdlGa.981$Bw2.957@nwrddc03.gnilink.net>

> I get the impression that the hash code will be different because the
tables
> are in two different tablespaces and there is no way to use the same plan
on
> these two tables? Even though they have the same name, but are in
different
> tablespaces.

I believe that is correct. However you can probably copy the stored outline from one to the other.
Never done it .. so its just a guess.
Visit Jonathan Lewis's website for possible hints. I think he did have a note on his website on how
to modify the outln tables ... although a risky procedure and hence not recommended to novices.

HTH Anurag Received on Fri Jun 13 2003 - 09:29:38 CDT