improt issue with the std imp.exe and impdp.exe
Hi,
Can anybody please provide a solution for the below problem,
- I have taken export of two schema "test" and "test123"
- now I want to import these schema on another database with the name of "abc" and "xyz" respectively.
- I have used fromuser and touser options in normal import and remap_schema option in impdp
- In both the cases after importing schema few views are getting invalid because those views are still referring "test" and "test123" users and not getting updated to "abc" and "xyz".
Is there any options through which i can manage this task without doing it manual compilation of all invalid view?
Can anybody please provide a solution for the below problem,
- I have taken export of two schema "test" and "test123"
- now I want to import these schema on another database with the name of "abc" and "xyz" respectively.
- I have used fromuser and touser options in normal import and remap_schema option in impdp
- In both the cases after importing schema few views are getting invalid because those views are still referring "test" and "test123" users and not getting updated to "abc" and "xyz".
Is there any options through which i can manage this task without doing it manual compilation of all invalid view?
0