Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-32311: materialized view definition query selects an
unsupported user-defined type



ORA-32311: materialized view definition query selects an unsupported user-defined type..

Answer / guest

Cause: An attempt was made in the definition query to select
an embedded user-defined type, function returning a
user-defined type, or a function whose arguments are
user-defined types.

Action: Rewrite the definition query to exclude these
unsupported user-defined types.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16545: unable to get response

1 Answers  


NNL-00917: Artificial request processing delay: string

1 Answers  


PLS-01464: VARIANCE is not a standard set function

1 Answers  


NZE-28770: Data source is already initialized.

1 Answers  


RMAN-06079: database must be mounted to perform recovery

1 Answers  






ORA-01236: Error string occurred during initialization of file header access

1 Answers  


NID-00435: Database name changed to string.

1 Answers  


ORA-02771: Illegal request time out value

1 Answers  


NZE-28839: no persona descriptor

1 Answers  


ORA-25291: Buffer does not exist for the specified queue

1 Answers  


NNO-00120: line string: topology name "string" not allowed here

1 Answers  


ORA-27154: post/wait create failed

1 Answers  






Categories