Re: MV Error:ORA-12014: table 'TEST_DATA' does not contain a primary key constraint

Never mind, I got the answer...

Use 'WITH ROWID'

"Sajnish Gupta" <sajnish_gupta_at_yahoo.com> wrote in message news:3bf42ec4$0$24237$4c41069e_at_reader0.ash.ops.us.uu.net...
> I am trying to create Materialized Views as follows:
>
> Create MATERIALIZED VIEW TEST_DATA_MV
> PCTFREE 0
> PCTUSED 99
> INITRANS 2
> MAXTRANS 255
> TABLESPACE T1
> BUILD DEFERRED
> REFRESH ON DEMAND
> AS select * from SCHEMA_TEST.TEST_DATA_at_DBLINK;
>
> ORA-12014: table 'TEST_DATA' does not contain a primary key constraint
>
> The TEST_DATA table in the SCHEMA_TEST does NOT have a Primary Key and I
do
> not want a primary key on TEST_DATA. What should I do to avoid error
> ORA-12014 ? I want to create this Materialized View WITHOUT the Primary
Key,
> is there a way?
>
> thanks for your help
> Sajnish
>
>
>
Received on Thu Nov 15 2001 - 15:23:43 CST