RE: Datapump Q
Date: Wed, 22 Oct 2008 14:11:25 -0400
Message-ID: <21469B88E0EA11498818517F210335310455B770@EPRI17P32001A.csfb.cs-group.com>
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_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Channa, Santhosh
Sent: Wednesday, October 22, 2008 2:03 PM
To: cjnewman_at_uillinois.edu; oracle-l_at_freelists.org
Subject: RE: Datapump Q
Isn't that suppose to be "SCHEMA" instead of "SCHEMAS" !!!
Regards,
Santhosh Channa
-----Original Message-----
From: Newman, Christopher [mailto:cjnewman_at_uillinois.edu]
Sent: Wednesday, October 22, 2008 1:55 PM
To: oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l
--
http://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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 22 2008 - 13:11:25 CDT