Because work at ordinary times to oracle management integration, work on the index, object, stored procedure, statistics, triggers, etc. Don't catch a cold, so please the great god guide, oracle data by DSG, OGG, datagyard, exp/imp, such as data migration needs to be done after the operation, such as the processing of index failure, failure objects such as compilation can have a comprehensive explanation and operation, thank you!

CodePudding user response:

Impdp the content=metadata_only objects here are the basic, and then made than dblink

CodePudding user response:

After migration, had better make a check for all objects, there are invalid, recompile,

 select 'object invalid', the owner, object_type, object_name 
The FROM dba_objects 
Where the status='INVALID' 

CodePudding user response:

If both sides of the migration table structure/user name is the same, then recompile a line