Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> how to export two full schemas and one partial schema into one dump file?
Oracle : 8.1.5
Platform : Sun
Hi:
I have three schemas say A, B and C in one instance. I want to export full schema A and B, and also only some tables (say T1 and T2) in schema C into ONE dump file, and using only ONE par file. By the way, since the dump file is large (>2GB), I am using compress script.
I tried a par file
snip...
OWNER = ( A, B, C)
TABLES = (T1, T2)
...
But I got error
EXP-00026: conflicting mode specified.
Any work around?
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guang Mei
INET: zlmei_at_hotmail.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 23 2001 - 16:12:44 CDT