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@xxxxxxxxxxxxx> 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@xxxxxx 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> > -- > //www.freelists.org/webpage/oracle-l >