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@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
>  
> 

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

Other related posts: