create materialized view log with explicit constraint (merged) [message #679916] |
Mon, 13 April 2020 13:37 |
wtolentino
Messages: 410 Registered: March 2005
|
Senior Member |
|
|
how do you create a materialized view log with explicitly including the constraint name.
for example:
CREATE MATERIALIZED VIEW LOG ON hrms.SSP_inc_tba constraint SSP_INC_TBA_PK primary key (id) new values;
but the above returns an error:
ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option
i know it is not the correct command. this below works but not the explicitly stating the constraints name.
CREATE MATERIALIZED VIEW LOG ON hrms.SSP_inc_tb WITH PRIMARY KEY INCLUDING NEW VALUES;
please advise. thank you.
|
|
|
create materialized view log with explicit constraint [message #679917 is a reply to message #679916] |
Mon, 13 April 2020 13:37 |
wtolentino
Messages: 410 Registered: March 2005
|
Senior Member |
|
|
how do you create a materialized view log with explicitly including the constraint name.
for example:
CREATE MATERIALIZED VIEW LOG ON hrms.SSP_inc_tba constraint SSP_INC_TBA_PK primary key (id) new values;
but the above returns an error:
ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option
i know it is not the correct command. this below works but not the explicitly stating the constraints name.
CREATE MATERIALIZED VIEW LOG ON hrms.SSP_inc_tb WITH PRIMARY KEY INCLUDING NEW VALUES;
please advise. thank you.
|
|
|
|
|