RE: Datapump Q

  • From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 22 Oct 2008 14:11:25 -0400

Uh, no.  

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

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

-----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" !!!

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 ( 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
\" parallel=16

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 


Other related posts: