QSM-01284: materialized view string has an anchor table string not found in query
Cause: A table in a materialized view is an anchor, (a) if it is not joined to any other table or (b) joined to other tables but each of its joins is not guaranteed to provide all the rows or joined with the above table being child-side table. If an anchor which is present in the materialized view is not found in the query, then query rewrite will not take place.
Action: None
QSM-01293
Custom Search


More Oracle errors
CRS-02284Unable to lock the configuration before making changes. number
ORA-27353job attribute string is missing
ORA-30927Unable to complete execution due to failure in temporary table transformation
QSM-01123self-join algorithm could not resolve multiple instances
ORA-16424Terminal recovery cannot start due to GAP on Physical Standby
ORA-14269cannot exchange partition other than a Range,List,System, or Hash partition
ORA-19336Missing XML root element
ORA-00105too many dispatcher configurations
EVM-00802Failed to reconnect within number seconds - terminating
ORA-27467invalid datatype for string value
ORA-13658The specified directive already has an instance
ORA-19776PROXY restore to ASM disk group "string" is not supported.
ORA-01670new datafile string needed for standby database recovery
ORA-19710unsupported character set string
ORA-01199file string is not in online backup mode
ORA-28232invalid input length for obfuscation toolkit
RMAN-06462no backup sets found on device DISK that match specification
ORA-02239there are objects which reference this sequence
ORA-04047object specified is incompatible with the flag specified
PROT-00004Failed to retrieve data from the cluster registry




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-01284materialized view string has an anchor table string not found in query