QSM-02142: COUNT(*) is not present in the select list



QSM-02142: COUNT(*) is not present in the select list..

Answer / guest

Cause: The materialized view query omits COUNT(*) from the
select list.

Action: Add COUNT(*) to the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-04063: %s has errors

1 Answers  


ORA-14299: total number of partitions/subpartitions exceeds the limit of 65535

1 Answers  


ORA-12593: TNS:no registered connection

1 Answers  


TNS-01153: Failed to process string: string

1 Answers  


ORA-39702: database not open for UPGRADE or DOWNGRADE

1 Answers  






ORA-29836: failed to validate referenced operators

1 Answers  


NID-00104: Need to specify TARGET connection parameter in command line

1 Answers  


ORA-12011: execution of string jobs failed

1 Answers  


LPX-00224: multiple occurrences of attribute "~S" found

1 Answers  


CLSR-00515: A service member is already running on this node

1 Answers  


TNS-01178: Trace Level is 0. Trace file/directory unchanged

1 Answers  


ORA-24146: rule string.string already exists

1 Answers  


Categories