5 Replies Latest reply: Dec 4, 2012 9:26 PM by user991982 RSS

    ORA-60019: Creating initial extent of size string in tablespace of extent

    user991982
      环境:ORACLE11.2.0.3 64BIT 当向一张已经存在的表新建一列时语法如下:alter table xxxx add BASE_INFO2 XMLTYPE 出现ORA-60019错误:ORA-60019: Creating initial extent of size 8 in tablespace of extent size 14
      把添加列的语法改为alter table xxxx add BASE_INFO2 XMLTYPE BASE_INFO2 STORE AS CLOB
      (TABLESPACE users
      STORAGE (INITIAL 1M)); 则能正常添加,但是新建一张表含有XMLTYPE类型的表也能成功,请教下,这个是什么原因呢?