Receiving ORA-00902 when creating a table with user defined types and REF:s.

RDBMS Version: 8.1.7.4.1
Operating System and Version: Windows 2000

Receiving ORA-00902 when creating a table with user defined types and 
REF:s.

I am receiving ORA-00902 when creating a table with user defined type 
using REF:s. 

All my defined types are created in a schema called 'sas_types' and the 
table should be created in a different schema called 'test'. 

sytax: 
CREATE TABLE TEST.Agg_1960_tab 
OF sas_types.Agg_1960_tt 
TABLESPACE TS_SAS_ROOM_TEST 
; 

I can do a desc sas_types.Agg_1960_tt without problem. The type using 
REF:s to another object type. 

SQL> desc sas_types.Agg_1960_tt; 
Namn Null? Typ 
-------------------------- -------- ------- 
REF_OWNER REF OF sas_INSTANCE_T 
REF_AGGEL REF OF SAS_INSTANCE_T 
POS1 NUMBER 


If I try to create a table based on a object that doesn't use any REF:s it 
works fine. Why? 

I found this technique in Oracle expert one-to-one on page 350. 

Regards 
Mats Jansson 
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].