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.
1) Export the database to create my dump file.
2) ON the target server, make 3 copies of the import file.
a. Do an import of Schema A, rows=n, indexes=n, constraints=n
b. Do an import of Schema B, rows=n, indexes=n, constraints=n
c. Do an import of Schema C, rows=n, indexes=n, constraints=n
3) 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?
