QSM-02170: tables must be identical across the UNION operator



QSM-02170: tables must be identical across the UNION operator..

Answer / guest

Cause: You have specified a materialized view using the
UNION operator and the tables on each side of the UNION
operator do not match. Fast refresh is not supported in this
context.

Action: Restructure the materialized view query such that
the respective sides of the UNION operator have the same table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02176: invalid option for CREATE ROLLBACK SEGMENT

1 Answers  


TNS-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


ORA-00083: warning: possibly corrupt SGA mapped

1 Answers  


IMP-00082: Error during conversion ROWID from string format to internal

1 Answers  


ORA-25300: Cannot drop buffer for queue with buffered subscribers

1 Answers  






RMAN-06535: LIST COPY OF SPFILE is not supported

1 Answers  


ORA-08341: On nCUBE, this command can only be executed from instance 1.

1 Answers  


NNO-00113: line string: alias data already exists, all other data ignored

1 Answers  


PCC-00079: ANSI requires colon on label in WHENEVER statement

1 Answers  


TNS-01036: %s established:string refused:string

1 Answers  


RMAN-08088: applied offline range to datafile string

1 Answers  


RMAN-03020: asynhronous RPC test will take 1 minute

1 Answers  


Categories