OraFAQ Forum: Replication » Materialized Views with Mapping table option

Members
Search
Help
Register
Login
Home

Home » Server Options » Replication » Materialized Views with Mapping table option

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 15:02:07 CDT 2013

Total time taken to generate the page: 0.97424 seconds