重庆分公司,新征程启航

为企业提供网站建设、域名注册、服务器等服务

Oracle中数据块中rownumber缺失该怎么办

Oracle中数据块中row number缺失该怎么办,很多新手对此不是很清楚,为了帮助大家解决这个难题,下面小编将为大家详细讲解,有这方面需求的人可以来学习下,希望你能有所收获。

创新互联建站是一家专业提供凉山州企业网站建设,专注与成都网站制作、网站设计、H5场景定制、小程序制作等业务。10年已为凉山州众多企业、政府机构等服务。创新互联专业网络公司优惠进行中。

环境1:

  1. SCOTT@proc> drop table tt purge;

  2. Table dropped.

  3. SCOTT@proc>

  4. SCOTT@proc>

  5. SCOTT@proc> create table tt (id int,name varchar2(2000)) tablespace users;

  6. Table created.

  7. SCOTT@proc> insert into tt values(1,rpad('a',1800,'+'));

  8. 1 row created.

  9. SCOTT@proc> insert into tt values(2,rpad('b',1800,'+'));

  10. 1 row created.

  11. SCOTT@proc> insert into tt values(3,rpad('c',1800,'+'));

  12. 1 row created.

  13. SCOTT@proc> insert into tt values(4,rpad('d',1800,'+'));

  14. 1 row created.

  15. SCOTT@proc> commit;

  16. Commit complete.

  17. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;

  18.         ID SU ROWID                   FILE#     BLOCK#       ROW#

  19. ---------- -- ------------------ ---------- ---------- ----------

  20.          1 a   AAAV8LAAEAAAAImAAA           4          550          0

  21.          2 b   AAAV8LAAEAAAAImAAB           4          550          1

  22.          3 c   AAAV8LAAEAAAAImAAC           4          550          2

  23.          4 d   AAAV8LAAEAAAAImAAD           4          550          3

  24. SCOTT@proc> delete from tt where id=2;

  25. 1 row deleted.

  26. SCOTT@proc> commit;

  27. Commit complete.

  28. SCOTT@proc> insert into tt values(5,rpad('e',1800,'+'));

  29. 1 row created.

  30. SCOTT@proc> commit;

  31. Commit complete.

  32. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;

  33.         ID SU ROWID                   FILE#     BLOCK#       ROW#

  34. ---------- -- ------------------ ---------- ---------- ----------

  35.          1 a  AAAV8LAAEAAAAImAAA           4          550          0

  36.          5 e   AAAV8LAAEAAAAImAAB           4        550          1

  37.          3 c   AAAV8LAAEAAAAImAAC           4          550          2

  38.          4 d   AAAV8LAAEAAAAImAAD          4          550          3


环境2:

  1. SCOTT@proc> drop table tt purge;


  2. Table dropped.


  3. SCOTT@proc> create table tt (id int,name varchar2(2000)) tablespace users;


  4. Table created.


  5. SCOTT@proc> insert into tt values(1,rpad('a',1800,'+'));


  6. 1 row created.


  7. SCOTT@proc> insert into tt values(2,rpad('b',1800,'+'));


  8. 1 row created.


  9. SCOTT@proc> insert into tt values(3,rpad('c',1800,'+'));


  10. 1 row created.


  11. SCOTT@proc> commit;


  12. Commit complete.


  13. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;


  14.         ID SU ROWID                   FILE#     BLOCK#       ROW#

  15. ---------- -- ------------------ ---------- ---------- ----------

  16.          1 a   AAAV8VAAEAAAAIkAAA           4          548          0

  17.          2 b   AAAV8VAAEAAAAIkAAB          4          548          1

  18.          3 c  AAAV8VAAEAAAAIkAAC          4          548          2


  19. SCOTT@proc> delete from tt where id=2;


  20. 1 row deleted.


  21. SCOTT@proc> insert into tt values(4,rpad('d',1800,'+'));


  22. 1 row created.


  23. SCOTT@proc> commit;


  24. Commit complete.


  25. SCOTT@proc> insert into tt values(5,rpad('e',1800,'+'));


  26. 1 row created.


  27. SCOTT@proc> commit;


  28. Commit complete.


  29. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;


  30.         ID SU ROWID                   FILE#     BLOCK#       ROW#

  31. ---------- -- ------------------ ---------- ---------- ----------

  32.          1 a   AAAV8VAAEAAAAIkAAA          4          548          0

  33.          3 c  AAAV8VAAEAAAAIkAAC           4         548          2

  34.          4 d  AAAV8VAAEAAAAIkAAD           4          548          3

  35.          5 e  AAAV8VAAEAAAAIkAAE          4         548          4


  36. SCOTT@proc>


环境3:

  1. SCOTT@proc> drop table tt purge;

  2. Table dropped.

  3. SCOTT@proc> create table tt (id int,name varchar2(2000)) tablespace users;

  4. Table created.

  5. SCOTT@proc> insert into tt values(1,rpad('a',1800,'+'));

  6. 1 row created.

  7. SCOTT@proc> insert into tt values(2,rpad('b',1800,'+'));

  8. 1 row created.

  9. SCOTT@proc> insert into tt values(3,rpad('c',1800,'+'));

  10. 1 row created.

  11. SCOTT@proc> commit;

  12. Commit complete.

  13. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;

  14.         ID SU ROWID                   FILE#     BLOCK#       ROW#

  15. ---------- -- ------------------ ---------- ---------- ----------

  16.          1 a  AAAV8MAAEAAAAImAAA          4          550          0

  17.          2 b  AAAV8MAAEAAAAImAAB          4         550          1

  18.          3 c   AAAV8MAAEAAAAImAAC          4          550          2

  19. SCOTT@proc> delete from tt where id=2;

  20. 1 row deleted.

  21. SCOTT@proc> commit;

  22. Commit complete.

  23. SCOTT@proc> insert into tt values(4,rpad('d',1800,'+'));

  24. 1 row created.

  25. SCOTT@proc> insert into tt values(5,rpad('e',1800,'+'));

  26. 1 row created.

  27. SCOTT@proc> commit;

  28. Commit complete.

  29. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;

  30.         ID SU              ROWID      FILE#     BLOCK#       ROW#

  31. ---------- -- ------------------ ---------- ---------- ----------

  32.          1 a   AAAV8MAAEAAAAImAAA           4          550          0

  33.          5 e   AAAV8MAAEAAAAImAAB           4          550          1

  34.          3 c   AAAV8MAAEAAAAImAAC           4          550          2

  35.          4 d   AAAV8MAAEAAAAImAAD           4          550          3

看完上述内容是否对您有帮助呢?如果还想对相关知识有进一步的了解或阅读更多相关文章,请关注创新互联行业资讯频道,感谢您对创新互联的支持。


网站栏目:Oracle中数据块中rownumber缺失该怎么办
转载注明:http://cqcxhl.cn/article/jhghed.html

其他资讯

在线咨询
服务热线
服务热线:028-86922220
TOP