![]() While it is true that you will need to "rewrite the statement" that you provide in your CREATE MATERIALIZED VIEW statement, you will not have to abandon your subqueries and all your hard work.Īll you have to do is create a view with the subqueries, and then create your materialized view based on the view: ![]() Gives me exactly the results I want and need. Rewrite my query without the subquery expression? But I just spent an hour putting it all together. *Action: Rewrite the statement without the subquery expression. *Cause: An attempt was made to use a subquery expression where these 00000 - "subquery expressions not allowed here" Here's an example of what won't work (note: I am not claiming this query makes any sense):Ģ2818. Yes, it is true: you cannot have a scalar subquery in the SQL statement used to create your materialized view. ORA-22818: subquery expressions not allowed here ![]() Have you ever run into the following error when trying to create a materialized view?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |