ITPub博客

首页 > IT职业 > IT生活 > First Extent 最小值為 two data block 要考試了才知道

First Extent 最小值為 two data block 要考試了才知道

原创 IT生活 作者:Ricky5678 时间:2008-04-18 14:05:00 0 删除 编辑
INITIAL Specify in bytes the size of the object's first extent. Oracle allocates space for this extent when you create the schema object. Use K or M to specify this size in kilobytes or megabytes. The default value is the size of 5 data blocks. The minimum value is the size of 2 data blocks for nonbitmapped segments or 3 data blocks for bitmapped segments, plus one data block for each free list group you specify. The maximum value depends on your operating system. Oracle rounds values up to the next multiple of the data block size for values less than 5 data blocks, and rounds up to the next multiple of 5 data blocks for values greater than 5 data blocks. Restriction: You cannot specify INITIAL in an ALTER statement. See Also: FREELIST GROUPS for information on freelist groups[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/102752/viewspace-1002716/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论
  • 博文量
    3
  • 访问量
    7662