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 15:00:01 -0700

I tried in

SQL>create table email_request_queue (profile_id number, status 
varchar2(1),request_branch varchar2(03), effective_date  date);
Table created.
SQL>insert into email_request_queue values(7,'S','998','30-APR-2006');
1 row created.
Commit complete.

$ sh -v
exp user@tns tables=email_request_queue file=x.dmp statistics=none 
query=\"WHERE PROFILE_ID = 7 AND STATUS = \'S\' AND request_branch BETWEEN
\'0\' AND \'999\' AND trunc\(EFFECTIVE_DATE\) \<\= 

About to export specified tables via Conventional Path ...
. . exporting table            EMAIL_REQUEST_QUEUE          1 rows exported
Export terminated successfully without warnings.


SELECT clause is not allowed inside the QUERY clause. Per Documentation the 
Query clause internally does a horizontal filtering.


Other related posts: