To Export/Iimport Metadata For a 4TB Database With Many Schemas, Are Multiple Datapump Export/Impor
Hi All,
As part of this cross platform migration from Oracle release 10.2.0.3.0 to 11.2.0.3.0,
we will be exporting and importing metadata of the schemas involved.
The database is 4TB and large number of schemas are involved. TTS is slow and taking a long time.
With single session of expdp/impdp we are impacted with our downtime window for migration.
We are planning to split multiple expdp and impdp sessions for different schemas to speed up the process.
Can you please advise:
1. Running multiple schema expdp or impdp with contents=metadata_only together will be possible and speed up the process?
-- OR --
As part of this cross platform migration from Oracle release 10.2.0.3.0 to 11.2.0.3.0,
we will be exporting and importing metadata of the schemas involved.
The database is 4TB and large number of schemas are involved. TTS is slow and taking a long time.
With single session of expdp/impdp we are impacted with our downtime window for migration.
We are planning to split multiple expdp and impdp sessions for different schemas to speed up the process.
Can you please advise:
1. Running multiple schema expdp or impdp with contents=metadata_only together will be possible and speed up the process?
-- OR --
1