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-06600: old RMAN configuration parameters:

1 Answers  


TNS-00261: Interchange Name Community Link Down Time Remaining (secs)

1 Answers  


ORA-29701: unable to connect to Cluster Manager

1 Answers  


PLS-00614: creating a FINAL NOT INSTANTIABLE type

1 Answers  


DGM-16951: Can not proceed to failover.

1 Answers  


ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals

1 Answers  


NZE-29102: Cannot add certificate bag.

1 Answers  


RMAN-08590: channel string: datafile conversion complete, elapsed time: string

1 Answers  


PCC-00036: No input file name specified

1 Answers  


SQL*Loader-00522: lfiopn failed for file (string)

1 Answers  


ORA-23301: mixed use of deferred rpc destination modes

1 Answers  


ORA-15037: disk 'string' is smaller than mimimum of string MBs

1 Answers  


Categories