Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create MV error - PK not found when using 'with rowid' in log
"dnh" <nogood_at_using.this.addr.com> a écrit dans le message de news:41048c45_at_cpns1.saic.com...
> Hi can anyone explain this error:
>
> I run the following commands in a script
>
> create materialized view log on dnh_table with rowid
>
> create materialized view mv_dnh_table
> tablespace small_tables
> refresh fast
> on demand
> as select * from dnh_table
>
> and then get the following error on the last stmt
>
> ORA-12014: table 'DNH_TABLE' does not contain a primary key constraint
>
> I know the table doesn't have a PK, that's why I'm using 'with rowid' when I
> create the log
>
> I'm running Oracle 8.1.7 on SUN (btw, this is a simplified version so please
> don't come back with why bother using a MV to do this etc, etc)
>
> cheers
> nigel
> --
> -----
> to reply, remove cavemen from below:
> fred.nillspam.barney_at_yahoo.com
>
>
...refresh fast with rowid...
(with primary key is the default)
-- Regards Michel CadotReceived on Mon Jul 26 2004 - 12:04:23 CDT