Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index on the M_ROW$$ column (MATERIALIZE VIEW)

Re: Index on the M_ROW$$ column (MATERIALIZE VIEW)

From: Yurasis Dragon <yurasis_spam_at_yahoo.com>
Date: Wed, 20 Mar 2002 23:47:47 GMT
Message-ID: <9l7i9uspma6439b646ik49nvj0u20ef1us@4ax.com> 





I believe that if you create the snapshot "with primary key", or whatever the
exact syntax is, the index will not be created as the pseudo-column does not
exist.




Shrieking in pain from a horribly disfigured body, lukash33_at_mail.ru (Sergey Lukashevich)  groaned :



>

>Can I create snapshot without such an index?

>





===


Yurasis Dragon


spam_at_smeagol.com
Received on Wed Mar 20 2002 - 17:47:47 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US