You cannot use 'WITH ROWID' on a MV based on a prebuilt table.
The prebuilt table requirement was stated in a followup email.
Jared
On 8/26/05, Jason Heinrich <jheinrich@(protected)> wrote: > > When you create your materialized view use the "with rowid" phrase to base > fast refreshes off of the master table's rowids rather than its primary > key > (which you've already stated doesn't exist): > > >
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
You cannot use 'WITH ROWID' on a MV based on a prebuilt table.<br> <br> The prebuilt table requirement was stated in a followup email.<br> <br> Jared<br> <br><br><div><span class="gmail_quote">On 8/26/05, <b class="gmail_sendername" >Jason Heinrich</b> <<a href="mailto:jheinrich@(protected)">jheinrich@(protected)< /a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> When you create your materialized view use the "with rowid" phrase to base<br>fast refreshes off of the master table's rowids rather than its primary key<br>(which you've already stated doesn't exist):<br><br><br>
</blockquote></div><br><br clear="all"><br>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl Evangelist<br><br>
