RE: Export - can I use a hint or set a session level value?
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: JayMiller@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 26 May 2006 16:08:12 -0700
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@xxxxxxxxxxxxxxxx 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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
