QSM-02162: the detail table does not have a materialized
view log



QSM-02162: the detail table does not have a materialized view log..

Answer / guest

Cause: The fast refresh cannot be performed because the
master table does not contain a materialized view log.

Action: Use the CREATE MATERIALIZED VIEW LOG command to
create a materialized view log on the master table.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

CLSS-03000: reconfiguration successful, incarnation string with string nodes

1 Answers  


RMAN-06552: newname for datafile number was set to NEW, but file was not restored

1 Answers  


ORA-01043: user side memory corruption [string], [string], [string], [string]

1 Answers  


ORA-25123: Too many components specified in the name.

1 Answers  


ORA-07200: slsid: oracle_sid not set.

1 Answers  






ORA-02079: no new sessions may join a committing distributed transaction

1 Answers  


ORA-10634: Segment is already being shrunk

2 Answers  


DBV-00200: Block, dba number, already marked corrupted

1 Answers  


TNS-12516: TNS:listener could not find available handler with matching protocol stack

1 Answers  


NCR-04008: NCRR: Procedure exists

1 Answers  


ORA-07490: scgrcl: cannot convert lock.

1 Answers  


NNF-00005: Functionality not implemented

1 Answers  


Categories