Home » Server Options » Replication » Materialized Views with Mapping table option
Materialized Views with Mapping table option [message #35538] Tue, 15 February 2005 00:08
bharath
Messages: 30
Registered: November 2000
Member
I have the following query which is working fine for oracle 10G.
CREATE MATERIALIZED VIEW mtest30s ORGANIZATION INDEX
mapping table
INCLUDING colc
OVERFLOW
as (select cola,colb,colc,cold from test30s) ;

Can any body help me what is suitable query if i want to execute this query in oracle 9i.

Report message to a moderator

Previous Topic: Oracle 9i - synchronizing 2 identical schemas
Next Topic: ORA-01219: database not open: queries allowed on fixed tables/views only
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 01:08:22 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.