This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 我在oracle中，create table, maxextents设为10。表创建成功。但为什么在dba_segments中，看到该表的max_extents值为2147483645呢。
-lilyba(Sunshine);
2002-11-3
(#834111@0)
-
up
-lilyba(Sunshine);
2002-11-3
(#834459@0)
-
re up
-lilyba(Sunshine);
2002-11-4
(#835408@0)
-
The storage parameters NEXT, PCTINCREASE, MINEXTENTS, MAXEXTENTS, and DEFAULT
STORAGE are not valid for locally managed tablespaces.If you read the manual of sql reference-- stoarge_clause, you will notice the statement like this:
MAXEXTENTS
Specify the total number of extents, including the first, that Oracle can allocate for the object. The minimum value is 1 (except for rollback segments, which always have a minimum value of 2). The default value depends on your data block size.
Restriction on MAXEXTENTS: You cannot change the value of MAXEXTENTS for an object that resides in a locally managed tablespace
-celiaxi(CICI);
2002-11-4
{490}
(#835657@0)
-
Thanks.
-lilyba(Sunshine);
2002-11-4
(#835660@0)