block number mismatch with db block size
Hi,
This is block size of my database
SQL> sho parameter db_block_size
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
db_block_size integer
8192
SQL>
I have create table like
CREATE TABLE row_mig_chain_demo (
x int PRIMARY KEY,
a CHAR(1000),
b CHAR(1000),
c CHAR(1000),
d CHAR(1000),
e CHAR(1000),
f CHAR(1000),
g CHAR(1000),
h CHAR(1000),
i CHAR(1000));
inserted values to this
1 begin
2 for i in 20..100
3 loop
4 insert into row_mig_chain_demo(x) values(i);
5 commit;
6 end loop;
7* end;
SQL> /
When I see block no. of all rows this shows same block no.?
SQL> select count(DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid)),DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid) from row_mig_chain_demo group by DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid);