扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
作者:中国IT实验室 来源:中国IT实验室 2007年10月7日
关键字: ORACLE
在本页阅读全文(共2页)
Error inserting new record in table
I created this tablespace:
CREATE TABLESPACE TBS DATAFILE 'C:....XXX01.dbf' SIZE 500M REUSE
DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 256
PCTINCREASE 0) ONLINE;
When I try to insert a new record in table ST I get this error:
ORA-01631:maxextents(256) reached in table TOM.ST
ORA-01631 max # extents (string) reached in table string.string
Cause A table tried to extend past MAXEXTENTS.
Action If MAXEXTENTS is less than the system maximum, raise it. Otherwise, you must re-create with larger initial, next or PCTINCREASE parameters.
ORA-01631 max # extents (string) reached in table string.string
Cause A table tried to extend past MAXEXTENTS.
Action If MAXEXTENTS is less than the system maximum, raise it. Otherwise, you must re-create with larger initial, next or PCTINCREASE parameters.
I tried to increase maxextents: (user=system)
but I get this error:
ERROR at line 1:
ORA-25150: ALTERING of extent parameters not permitted
ORA-25150 ALTERING of extent parameters not permitted
Cause An attempt was made to alter the extent parameters for a segment in a tablespace with autoallocate or uniform extent allocation policy.
Action Remove the appropriate extent parameters from the command.
ORA-25150 ALTERING of extent parameters not permitted
Cause An attempt was made to alter the extent parameters for a segment in a tablespace with autoallocate or uniform extent allocation policy.
Action Remove the appropriate extent parameters from the command.
also
alter tablespace TBS default storage (maxextents 500);
ERROR at line 1:
ORA-25143: default storage clause is not compatible with allocation policy
ORA-25143 default storage clause is not compatible with allocation policy
Cause Default storage clause was specified for a tablespace with AUTOALLOCATE or UNIFORM policy.
Action Omit the storage clause.
ORA-25143 default storage clause is not compatible with allocation policy
Cause Default storage clause was specified for a tablespace with AUTOALLOCATE or UNIFORM policy.
Action Omit the storage clause.
如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。
现场直击|2021世界人工智能大会
直击5G创新地带,就在2021MWC上海
5G已至 转型当时——服务提供商如何把握转型的绝佳时机
寻找自己的Flag
华为开发者大会2020(Cloud)- 科技行者