Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Master database:
There is table called TRANS with materialized view log on that table.
Replication database:
Here is prebuilt table TRANS with materialized view:
CREATE MATERIALIZED VIEW REP.TRANS
(..COLUMNS...)
ON PREBUILT TABLE WITH REDUCED PRECISION
REFRESH FAST
START WITH TO_DATE('13-12-2016 11:22:03','dd-mm-yyyy hh24:mi:ss')
NEXT SYSDATE+2/1440
WITH PRIMARY KEY
AS
SELECT ..COLUMNS..
FROM bla.trans@db_link_master_database; -- db link on master database
Now I need to migrate replication database to another server.
Im not sure how to migrate this materialized view. Can anyone help?