案例学习Oracle错误：ORA-01631

 　　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.

查看本文来源