Re: Export Table Using QUERY Parameter with Dates

Michael, I am not in front of a computer with access to a UNIX system and Oracle right now but if you provide the query clause on the command line you code only the where clause which must apply to all tables in the export and you enclose the entire where cause in douwble quotes. You have to escape any UNIX meta-characters that appear in the query such as ">"

exp file=qpp tables=x query=\"where qs_date_stamp \< (sysdate - 180)\"

so in your case something like "where tbl_col between to_date('2002-07-01','YYYY-MM-DD') ..."

Give it a shot. You should be able to get it fairly quickly.

HTH -- Mark D Powell -- Received on Sat Oct 15 2005 - 21:10:20 CDT