Uh, no. Had you checked the docs, you wouldn't have sent this erroneous "correction". 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 Channa, Santhosh Sent: Wednesday, October 22, 2008 2:03 PM To: cjnewman@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: Datapump Q Isn't that suppose to be "SCHEMA" instead of "SCHEMAS" !!! Regards, Santhosh Channa -----Original Message----- From: Newman, Christopher [mailto:cjnewman@xxxxxxxxxxxxx] 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 -- //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