Data Warehousing Community Forum
The Warehouse of Data warehousing knowledge ...
Home
Help
Search
Login
Register
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email?
September 09, 2010, 06:21:58 am
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Light Blue
Light Navy
Light Silver
Light Turquoise
Light Green
Light Olive
Light Golden
Light Brown
Light Red
Light Rose
Light Lilac
Light Violet
Data Warehousing Community Forum
>
Databases
>
Oracle
> Topic:
Materialized View-ON-Remote Database
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Materialized View-ON-Remote Database (Read 189 times)
7hills
DW Fresher
Reputation: +2/-0
Offline
Posts: 1
Materialized View-ON-Remote Database
«
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
Posts: 2
Re: Materialized View-ON-Remote Database
«
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
Data Warehousing Community Forum
>
Databases
>
Oracle
> Topic:
Materialized View-ON-Remote Database
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Introductions
=> Rules
=> Anouncements & News
=> Suggestions
=> General Discussion
=> Job Opportunities
-----------------------------
Databases
-----------------------------
=> Oracle
===> PL/SQL
=> Microsoft SQL Server
=> IBM DB2
=> Teradata
-----------------------------
Data Warehousing
-----------------------------
=> Data Warehousing Concepts
=> Data Modeling
-----------------------------
ETL Tools
-----------------------------
=> Informatica
===> Installation & Configuration
=> Data Stage
=> Ab Initio
=> Oracle Warehouse Builder
=> DTS/SSIS
-----------------------------
Reporting Tools
-----------------------------
=> Business Objects
=> Cognos
=> Crystal Reports
=> Hyperion
=> Brio
=> Microstrategy
-----------------------------
Operating Systems
-----------------------------
=> UNIX / Linux
===> Unix Shell Scripting
=> Windows
-----------------------------
Other Technologies & Tools
-----------------------------
=> JAVA
-----------------------------
Guest Forum
-----------------------------
=> Guest Forum
Loading...