Hello,
We are in the process of upgrading the Windchill application. As part of this upgrade, we exported the database from Oracle 11g and now need to import the .dmp file into Oracle 19c. We have explored two methods:
Direct Import: We attempted to directly import the Oracle .dmp file into the Oracle 19c server. However, the import process was running for more than 18 hours, so we terminated the job.
Partial Import: We then imported the .dmp file without the indexes, which completed in 18 minutes. Subsequently, we started importing the indexes separately. Currently, after 24 hours, only 49% of the indexes have been imported. There are a total of 4644 indexes, out of which 2551 have been imported, and the remaining are still in the executing state.
Is there any possible way to expedite the import process?
Thank you.