we can export Oracle object script from powerdesigner by vb script ,such as table,index etc. but when i export materialized view ,I can't control the detail by vb script ,such as only export create script of materialized view,not include drop script.and i can not export materialized view log script
when we export view we can do this
OptionMPD.GenerationCreateView= true
OptionMPD.GenerationDropView = false
OptionMPD.GenerationCreateViewComment= false
OptionMPD.GenerationColumnComment = false
Set file = system.OpenTextFile(path + "\view\creview"+prefix+".sql", ForWriting, true)
For Each element In ActiveModel.Views
file.Write element.Preview
file.WriteLine
Next
file.Close
in this scrip ,we can not we need something like GenerationCreateView= true to control what kind of script we want to export,and ActiveModel.Views to control what kind of object will be exported . materialized view will be exported with view ,but can not control if export create or drop . and i am not find the value for materialized view log
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.