Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PROBLEM WITH CREATING NESTED TABLE

PROBLEM WITH CREATING NESTED TABLE

From: Paul Nguyen <pnguyen_at_netexplorer.com>
Date: Mon, 01 Mar 1999 14:02:59 -0600
Message-ID: <36DAF273.648C7F86@netexplorer.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US