OraFAQ Forum: Replication » No indexes on Materialized view

Home » Server Options » Replication » No indexes on Materialized view (Oracle 10g 10.2)

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

No indexes on Materialized view [message #292694]

Wed, 09 January 2008 12:06

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all

I have created materiaized view

Create Materialized View table_name
Tablespace FG_Report
Build Immediate Refresh Force
Start with SYSDATE next SYSDATE+5/1440
As Select * from table_name@dblink;

after creating, i don't see indexes on the the materialized view created. where as in actual table we have indexes..

Can we replicate indexes along with Materialized views?

Thanks in advance.

Report message to a moderator