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

ORA-26689: column datatype mismatch in LCR

1 Answers  


ORA-00225: expected size string of controlfile differs from actual size string

1 Answers  


DRG-12607: only ctxsys can create MULTI_COLUMN preferences

1 Answers  


ORA-16081: insufficient number of processes for APPLY

1 Answers  


ORA-31652: command response message was invalid type - detaching job

1 Answers  






ORA-31105: User does not own lock "string"

1 Answers  


EXP-00005: all allowable logon attempts failed

1 Answers  


ORA-16722: unable to set LOG_ARCHIVE_DEST_STATE_n parameters

1 Answers  


ORA-02152: Invalid ALTER TABLESPACE ... RENAME option

1 Answers  


ORA-32409: materialized view log on "string"."string" already excludes new values

1 Answers  


TNS-01108: Listener password prompt failed

1 Answers  


ORA-16814: incorrect log transport setting for standby's AlternateLocation

1 Answers  


Categories