How to speed up export/import for 500 GB Database?
595674Aug 30 2007 — edited Aug 31 2007Hi:
I am moving a 500 GB Oracle financial DB from HP to AIX environment. Its taking 13 hours to export, 23 hours to import ( data only ) and then 10 hours to build indexes in parallel.
I am using all the suggested parameters for performance improvment. I wanted to find out if there is a way to further imporve the time.
Can I use the following strategy:
a) Export at schema level by slicing all schemas in 5 groups of equal size in data. This will hopefully cut down 13 hours of export to atleast half if not more.
b) Import in target with Rows=N and constraints=N so that all objects are created.
c) Import in five streams at schema level using the 5 set of files created above.
with ignore=Y
d) Import with rows=n, constraints=y and ignore=y ( To build all constraints )
e) Build indexes in parallel using extracted script from source.
Any help will be greatly appreciated.
THanks,
Amir Baig