Database DataWarehousing (MOSC)

MOSC Banner

ORA-32334 A PREDEFINED MATERIALIZED VIEW CANNOT BE CREATED ON A TABLE

edited May 2, 2013 2:42AM in Database DataWarehousing (MOSC) 10 commentsAnswered ✓
Hello everyone

I am trying to créate a materialized view on a partitioned table but everytime i run the command

créate materialized view schema.table on prebuilt table refresh on deman as select ......

i keep getting an ora 32334

but if i look for materialized views referring this table i don´t find any.

Could anyone please let me know the correct way to find wich materialized view is referencing my table so that i can drop it a créate my materialized view.

thanks in advance for your help

Greetings

Mateo.

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