AW: Export with Query Parameter

Hi,

I've found this for Windows-Systems at Metalink. The note states that I have to use \" as delimiter or """ on Windows Systems. I tried both, but the whole table is exported. If I start the export with only one " as you described it, it terminates without any message.

Best regards,
Michael

-----Ursprüngliche Nachricht-----
Von: Wolfgang Breitling [mailto:breitliw_at_centrexcc.com] Gesendet: Dienstag, 30. August 2005 14:59 An: Fleck, Michael
Cc: oracle-l_at_freelists.org
Betreff: 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