RE: Datapump Q
- From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
- To: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Oct 2008 13:27:12 -0500
Thanks Paul, that solution works.
-----Original Message-----
From: Baumgartel, Paul [mailto:paul.baumgartel@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, October 22, 2008 1:00 PM
To: Newman, Christopher; oracle-l@xxxxxxxxxxxxx
Subject: RE: Datapump Q
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
Other related posts:
