Hi All,
We have oracle db 11.2.0.4 on Aix 5.
We have schema called app_user on PROD.It has more than 100 tables and 20 Materialized views. The schema size is around 5TB. Each MV size more than 50GB.
I am asked to take backup of Materialized view and its log only using exp or expdp from PROD DB. Need to import on another NON-PROD DB.
But i checked with my peer's.They says that it's possible to take backup of MV & MV log only using export /expdp. We have to take whole schema.
Due to production machine.I can't take a risk and testing.
I read the link "https://www.experts-exchange.com/questions/21482322/Exporting-and-Importing-an-Materialized-view-Help-please-fast.html". It says that not possible.
I checked the meta-link 1617655.1.It says that possible with include parameter in expdp (INCLUDE=MATERIALIZED_VIEW: MV_TEST ) but not sure about MV log comes with expdp or not in that meta-link.
I am confused. As of now, i unable to do a test this scenario here.( I know this scenario testing takes only 25 minutes) But right now i unable to do
Anyone face the same scenario and exact commands
Any Suggestions.
Thanks,