Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user991982Nov 20 2012 — edited Dec 4 2012
环境: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类型的表也能成功,请教下,这个是什么原因呢?
This post has been answered by dony on Nov 26 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2013
Added on Nov 20 2012
5 comments
2,209 views