QSM-02182: PCT is enabled through a join dependency
Cause: The capability in question is not supported when the materialized view does not contain some expression join dependent on the partitioning key of relation in question in the select list. For definition of join dependency, please look at Oracle documentation.
Action: Change the query to contain the partitioning key
QSM-02183
Custom Search


More Oracle errors
LFI-01523rename() failed.
PLS-01451The data types of these <value expressions> must be comparable
OCI-31059Cannot insert root XML document node if it already exists
ORA-19816WARNING: Files may exist in string that are not known to database.
TNS-12658ANO service required but TNS version is incompatible
ORA-39795Subtype index is not first attribute for object table or column, string.
TNS-04067Number of connections: number.
LFI-00111No other flags allowed in fixed length format.
O2F-00325None of the characters in a name were legal identifier characters
TNS-02519no appropriate key-negotiation parameters
ORA-33270(DBERR05) Analytic workspace string already exists.
ORA-01238cannot shrink datafile string
ORA-00043remote operation failed
OCI-21300objects option not installed
NZE-28809Cannot delete information from the data source.
DRG-11613URL store: connection refused to host specified by string
ORA-02367read ended but had expected more data from file string
NNL-00002request argument "string" is not allowed with this operation
ORA-22314method information mismatch in ALTER TYPE
ORA-13639The current operation was interrupted because it timed out.




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-02182PCT is enabled through a join dependency