Re: Critical Qs on materialized views
- From: Jared Still <jkstill@xxxxxxxxx>
- To: jheinrich@xxxxxxxx
- Date: Sat, 27 Aug 2005 01:28:10 +0100
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@xxxxxxxx> 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
Other related posts:
