RE: Export - can I use a hint or set a session level value?

Give this a try. Another theoritcal possibility.

exp ... query=(where rowid=(select /*+ hint */ rowid from table where ..condition..) ) This should make the horizontal filtering of rows process faster.

HTH
GovindanK

On Fri, 26 May 2006 18:45:35 -0400, JayMiller_at_TDWaterhouse.com said:
> I'm not clear on what you tried? This looks like my original export
> script which is giving me the bad access path (without the index).
>
> My question was how to add a hint or some other method to force use of
> the index as the for some profiles the script is now taking over an hour
> instead of 5 minutes.
>
> Thanks,
> Jay Miller
> Sr. Oracle DBA
> x68355
>
>

--
http://www.freelists.org/webpage/oracle-l