| this PL/SQL function cannot be supported for query rewrite | |
| Cause: | The statement referenced a PL/SQL function that is not marked DETERMINISTIC. |
| Action: | Perform one of the following actions:
- Remove the use of the PL/SQL function. - Mark the PL/SQL function as DETERMINISTIC. - Disable the REWRITE option on the materialized view. The function should be marked DETERMINISTIC only if it always returns the same result value for any given set of input argument values, regardless of any database state or session state. Do not mark the function as DETERMINISTIC if it has any meaningful side-effects. |
| ORA-30358 | |
Custom Search
|
| More Oracle errors | |
| ORA-41608 | rule class does not exist |
| ORA-26024 | SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable |
| ORA-24265 | Insufficient privileges for SQL profile operation |
| ORA-31012 | Given XPATH expression not supported |
| PCB-00208 | Incorrect type for host variable "string" |
| ORA-22345 | recompile type string.string before attempting this operation |
| PGU-00361 | error during describe |
| PCC-00091 | TYPE statement requires format specification for this Oracle datatype |
| OCI-21610 | size [string] is invalid |
| ORA-39023 | Version string is not supported. |
| ORA-24383 | Overflow segment of an IOT cannot be described |
| NNL-00015 | type "string" has "string" syntax, which has no textual representation |
| RMAN-00565 | unable to read input file |
| PCC-02438 | Arrays of collection objects are not allowed |
| ORA-29536 | badly formed source: string |
| ORA-39955 | invalid PL/SQL warning message number |
| ORA-36673 | (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the <LEAF: VALUE> format. |
| TNS-00002 | INTCTL: error while starting the Interchange |
| LSX-00136 | "maxOccurs" is less than "minOccurs" |
| DRG-50906 | score threshold string is not an integer |
| TOP 20 Oracle errors | |
| ORA-12504 | TNS:listener was not given the SERVICE_NAME in CONNECT_DATA |
| RMAN-20079 | full resync from primary database is not done |
| ORA-14411 | The DDL cannot be run concurrently with other DDLs |
| ORA-14760 | ADD PARTITION is not permitted on Interval partitioned objects |
| ORA-10877 | error signaled in parallel recovery slave string |
| ORA-32701 | Hang detected |
| ORA-00838 | Specified value of MEMORY_TARGET is too small, needs to be at least stringM |
| ORA-16665 | timeout waiting for the result from a database |
| ORA-16957 | SQL Analyze time limit interrupt |
| ORA-16664 | unable to receive the result from a database |
| RMAN-08132 | WARNING: cannot update recovery area reclaimable file list |
| ORA-00000 | normal, successful completion |
| ORA-16766 | Redo Apply is stopped |
| ORA-00837 | Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET |
| RMAN-08137 | WARNING: archived log not deleted as it is still needed |
| DIA-48122 | error with opening the ADR block file [string] [string] |
| ORA-47988 | password should contain at least one numeric and one alphabetic character |
| IMP-00057 | Warning: Dump file may not contain data of all partitions of this table |
| ORA-00001 | unique constraint (string.string) violated |
| ORA-55508 | Invalid input to Flashback Transaction Backout |
| Your own TOP 20 Oracle errors | |
| ORA-30357 | this PL/SQL function cannot be supported for query rewrite |