QSM-02067: no partition key or PMARKER or join dependent expression in select list
Cause: The capability in question is not supported when the materialized view unless the select list (and group by list if a GROUP BY clause is present) includes the partition key or PMARKER function reference to the table in question or an expression join dependent on the partitioning column of the table in question.
Action: Add the partition key or a PMARKER function reference or a join dependent expression to the select list (and the GROUP BY clause, if present).
QSM-02068
Custom Search


More Oracle errors
ORA-44424BINARY XML storage requires XML Schema registered for BINARY usage
PGU-00360object to be described does not exist
ORA-01190control file or data file string is from before the last RESETLOGS
ORA-13425invalid background filling value parameter
ORA-23606invalid object string
ORA-29534referenced object string.string could not be resolved
ORA-24244invalid host or port for access control list (ACL) assignment
ORA-13469cannot perform updateRaster operation
ORA-02401cannot EXPLAIN view owned by another user
ORA-00447fatal error in background process
RMAN-08528channel string: proxy copy complete, elapsed time: string
QSM-02010join predicate with operator other than equals (=)
SQL*Loader-00309No SQL string allowed as part of string field specification
ORA-38817Insufficient privileges
ORA-19565BACKUP_TAPE_IO_SLAVES not enabled when duplexing to sequential devices
ORA-38708not enough space for first flashback database log file
ORA-00099warning: no parameter file was specified
PGU-41013invalid LANGUAGE parameter
ORA-03001unimplemented feature
ORA-06959Buffer I/O quota is too small




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-02067no partition key or PMARKER or join dependent expression in select list