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: how to rollback a materialized view in oracle 8.1.7
Next Topic: how to replicate some table from one database to remote database
Goto Forum:
  


Current Time: Mon Aug 21 07:16:22 CDT 2017

Total time taken to generate the page: 0.04872 seconds