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

  • From: "GovindanK" <gkatteri@xxxxxxxxxxx>
  • To: "GovindanK" <gkatteri@xxxxxxxxxxx>, JayMiller@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 26 May 2006 17:11:30 -0700

Correction. It should be "rowid in" instead of "rowid ="

query=\"WHERE rowid in \(select \/\*\+ PUT_YOUR_HINT_HERE \*\/rowid from 
email_request_queue\)\"
Oracle accepts rowid with subquery is accepted.

HTH
GovindanK

On Fri, 26 May 2006 16:08:12 -0700, "GovindanK" <gkatteri@xxxxxxxxxxx> said:
> 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
> 
> 
--
//www.freelists.org/webpage/oracle-l


Other related posts: