Database Utilities (MOSC)

MOSC Banner

Database migration with expdp, impdp utilities

edited Nov 19, 2014 10:01AM in Database Utilities (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center