prepared for the release of Oracle Database
18c ... the first autonomous database? We are here at the Library. It is
time for DBAs to stop fighting robots with their fingers and losing ...
time to start using our intelligence and winning.
Undocumented but relates to snapshot replication triggers
Synchronizes the existence of an internal trigger with a table or materialized view in the replication catalog.
If the table or materialized view has replication support, then execute this procedure to create the internal replication trigger. If replication support does not exist, then this procedure destroys any related internal trigger.
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
conn sys@pdbdev as sysdba
CREATE MATERIALIZED VIEW uwclass.mv_force
REFRESH FORCE ON DEMAND
WITH ROWID AS
SELECT * FROM servers;