科技行者

行者学院 转型私董会 科技行者专题报道 网红大战科技行者

知识库

知识库 安全导航

至顶网软件频道案例学习Oracle错误:ORA-01631

案例学习Oracle错误:ORA-01631

  • 扫一扫
    分享文章到微信

  • 扫一扫
    关注官方公众号
    至顶头条

  案例一:   向表中插入新的记录时出错   我创建了如下的表空间:   CREATE TABLESPACE TBS DATAFILE \'C:....XXX01.dbf\' SIZE 500M REUSE   DEFAULT STORAGE (INI

作者:中国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领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。

    重磅专题
    往期文章
    最新文章