Nested Table Syntax
430355Sep 30 2004 — edited Sep 30 2004I'm trying to add a nested table to an existing table,
but have issues with my syntax and I can't find an examples of the full STORE AS clause. Here's what I'm trying:
SQL>ALTER TABLE tb_DailySales
2 ADD(nt_OrderTypes TT_ORDERTYPES)
3 NESTED TABLE nt_OrderTypes STORE AS Nest_OrderTypes
4 (TABLESPACE ts_CheckDetail
5 STORAGE (PCTINCREASE 0)
6 (PRIMARY KEY(NESTED_TABLE_ID, num_OrderType))
7 ORGANIZATION INDEX COMPRESS);
ALTER TABLE tb_DailySales
*
ERROR at line 1:
ORA-02320: failure in creating storage table for nested table column NT_ORDERTYPES
ORA-00922: missing or invalid option
Thank You