Help me to reduce Import timing.
Hi all
I am working in database migration using datapump tool. it taking long hours to complete the import, we tried couple test on mock region but our customer only have 8hrs outage to complete the migration activity.
Mock migration 1
> export all the required schema from source db (10.2.4, running on Solaris) with exclude staticts and parallel 10, it tooks around 1 hrs : 41 min
> Import into target db (11.2, running on Linux), it tooks around 6 hrs : 10 min and validataion tooks 1hrs (parallel 10)
> total hours is around 9hrs
Mock migration 2
> export all the required schema from source db (10.2.4, running on Solaris) with exclude staticts and parallel 16, it tooks around 2 hrs : 11min
I am working in database migration using datapump tool. it taking long hours to complete the import, we tried couple test on mock region but our customer only have 8hrs outage to complete the migration activity.
Mock migration 1
> export all the required schema from source db (10.2.4, running on Solaris) with exclude staticts and parallel 10, it tooks around 1 hrs : 41 min
> Import into target db (11.2, running on Linux), it tooks around 6 hrs : 10 min and validataion tooks 1hrs (parallel 10)
> total hours is around 9hrs
Mock migration 2
> export all the required schema from source db (10.2.4, running on Solaris) with exclude staticts and parallel 16, it tooks around 2 hrs : 11min
0