I'm running fulldb Impdp. There is a large table with 75 bitmap indexes. Impdp is very slow with those indexes and takes about 20 minutes to create one index.
Impdp runs serial to create index even I specify parallel=8.
I'm thinking to create those indexes manually with another SQLPLUS session while impdp is running in the same time. When impdp moves to those indexes, if it's already created, it will give "exist" error and move to next.
That should work, right? Just want to verify with others. Also are there other ways to make impdp index creation faster?
Thanks.