Data Warehousing Community Forum Data Warehousing Community Forum
The Warehouse of Data warehousing knowledge ...
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
September 09, 2010, 06:21:58 am


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Materialized View-ON-Remote Database  (Read 189 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  
 
Jump to:  



© Copyright 2006-2010 DW Forum. All rights reserved

contactSanghala | Cyber Militia | Powered by SMF | SMF © 2006-2009, Simple Machines LLC | Dilber MC Theme by HarzeM