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: Sat Nov 01 04:01:08 CDT 2014

Total time taken to generate the page: 0.08938 seconds