Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created. the key is "contiguous" , so please check not only the available spaces
1。加表分区时，表分区在哪个表空间上？ ALTER TABLE USER_DAILY ADD PARTITION PART_20030128 VALUES LESS THAN ('20030129') TABLESPACE <whatevertablespacename>;if you don't specify the tablespace , it will created on the default tablespace which the owner ( user) is assigned . ( please check user_users for the name of default tablespace )
1。加表分区时，表分区在哪个表空间上？
2。新建表分区的空间是如何分配的？initial参数（如果有的话）是由什么来决定的。
ALTER TABLE USER_DAILY ADD PARTITION PART_20030128 VALUES LESS THAN ('20030129') TABLESPACE <whatevertablespacename>;if you don't specify the tablespace , it will created on the default tablespace which the owner ( user) is assigned . ( please check user_users for the name of default tablespace )