Home » Server Options » Replication » No indexes on Materialized view (Oracle 10g 10.2)
No indexes on Materialized view [message #292694] Wed, 09 January 2008 12:06 Go to next message
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.
Re: No indexes on Materialized view [message #292698 is a reply to message #292694] Wed, 09 January 2008 12:13 Go to previous message
Michel Cadot
Messages: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to create them manually.

Previous Topic: PLS-00201: identifier 'SYS.DBMS_REPCAT_UTL2@ORCL.BABU' must be declared
Next Topic: Error while creating MV replication group object
Goto Forum:

Current Time: Wed Oct 26 06:48:58 CDT 2016

Total time taken to generate the page: 0.14725 seconds