Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02115: mv references a remote object and is refreshed ON
COMMIT
- 1 Answers
- 2660 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The capability in question is not supported when the
materialized view references a remote object and is
refreshed ON COMMIT.
Action: Re-phrase the query to avoid the reference to the
remote object or alter the materialized view to be refreshed
ON DEMAND.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-39139: Data Pump does not support XMLSchema objects. string will be skipped.
NZE-29006: The certificate request message is invalid when using SSL 2.0.
QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher
DRG-11870: Response From WAIS Server Too Large -- Extra Lines Ignored
PLS-01701: Illegal syntax in ROLLBACK WORK statement
TNS-04201: Trace Assistant Usage ERROR: Missing File name
RMAN-08543: channel string: specifying archivelog(s) for proxy backup
ORA-28182: cannot acquire Kerberos service ticket for client
RMAN-06188: cannot use command when connected to a mounted target database
ORA-39136: cannot specify an SCN on a transportable job
DRG-50919: NEAR operand not a phrase, equivalence or another NEAR expression
ORA-28538: result set not found
Oracle Errors 
