QSM-01293: anti-join marker not found in materialized view with joins
Cause: Materialized view has outer join while the query has inner join. For rewrite to succeed MV must have an anti-join marker like the rowid or primary key of the right tables of outer join
Action: None
QSM-01295
Custom Search


More Oracle errors
RMAN-06020connected to auxiliary database (not started)
ORA-03281invalid ALLOCATE EXTENT option
PLS-00589no attributes found in object type "string"
PCC-02342using WHERE CURRENT OF on cursor defined without FOR UPDATE clause
ORA-14105RECOVERABLE/UNRECOVERABLE may not be specified in this context
PCC-02391Runtime context variable not of correct type
RMAN-06148redundancy count must be greater than zero
ORA-15084ASM disk "string" is offline and cannot be dropped.
ORA-09938Save of signal handlers failed.
ORA-38790BEFORE must be specified with RESETLOGS
ORA-26668STREAMS process string exists
ORA-02064distributed operation not supported
ORA-31205DBMS_LDAP: PL/SQL - Invalid LDAP Auth method.
DRG-11515not enough text key values
ORA-27503IPC error attempting to cancel request
OCI-22319type attribute information altered in ALTER TYPE
ORA-09987unable to attach to SGA in READ-ONLY mode
RMAN-08126keep attributes for the proxy copy are changed
ORA-37414dimension without mapping or hierarchy in ORGANIZATION CUBE clause
QSM-01110query rewrite not possible with materialized view string because it contains a join between tables (string) that is not present in the query and that potentially eliminates rows needed by the qu




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
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
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-01293anti-join marker not found in materialized view with joins