Re: Export with Query Parameter

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: Michael.Fleck@xxxxxx
  • Date: Tue, 30 Aug 2005 06:58:54 -0600

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2005