Re: Critical Qs on materialized views

From: Jared Still <jkstill_at_gmail.com>
Date: Sat, 27 Aug 2005 01:28:10 +0100
Message-ID: <bf463805082617281afe64d4@mail.gmail.com>

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_at_pcci.edu> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 26 2005 - 19:30:12 CDT