Nope, doesn’t seem to like this, got an

ORA-00933: SQL command not properly ended

 

 

exp eservices3 tables=email_request_queue query=\"SELECT \/\* rule \*\/ \* FROM

EMAIL_REQUEST_QUEUE WHERE PROFILE_ID = 7 AND STATUS = \'S\' AND request_branch BETWEEN \'0\' AND \'999\'  AND trunc\(EFFECTIVE_DATE\) \<= TO_DATE\(\'30-APR-2006\',\'dd-Mon-yyyy\'\)\" file=/oracle/oper/esmail/email_profile7_052006.dmp log=/oracle/oper/esmail/exp_profile7.log

 

 

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of JayMiller@TDWaterhouse.com
Sent: Friday, May 26, 2006 4:01 PM
To: oracle-l@freelists.org
Subject: RE: Export - can I use a hint or set a session level value?

 

I am exporting using a query, but since the syntax for doing so only includes the WHERE clause I didn’t know where I could place the hint (which usually goes after the select.

 

query=\"WHERE PROFILE_ID = 7 AND STATUS = \'S\' AND request_branch BETWEEN \'0\' AND \'999\'  AND trunc\(EFFECTIVE_DATE\) \<= TO_DATE\(\'30-APR-2006\',\'dd-Mon-yyyy\'\)\"

 

Actually, now that I think of it perhaps I can add SELECT /*+ index, etc. */ to the query clause.  I’ll try that now.

 

 

 

 

-----Original Message-----
From: Dennis Williams [mailto:oracledba.williams@gmail.com]
Sent: Friday, May 26, 2006 3:45 PM
To: Miller, Jay
Cc: oracle-l@freelists.org
Subject: Re: Export - can I use a hint or set a session level value?