RE: two questions about expdp

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Thu, 15 Sep 2005 14:17:50 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45023615E2@NT15.oneneck.corp>

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

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

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Baumgartel Sent: Thursday, September 15, 2005 1:23 PM To: oracle-l_at_freelists.org
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.

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

Received on Thu Sep 15 2005 - 16:18:32 CDT