QSM-01004: no query rewrite before view merging



QSM-01004: no query rewrite before view merging..

Answer / guest

Cause: Internal session parameter _QUERY_REWRITE_2 is set to
FALSE

Action: Change session parameter with ALTER SESSION command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23338: priority or value already in priority group string

1 Answers  


PCC-02015: unable to open include file

1 Answers  


RMAN-04031: initialization parameters used for automatic instance: string

1 Answers  


ORA-32583: query passed to table function has wrong number of elements in select list

1 Answers  


ORA-12649: Unknown encryption or data integrity algorithm

1 Answers  






NNO-00603: enabling all request processing

1 Answers  


ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)

1 Answers  


ORA-02784: Invalid shared memory ID specified

1 Answers  


PLS-00462: nested subprogram 'string' has to be REPEATABLE

1 Answers  


ORA-12418: user string not found

1 Answers  


ORA-12511: TNS:service handler found but it is not accepting connections

1 Answers  


ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.

1 Answers  


Categories