We need to refresh data from few tables so we are planning to create a MATERIALIZED VIEW with required refresh options.
Next requirment is to add few columns which are not part of the tables included in MView.
Can we create a Mview with additional columns say Username and Password which remain null at the time of refresh and later we can update Mview for values. The other column we need to add is a sequence so new insert row can have a Primary key.
Any other work around for this?