ORA-32334 A PREDEFINED MATERIALIZED VIEW CANNOT BE CREATED ON A TABLE
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.