QSM-02083: mv references PL/SQL function that maintains state
Answer / guest
Cause: The capability in question is not supported when the
materialized view references a PL/SQL function that
maintains state and which may not return the same value
every time it is invoked against the same set of rows.
Action: Re-phrase the query to avoid such a PL/SQL function.
Or modify the PL/SQL function to avoid state maintenance and
change its declaration accordingly.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 0 No |
ORA-09764: osnmop: access error on oracle executable
RMAN-06534: KEEP ... CONSISTENT option is not supported
LSX-00231: invalid unsigned integer "~S"
ORA-02717: osnpfs: incorrect number of bytes written
ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE
ORA-19585: premature end of volume on piece string
EXP-00021: can only perform incremental export in Full Database mode
NID-00106: LOGIN to target database failed with Oracle error: string
ORA-03002: operator not implemented
ORA-16022: LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL
ORA-01174: DB_FILES is string buts needs to be string to be compatible
ORA-12525: TNS:listener has not received client's request in time allowed