MV creation using a view
The MV creation using a view is forcing to use minimum 1 table even if that table is a dummy.
Creating MV directly on view is failing with ORA error ORA-12015. Further if I were to use DUAL instead of dummy table it gives a different ORA error ORA-30354.
Below please find the Codes used.