Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-12031: cannot use primary key columns from materialized
view log on "string"."string"
- 1 Answers
- 7931 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The materialized view log either did not have primary
key columns logged, or the timestamp associated with the
primary key columns was more recent than the last refresh time.
Action: A complete refresh is required before the next fast
refresh. Add primary key columns to the materialized view
log, if required.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 1 No |
ORA-09884: Two Task interface: SID doens't match current PU
SQL*Loader-00291: Invalid bind variable string in SQL string for column string.
IMG-00513: missing value in scaling operation
ORA-00271: there are no logs that need archiving
ORA-23413: table "string"."string" does not have a materialized view log
TNS-01186: Client connection was dropped based on a filtering rule
ORA-16583: bad Data Guard Connection Process DRCX state
DRG-11851: Cache Related Warning
ORA-00054: resource busy and acquire with NOWAIT specified
PLS-00551: character set ANY_CS is only allowed on a subprogram parameter
ORA-24073: cannot specify RETENTION_TIME on exception queue string.string
ORA-30464: no summaries exist
Oracle Errors 
