I'm trying to create a materialized view for a view in a different schema.
The select grant on this view is given, but I end up with:
"ORA-22818: subquery expressions not allowed here"
The materialized view works with a table on a different schema, but not with a view.
Anyone come across this?
i would guess that the underlying view contains a subquery exoression that is not permitted in a materialized view
Hm, yes, that's more or less what the error message tells me.
I'm looking for information to help me create a MV that can manage more than just basic selects, if that's at all possible.
You can do it in Oracle 9i.
OCP 8i, 9i DBA
Click Here to Expand Forum to Full Width