Can we create Materialized view n exsting view and table?

sboxi
New Contributor II

Dear All,

Is it possible to create Materialized view on view and table (Joining view and table)?

I suspect it is not possible. Please suggest.

Also please provide best way to schedule the refresh of Materialized view.

 

Regards,

Surya