Why not just specify a schema-mode export and list all 80+ schemas in a parameter file? Paul Baumgartel CREDIT SUISSE Information Technology Prime Services Databases Americas One Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@xxxxxxxxxxxxxxxxx www.credit-suisse.com -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Newman, Christopher Sent: Wednesday, October 22, 2008 1:55 PM To: oracle-l@xxxxxxxxxxxxx Subject: Datapump Q I've already exported 2 schemas from a db (10.2.0.2) using datapump, and I don't want to export them again; I do however, want to export the other 80+. I can't figure out how to do this properly. I attempted a FULL=Y while excluding as such: /u01/app/oracle: expdp \"/ as sysdba\" directory=DPUMP dumpfile=msgprod2_full.dmp full=y exclude=SCHEMAS:\"='SYNCLOG','SYNCERROR','SYNCLOG_ARCH','SYNCERROR_ARCH' \" parallel=16 Export: Release 10.2.0.2.0 - 64bit Production on Wednesday, 22 October, 2008 12:38:59 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining options ORA-39001: invalid argument value ORA-39038: Object path "SCHEMAS" is not supported for FULL jobs. Any thoughts on how to successfully do this? I think a possible solution would be to just do a full export, then exclude on the import side. I don't want to do this however due to the size of the 2 schemas I've already got(~124G). I've read the manual (b14215.pdf) and I cannot find any references on how to exclude multiple schemas. Chris Newman Database Specialist AITS, University of Illinois 217-333-5429 -- //www.freelists.org/webpage/oracle-l ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== -- //www.freelists.org/webpage/oracle-l