| Materialized view [message #93466] |
Tue, 08 February 2005 01:13  |
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  |
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....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
