ITPub博客

首页 > 数据库 > Oracle > Truncate and data_object_id

Truncate and data_object_id

原创 Oracle 作者:yyp2009 时间:2014-07-01 16:42:16 0 删除 编辑

默认的,一个表当进行truncate 表时DATA_OBJECT_ID将增加1;
但是当此表有一个索引时,进行truncate 表时DATA_OBJECT_ID将增加2:

SQL>
SQL> create table x ( x number );

Table created.

SQL> select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779899 01-JUL-14    01-JUL-14

SQL>  truncate table x;

Table truncated.

SQL>  select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779899 01-JUL-14    01-JUL-14

SQL> insert into x values ( 1 );

1 row created.

SQL> commit;

Commit complete.

SQL> select count(1) from x;

  COUNT(1)
----------
         1

SQL>  select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779899 01-JUL-14    01-JUL-14

SQL> truncate table x;

Table truncated.

SQL>  select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779900 01-JUL-14    01-JUL-14

SQL> truncate table x;

Table truncated.

SQL> select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779900 01-JUL-14    01-JUL-14

SQL>  insert into x values ( 1 );

1 row created.

SQL> select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779900 01-JUL-14    01-JUL-14

SQL> commit;

Commit complete.

SQL> select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779900 01-JUL-14    01-JUL-14

SQL> truncate table x;

Table truncated.

SQL> select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779901 01-JUL-14    01-JUL-14

SQL>
SQL>
SQL>
SQL> create index kk on x(x);

Index created.

SQL>  select count(1) from x;

  COUNT(1)
----------
         0

SQL> insert into x values ( 1 );

1 row created.

SQL> select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779901 01-JUL-14    01-JUL-14

SQL> commit;

Commit complete.

SQL> select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779901 01-JUL-14    01-JUL-14

SQL> truncate table x;

Table truncated.

SQL> select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';

 OBJECT_ID DATA_OBJECT_ID LAST_DDL_TIM CREATED
---------- -------------- ------------ ------------
    779899         779904 01-JUL-14    01-JUL-14

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

请登录后发表评论 登录
全部评论

注册时间:2008-10-17

  • 博文量
    330
  • 访问量
    1094520