Re: AW: Export with Query Parameter

The original poster seemed to be doing a character comparison on what looked like a date field. Could that be the reason it is returning (almost) the entire table? Almost every date would be greater than '01.05.2005' if the comparison were performed as a VARCHAR2. Only 4 days out of every year would be "less" than the character value '01.05.2005'...   '01.06.1967' > '01.05.2005'
 '01.06.2006' > '01.05.2005'
 '01.04.1967' < '01.05.2005'
'01.04.2006' < '01.05.2005'
 etc.
 HTH
Tim

 On 8/30/05, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> What version of Oracle?, of Windows?
>
> All I can say is that it works just fine for me. Has for years.
> Windows(2000) as well as any flavour of unix I've used:
>
> C:\Temp>sqlplus scott/tiger
>
> SQL*Plus: Release 9.2.0.7.0 - Production on Tue Aug 30 08:01:16 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.7.0 - Production
>
>
> scott August 30, 2005
> 08:01:24 ora92.scott> select n1, count(0) from t1 group by n1;
>
> N1 COUNT(0)
> ---------- ----------
> -18 2
> -17 3
> -16 2
> -15 8
> -14 8
> -13 13
> -12 37
> -11 56
> -10 80
> -9 124
> -8 222
> -7 261
> -6 322
> -5 440
> -4 519
> -3 636
> -2 671
> -1 779
> 0 1642
> 1 717
> 2 714
> 3 634
> 4 490
> 5 426
> 6 345
> 7 264
> 8 211
> 9 148
> 10 88
> 11 58
> 12 36
> 13 17
> 14 16
> 15 8
> 16 2
> 18 1
>
> 36 rows selected.
>
> 08:01:34 ora92.scott> exit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 -
> Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.7.0 - Production
>
> C:\Temp>more test.epar
> file=test.exp
> indexes=y
> rows=Y
> statistics=none
> tables=t1
> query="where n1=12"
>
> C:\Temp>exp scott/tiger parfile=test.epar
>
> Export: Release 9.2.0.7.0 - Production on Tue Aug 30 08:03:15 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.7.0 - Production
> Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set
> server uses WE8ISO8859P15 character set (possible charset conversion)
>
> About to export specified tables via Conventional Path ...
> . . exporting table T1 36 rows exported
> Export terminated successfully without warnings.
>
> C:\Temp>
>
> or with 10g (with obviously a different table t1):
>
> C:\Temp>more test.epar
> file=test.exp
> indexes=y
> rows=Y
> statistics=none
> tables=t1
> query="where n1=2"
>
> C:\Temp>sqlplus scott/tiger
>
> SQL*Plus: Release 10.1.0.3.0 - Production on Tue Aug 30 07:56:25 2005
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
>
> scott August 30, 2005
> 07:56:30 ora101.scott> select n1, count(0) from t1 group by n1;
>
> N1 COUNT(0)
> ---------- ----------
> 0 393
> 1 401
> 2 400
> 3 405
> 4 392
> 5 377
> 6 399
> 7 371
> 8 396
> 9 423
> 10 397
> 11 390
> 12 401
> 13 417
> 14 388
> 15 363
> 16 419
> 17 380
> 18 411
> 19 401
> 20 392
> 21 401
> 22 355
> 23 380
> 24 448
> 100
>
> 26 rows selected.
>
> 07:56:38 ora101.scott> exit
> Disconnected from Oracle Database 10g Enterprise Edition Release
> 10.1.0.3.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> C:\Temp>exp scott/tiger parfile=test.epar
>
> Export: Release 10.1.0.3.0 - Production on Tue Aug 30 07:56:51 2005
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0
> - Production
> With the Partitioning, OLAP and Data Mining options
> Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
> set
> server uses WE8ISO8859P15 character set (possible charset conversion)
>
> About to export specified tables via Conventional Path ...
> . . exporting table T1 400 rows exported
> Export terminated successfully without warnings.
>
> C:\Temp>
>
> Michael.Fleck_at_lvr.de wrote:
>
> > 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
> >
>
> --
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com <http://www.centrexcc.com>
> --
> http://www.freelists.org/webpage/oracle-l
>

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