ORA-02320: failure in creating storage table for nested table column
Hello. I am seeing the following error when trying to create an XML table in oracle v11.2 database
CREATE TABLE "XML_LOAD"."STAGE_MC_TRANS_XML" OF XMLTYPE
*
ERROR at line 1:
ORA-02320: failure in creating storage table for nested table column "XMLDATA"."FINANCIAL_TRANS_ENTITY"
ORA-00902: invalid datatype
HEre is the part of the SQL that (I think ) is causing the issue
CREATE TABLE "XML_LOAD"."STAGE_MC_TRANS_XML" OF XMLTYPE
XMLSCHEMA "CDFTransactionFile.xsd" ELEMENT "CDFTransactionFile" ID 23287 PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255
LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
0