Home » Developer & Programmer » Data Integration » Materialized view
Materialized view [message #93466] Tue, 08 February 2005 01:13 Go to next message
Hana
Messages: 5
Registered: May 2004
Junior Member
Hello friends,
is it possible to create a materialized view on the table that is in the other
database server?
I have 2 oracle 9i databases on Windows XP. I want to use REFRESH FAST ON COMMIT clause
and database link:
CREATE MATERIALIZED VIEW MVIEW_DEPT
PCTFREE 0
STORAGE (initial 8k next 8k pctincrease 0)
BUILD IMMEDIATE
REFRESH FAST ON COMMIT
AS
SELECT * FROM dept@nem_link;

Privileges is O.K. and I also created database link and VIEW LOG:

CREATE MATERIALIZED VIEW LOG ON dept
TABLESPACE "USERS"
STORAGE (initial 1M next 1M pctincrease 0)
pctfree 5 pctused 90;

When I make only SELECT * FROM dept@nem_link; - it is O.K. MATERIALIZED VIEW LOG is also O.K., but when I want to create MATERIALIZED VIEW, it does the error:

ERROR in line 7:
ORA-12054: pro materializovaný pohled nelze nastavit atribut obnovy ON COMMIT

Thanks Hana
Re: Materialized view [message #108836 is a reply to message #93466] Sat, 19 February 2005 00:07 Go to previous message
Sreedhar Reddy
Messages: 55
Registered: January 2002
Member
CREATE MATERIALIZED VIEW MVIEW_DEPT AS SELECT * FROM dept@nem_link

Once the materialized view is created, try using EM Console..check the wahehouse house..
change the materialized view statics....
Previous Topic: updating the target table in OWB
Next Topic: Dimension and Table Difference
Goto Forum:
  


Current Time: Tue Aug 11 17:50:07 CDT 2020