RE: Datapump Q

From: Baumgartel, Paul <>
Date: Wed, 22 Oct 2008 14:11:25 -0400
Message-ID: <>

Uh, no.

Had you checked the docs, you wouldn't have sent this erroneous "correction".

Paul Baumgartel
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
Phone 212.538.1143

-----Original Message-----

[] On Behalf Of Channa, Santhosh Sent: Wednesday, October 22, 2008 2:03 PM To:; Subject: RE: Datapump Q

Isn't that suppose to be "SCHEMA" instead of "SCHEMAS" !!!

Santhosh Channa

-----Original Message-----

From: Newman, Christopher [] Sent: Wednesday, October 22, 2008 1:55 PM To:
Subject: Datapump Q

I've already exported 2 schemas from a db ( 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

Export: Release - 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 - 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


Please access the attached hyperlink for an important electronic communications disclaimer:

-- Received on Wed Oct 22 2008 - 13:11:25 CDT

Original text of this message