Unique Index on a view

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 21 Nov 2000 20:49:48 GMT
Message-ID: <3a1adf00.72527546@news.alt.net>

>CREATE TABLE a (a NUMBER(8));

Table created.

>CREATE TABLE b (a NUMBER(8));

Table created.

> CREATE VIEW c AS SELECT a FROM a UNION ALL SELECT a FROM b;

View created.

> CREATE UNIQUE INDEX d ON c(a);

 CREATE UNIQUE INDEX d ON c(a)

                           *

ERROR at line 1:
ORA-01702: a view is not appropriate here

Is there a way to achieve such a constraint?

Brian Received on Tue Nov 21 2000 - 14:49:48 CST