object view and oid problem

I can't create a object view over two object tables which have only REF attributes (have not primary key).

Object Type T_name(real_name:varchar2,nickname:varchar2)
Object Type T_Person1(name:REF of T_name,age:integer,salary:double)
Object Type T_Person2(name:varchar2,nick_name:varchar2,age:integer)

Object Table Name of T_name(real_name:varchar2,nickname:varchar2) Object Table PersonBoy of T_Person1(name:REF of

          Name,age:integer,salary:double)

Object Table PersonGirl of
T_Person2(name:varchar2,nick_name:varchar2,age:integer)

Now I want create views over them : name_view and person_view
- create or replace view name_view of T_name with object

      oid(real_name,nickname)
  as
    select real_name,nickname from Name     union select name,nick_name from PersonGirl;  It's ok.
- create or replace view person_view of T_Person1 as

    select a.name from PersonBoy a
    union select make_ref(name_view,b.name) from PersonGirl b  It's error - it want 'with object oid' but T_Person1 has key as REF  attribute(name)only and when I add it ('with object oid(name)') ,error  say not primary key.

    How can I create object view like above.

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 20 1999 - 00:38:57 CST