mporting mviews using impdp

[84]Hi Philip, Sorry for the late reply. Thanks fo...... sze jie koh

Subject: importing mviews using impdp
Os info: Linux
Oracle info: 11gr
Message: Hi all,
q1) If my expdp dump is done using schema export, during the impdp, can
I
- import mviews ddls (mview and the mview table)
- import mviews log ddls
- exclude mview data
- exclude mview refresh job
=================================
However, I do not want any mview refresh or any data in the mview.
The users will manually refresh the mviews when required.
===================================
q2) Is mview data recreated during a impdp ? or it is impdp from the
expdp itself ?
Regards,
Noob


Subject: Re: importing mviews using impdp
Message: Hi,
Suggestion is to EXCLUDE mview from export.
The export will be both smaller and faster and the same for the import.
You need a separate export for the mviews with CONTENT=METADATA_ONLY.
Extract the sqlfile from this export and edit:
BUILD DEFERRED
REFRESH ON DEMAND
HTH, Philip


Subject: Re: importing mviews using impdp
Message: Hi Philip,
Sorry for the late reply.
Thanks for your advice.
If i do an expdp(with exclude MVIEW)
- are the mviews log still exported ? is mview_log tie to the mview or
tie to the original base table
** i am not refering the mview table)
- are the original refresh jobs/group, still exported as well ?
Regards,
Noob