The storage parameters NEXT, PCTINCREASE, MINEXTENTS, MAXEXTENTS, and DEFAULT STORAGE are not valid for locally managed tablespaces.

celiaxi (CICI)
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
(#835657@0)
2002-11-4 -04:00

回到话题: 我在oracle中,create table, maxextents设为10。表创建成功。但为什么在dba_segments中,看到该表的max_extents值为2147483645呢。

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=835657