Export with Query Parameter

Hi list members,

I have a problem concerning the export utility with the query parameter in an Windows 2000 environment.

We have a 50-million rows table in our production environment and want to export a subset of rows to another instance using export with the query parameter.

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. I've tried some other possibilities like QUERY="""WHERE LAUFMONAT
>'01.05.2005'""", but this also doesn't work.

Best regards
Michael Fleck

LVR InfoKom
michael.fleck_at_lvr.de

--
http://www.freelists.org/webpage/oracle-l