如何对表手工扩展一个extent或多个extent

最新推荐文章于 2024-09-21 11:30:16 发布

cucanqi9387

最新推荐文章于 2024-09-21 11:30:16 发布

阅读量189

点赞数

文章标签：数据库

如何对表手工扩展一个extent或多个extent

用alter table allocate extent 命令来实现

SQL> show user
USER is "SYS"

SQL> create table test_extent(a number,b varchar2(10)); ===============> table created

Table created.

SQL> select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENT_ID from dba_extents where segment_name='TEST_EXTENT'; ==============> Checked the extents

OWNER SEGMENT_NAME SEGMENT_TYPE EXTENT_ID
---------- -------------------- ------------------ ----------
SYS TEST_EXTENT TABLE 0

SQL> alter table test_extent allocate extent; =============================> added an extent

Table altered.

SQL> select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENT_ID from dba_extents where segment_name='TEST_EXTENT'; =====> Adds one extent only

OWNER SEGMENT_NAME SEGMENT_TYPE EXTENT_ID
---------- -------------------- ------------------ ----------
SYS TEST_EXTENT TABLE 0
SYS TEST_EXTENT TABLE 1

SQL> alter table test_extent allocate extent(size 5m); ==============================> This will add multiple extents in a single alter statement

Table altered.

SQL> select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENT_ID from dba_extents where segment_name='TEST_EXTENT'; =====> Multiple extents added

OWNER SEGMENT_NAME SEGMENT_TYPE EXTENT_ID
---------- -------------------- ------------------ ----------
SYS TEST_EXTENT TABLE 0
SYS TEST_EXTENT TABLE 1
SYS TEST_EXTENT TABLE 2
SYS TEST_EXTENT TABLE 3
SYS TEST_EXTENT TABLE 4
SYS TEST_EXTENT TABLE 5
SYS TEST_EXTENT TABLE 6

7 rows selected.

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

转载于:http://blog.itpub.net/7199859/viewspace-1852073/