|
Title: Materialized View-ON-Remote Database Post by: 7hills on June 12, 2010, 10:30:48 am Hi All,
I have 2 Databases. First Database Located remote with OLTP. Second Database Located on Local system with out OLTP. I Started the Process as per Below steps. 1.First i created DBlink on local database to connect remote database. 2.i created Materialized View with "Refresh fast ON commit" option using DBLINK. I am getting the error unable to create. Any idea or help how to resolve this Creation of MV with DBLINKS. Thank you Title: Re: Materialized View-ON-Remote Database Post by: Druid_Elf on July 21, 2010, 08:27:19 pm Hi,
There are several possible options. We use the same principale in our company, although both are OLTP. Correct steps: 1. Create database link 2. Create MV log on the source side table (in your case table 1) 3. Create MV on the 2nd database with the create command (in the select stmts part ... from tbl1@rm db link 4. Do a full refresh of the materialized view 5. From now on you will be able to do fast refresh. One full refresh is required as oracle needs to keep track of the last changes. If not, try posting the ORA error you are getting. Also make sure that you do not have network issues, so test the database link connectivity before trying to create mv (by doing select from dual@db link) |