-
Materialized Views
Hi Everyone,
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?
Thanks
Peer
-
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
Brisbane Australia
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|