ORA-30370: set operators are not supported in this context



ORA-30370: set operators are not supported in this context..

Answer / guest

Cause: A set operator such as UNION, UNION ALL, INTERSECT,
or MINUS was encountered in an unsupported context, such as
in a materialized view definition.

Action: Re-specify the expression to avoid the use of set
operators.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06728: could not locate controlfilecopy string

1 Answers  


ORA-02834: Server unable to open file

1 Answers  


TNS-12582: TNS:invalid operation

1 Answers  


ORA-07640: smsget: SGA not yet valid. Initialization in progress

1 Answers  


ORA-12668: Dedicated server: outbound protocol does not support proxies

1 Answers  






ORA-24402: error occured while creating connections in the pool

1 Answers  


NMP-00002: no such SNMP variable name

1 Answers  


ORA-32630: multiple assignment in automatic order MODEL

1 Answers  


RMAN-08035: partial resync skipped, target database not mounted

1 Answers  


ORA-06563: top level procedure/function specified, cannot have subparts

1 Answers  


ORA-16702: generic resource manager warning

1 Answers  


ORA-37012: (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.

1 Answers  


Categories