Here is the Syntax:

exp yyyy/xxxxxxxxx \
file=clm_pd_li_rmk.dmp \
tables=CLM_PD_LI_RMK_T:CLM_PD_LI_RMK_200601 \
query=\"WHERE pd_dt BETWEEN \'01-\JAN\-2006\' and \'31\-JAN\-2006\'\"

Phong Le


-----Original Message-----
From: Luis Cardenas
[mailto:oracledba-ezmlmshield-x10189812.[Email address protected]
Sent: Tuesday, August 07, 2007 1:04 PM
To: LazyDBA Discussion
Subject: export with a where somewhere

G's



I want to export a table using command line with a where clause for the

table please point me in the direction I must go...



Thanks



Luis







-----------------------------------------

This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page