RE: two questions about expdp
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <paul.baumgartel@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Sep 2005 14:17:50 -0700
2. The following worked for me with 10.1.0.2 on WinXP Pro (my laptop):
First example, all on the command line (no parfile, have to backslash the
quotes):
C:\oracle\product\10.1.0\Db_1\bin>expdp scott/tiger tables=dept
query=dept:\"where dname=\'ACCOUNTING\'\"
Export: Release 10.1.0.2.0 - Production on Thursday, 15 September, 2005 14:11
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 -
Production
With the Partitioning, OLAP and Data Mining options
Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** tables=dept
query=dept:"where dname=\'ACCOUNTING\'"
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."DEPT" 5.593 KB 1 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
C:\TEMP\DDD\EXPDAT.DMP
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 14:12
Alternatively, use a parfile:
C:\oracle\product\10.1.0\Db_1\bin>type parfile.txt
tables=dept query=dept:"where dname = 'ACCOUNTING'"
C:\oracle\product\10.1.0\Db_1\bin>expdp scott/tiger parfile=parfile.txt
Export: Release 10.1.0.2.0 - Production on Thursday, 15 September, 2005 14:15
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 -
Production
With the Partitioning, OLAP and Data Mining options
Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** parfile=parfile.txt
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."DEPT" 5.593 KB 1 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
C:\TEMP\DDD\EXPDAT.DMP
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 14:16
HTH
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Paul Baumgartel
Sent: Thursday, September 15, 2005 1:23 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: two questions about expdp
. . .
2. How to specify a query clause of the form column='literal'? I have tried
various combinations of single quotes, double quotes, and double single quotes,
so far with no luck; expdp returning "SQL command not properly ended".
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
