AW: Export with Query Parameter
- From: <Michael.Fleck@xxxxxx>
- To: <breitliw@xxxxxxxxxxxxx>
- Date: Tue, 30 Aug 2005 15:37:26 +0200
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@xxxxxxxxxxxxx]
Gesendet: Dienstag, 30. August 2005 14:59
An: Fleck, Michael
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx wrote:
> Hi list members,
>
> Our export-command file looks like this:
> exp system@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
