Oracle Solution for Error ora-32308
ORA-32308: object materialized views must use SELECT *
What triggered the Error:
An attempt was made to create an object materialized view where the definition query did not use SELECT * at the topmost level.What should we do to fix it:
Rewrite the definition query so that SELECT * is used at the topmost level.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
