Multiple imports simultaneous?
Date: Tue, 29 Dec 2015 21:28:53 +0000
Message-ID: <FE4C2B093843BB4B873D754E5E0BE4DB01998C3DA0_at_DCSOSVMS02.dcso.org>
Just curious about import.
I'm importing an older 9i system into an 11g system. I am precreating the tablespaces, etc.
Ultimately, the import only cares about 3 schemas. One that only has my PL/SQL and the other two have the data. So, Schema A, B, C. Schema B has about 360 tables and about 190 million rows total. Schema D has about 45 tables, but and about 35 million rows of which 27 are in one table that has an XMLTYPE column. Importing just the one table in Schema B takes about 12 hours. I'm working on methods to trim that time.
But, is it possible to do multiple imports at once if using different inbound schemas.
- Export the database to create my dump file.
- ON the target server, make 3 copies of the import file.
- Do an import of Schema A, rows=n, indexes=n, constraints=n
- Do an import of Schema B, rows=n, indexes=n, constraints=n
- Do an import of Schema C, rows=n, indexes=n, constraints=n
- Do an import for each schema where rows =n, and indexes and constraints = y.
Theoretically, this should not interfere with each other. I can set the database to no-archive and increase redo logs so that the waits should be reduced.
Thoughts?
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 29 2015 - 22:28:53 CET