Database DataWarehousing (MOSC)

MOSC Banner

MV creation using a view

edited Feb 27, 2018 4:05AM in Database DataWarehousing (MOSC) 2 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center