Re: Export with Query Parameter

What's with the back slashes before the " ? I always use export with query like this:

...tables=G960DB1.G500MONATSLAUF_T QUERY="WHERE LAUFMONAT >'01.05.2005'"

oracle-l-bounce_at_freelists.org wrote:
> Hi list members,
>
> Our export-command file looks like this:
> exp system_at_oraprod file=G:\exp_tab_oraprod_G960.dmp
> log=G:\exp_tab_oraprod_G960.log statistics=none indexes=N
> tables=G960DB1.G500MONATSLAUF_T QUERY=\"WHERE LAUFMONAT >'01.05.2005'\"
>
> When running a SELECT COUNT(*) query with this WHERE-clause, the system
> returns about 1.000.000 rows.
> The export runs without a syntax error, but it always exports the whole
> table.

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l