QSM-01271: query rewrite not possible because a join in materialized view string with table string has eliminated some rows found in query
Cause: A join from the materialized view to any table that eliminates some rows should be be present in the query. Otherwise query rewrite will not occur.
Action: None
QSM-01273
Custom Search


More Oracle errors
ORA-23375feature is incompatible with database version at string
ORA-14271table is not partitioned by Composite Range method
ORA-16570database needs restart
ORA-25201invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE
ORA-00107failed to connect to ORACLE listener process
ORA-12416policy string not found
ORA-30507normal triggers cannot be based on a schema or a database
ORA-54005keyword VIRTUAL cannot be specified here
LFI-00120Unable to parse root filename string.
AMD-00137prefix "string" exceeds maximum permitted length of string characters
ORA-53033The default UID Definition document cannot be found.
ORA-25021cannot reference a trigger defined on another table
ORA-36236(XSANALYZ06) the AW format must be 11.0.0.0 or higher to use the ANALYZE command
ORA-00074no process has been specified
TNS-12532TNS:invalid argument
ORA-01025UPI parameter out of range
PCC-00122Input file name and output file name are identical
ORA-06434ssaio: read error, unable to read requested block from database file.
DRG-13310index owner does not have EXECUTE privilege on USER_LEXER stored procedure string
PGU-42003COPY reserved word found within a COPY clause




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
QSM-01271query rewrite not possible because a join in materialized view string with table string has eliminated some rows found in query