Data Warehousing Community Forum
February 08, 2012, 11:35:49 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Materialized View-ON-Remote Database  (Read 1342 times)
7hills
DW Fresher
*

Reputation: +2/-0
Offline Offline

Posts: 1


View Profile
« 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
Logged
Druid_Elf
DW Fresher
*

Reputation: +2/-0
Offline Offline

Posts: 2


View Profile
« Reply #1 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)
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: