Re: AW: Export with Query Parameter

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 30 Aug 2005 08:09:15 -0600
Message-ID: <4314688B.9070801@centrexcc.com>

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

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

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

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

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.freelists.org/webpage/oracle-l

Received on Tue Aug 30 2005 - 09:11:14 CDT