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.
Previous Topic: Oracle 9i - synchronizing 2 identical schemas
Next Topic: ORA-01219: database not open: queries allowed on fixed tables/views only
Goto Forum:
  


Current Time: Thu Mar 28 16:46:07 CDT 2024