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-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).

1 Answers  


ORA-07275: unable to send signal to process

1 Answers  


ORA-29811: missing STATISTICS keyword

1 Answers  


PCB-00237: Declaration of "string" cannot have a level number greater than 48

1 Answers  


ORA-39046: Metadata remap string has already been specified.

1 Answers  






ORA-24149: invalid rule name

1 Answers  


RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped

1 Answers  


ORA-07800: slbtpd: invalid number

1 Answers  


ORA-31663: metadata remap name can not be defaulted

1 Answers  


ORA-23370: table string and table string are not shape equivalent (string)

1 Answers  


ORA-31209: DBMS_LDAP: PL/SQL - LDAP count_entry error.

1 Answers  


LPX-00271: FTP login failed: ~s

1 Answers  


Categories