Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PROBLEM WITH CREATING NESTED TABLE
Hello everybody,
Can somebody helps me to fix this create object table statement:
CREATE TABLE OBJ_ORDER OF ORDER_TYPE
(ORDER_ID NOT NULL)
NESTED TABLE ORDERLIST_LINE_ITEM STORE AS OBJ_ORDER_NT60
,
NESTED TABLE CO_SPECIFIC_ORDER_LIST STORE AS OBJ_ORDER_NT65
;
The message I got back was:
CREATE TABLE OBJ_ORDER OF ORDER_TYPE
*
ORA-02320: failure in creating storage table for nested table column
ORDERLIST_LINE_ITEM
ORA-00903: invalid table name
Look like I have some storage problem.. can anyone give me some hints ?
Thanks in advance,
Paul P. Nguyen Received on Mon Mar 01 1999 - 14:02:59 CST
![]() |
![]() |