Database Administration (MOSC)

MOSC Banner

ORA-02320: failure in creating storage table for nested table column

edited Jul 10, 2013 5:58AM in Database Administration (MOSC) 2 commentsAnswered
 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center