Database migration with expdp, impdp utilities
Hello,
Planning to do migration from one database to another database with expdp, impdp utilities.
During this process reorganisation of tablespaces is going to be proceeded.
Whish that indexes and materialized views and indexes on materialized views are recreated with ddl from expdp file or from ddl definitions got on source database with some changed storage parameters ( like tablespace ).
Also see no need for statistics to be exported with expdp and transferring data through network.
So statistics to be recreated on target database after data is imported and indexes and materiliazed views and MV_indexes recreated.
For better management would do this process on schema level for every schema.