CREATE INDEX AAA ON ADD_D(BUILDDATE, MODIDATE);
建立不到索引(管理工具和sql/plus中都不行),提示
ORA-01658:无法为表空间xxx_1中的段创建initial区。
怀疑是表空间不够,drop掉了用户之后,扩大了表空间,然后重新倒入了数据,但还是不行!!
高手帮忙。。
---------------------------------------------------------------
你试一试把initial参数值设小一点看看
---------------------------------------------------------------
it's very clear :
ORA-01658 unable to create INITIAL extent for segment in tablespace string
Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.
Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL.