QSM-01084: 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 either lossy or lossless 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-01085
Custom Search


More Oracle errors
LSX-00143element "~S" must have type or ref
ORA-07218slkhst: could not perform host operation
ORA-02815Unable to attach shared memory
ORA-16799Redo Apply is not running
ORA-30002SYS_CONNECT_BY_PATH function is not allowed here
ORA-13350two or more rings of a complex polygon touch
ORA-09262spdde: error terminating detached (background) process
ORA-40361only SELECT and ALTER are valid for mining models
DIA-48120error encountered when attempting to retrieve the file size [string] [string]
ORA-00263there are no logs that need archiving for thread string
ORA-10900extent manager fault insertion event #string
EXP-00066Object table string is missing its object identifier index
SQL*Loader-00433no attributes found for column object string in table string
ORA-10574Test recovery did not corrupt any data block
CLST-02309failure updating the configuration in node deletion
EVM-00014Failed to write to EVM listening connection
AMD-00101cannot create string "string"; metadata entity already exists
OCI-31052Cannot delete ACL with other references
ORA-31148string is not a valid resource configuration
DRG-12515cannot specify language for stopwords in a BASIC_STOPLIST




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