SQL> SQL> -- Alter table ... coalesce partition SQL> -- or SQL> -- Alter table modify partition coalesce subpartition SQL> SQL> -- All rows from the coalesced partition go to a single, other partition. SQL> -- ORACLE appears to try to evenly distribute the data, if 'coalesce' is done SQL> -- repeatedly. SQL> SQL> -- You may not want to use this command too often. SQL> -- Use when there are really too many partitions. SQL> SQL> SQL> column object_name format a20 SQL> column subobject_name format a20 SQL> SQL> drop table part_range_hash; Table dropped. SQL> SQL> create table part_range_hash (c1 number(3), c2 varchar2(2), c3 char(2)) 2 partition by range (c1) 3 subpartition by hash (c3) 4 (partition p1 values less than (100) 5 (subpartition p1_d1, 6 subpartition p1_d2, 7 subpartition p1_d3, 8 subpartition p1_d4, 9 subpartition p1_d5, 10 subpartition p1_d6, 11 subpartition p1_d7, 12 subpartition p1_d8), 13 partition p2 values less than (200), 14 partition p3 values less than (maxvalue) 15 ); Table created. SQL> insert into part_range_hash values(1,'xx','a'); 1 row created. SQL> insert into part_range_hash values(2,'xx','b'); 1 row created. SQL> insert into part_range_hash values(3,'xx','c'); 1 row created. SQL> insert into part_range_hash values(4,'xx','d'); 1 row created. SQL> insert into part_range_hash values(5,'xx','e'); 1 row created. SQL> insert into part_range_hash values(6,'xx','f'); 1 row created. SQL> insert into part_range_hash values(7,'xx','g'); 1 row created. SQL> insert into part_range_hash values(8,'xx','h'); 1 row created. SQL> insert into part_range_hash values(9,'xx','i'); 1 row created. SQL> insert into part_range_hash values(10,'xx','j'); 1 row created. SQL> insert into part_range_hash values(11,'xx','k'); 1 row created. SQL> insert into part_range_hash values(12,'xx','l'); 1 row created. SQL> insert into part_range_hash values(13,'xx','m'); 1 row created. SQL> insert into part_range_hash values(14,'xx','n'); 1 row created. SQL> insert into part_range_hash values(15,'xx','o'); 1 row created. SQL> insert into part_range_hash values(16,'xx','p'); 1 row created. SQL> insert into part_range_hash values(17,'xx','q'); 1 row created. SQL> insert into part_range_hash values(18,'xx','r'); 1 row created. SQL> insert into part_range_hash values(150,'yy','b'); 1 row created. SQL> insert into part_range_hash values(250,'ww','c'); 1 row created. SQL> SQL> select count(1) from part_range_hash subpartition(p1_d1); COUNT(1) ---------- 1 SQL> select count(1) from part_range_hash subpartition(p1_d2); COUNT(1) ---------- 1 SQL> select count(1) from part_range_hash subpartition(p1_d3); COUNT(1) ---------- 3 SQL> select count(1) from part_range_hash subpartition(p1_d4); COUNT(1) ---------- 4 SQL> select count(1) from part_range_hash subpartition(p1_d5); COUNT(1) ---------- 2 SQL> select count(1) from part_range_hash subpartition(p1_d6); COUNT(1) ---------- 2 SQL> select count(1) from part_range_hash subpartition(p1_d7); COUNT(1) ---------- 3 SQL> select count(1) from part_range_hash subpartition(p1_d8); COUNT(1) ---------- 2 SQL> SQL> select rowid, c1, c2, c3 from PART_RANGE_HASH; ROWID C1 C2 C3 ------------------ ---------- -- -- AAAN65AAJAAAALIAAA 3 xx c AAAN66AAJAAAAPgAAA 6 xx f AAAN67AAJAAAAPwAAA 8 xx h AAAN67AAJAAAAPwAAB 11 xx k AAAN67AAJAAAAPwAAC 14 xx n AAAN68AAJAAAAXAAAA 2 xx b AAAN68AAJAAAAXAAAB 4 xx d AAAN68AAJAAAAXAAAC 15 xx o AAAN68AAJAAAAXAAAD 18 xx r AAAN69AAJAAAAXIAAA 7 xx g AAAN69AAJAAAAXIAAB 12 xx l ROWID C1 C2 C3 ------------------ ---------- -- -- AAAN6+AAJAAAAXgAAA 5 xx e AAAN6+AAJAAAAXgAAB 17 xx q AAAN6/AAJAAAAXoAAA 9 xx i AAAN6/AAJAAAAXoAAB 10 xx j AAAN6/AAJAAAAXoAAC 16 xx p AAAN7AAAJAAAAX4AAA 1 xx a AAAN7AAAJAAAAX4AAB 13 xx m AAAN7BAAJAAAAYAAAA 150 yy b AAAN7CAAJAAAAaoAAA 250 ww c 20 rows selected. SQL> SQL> select object_name, subobject_name, data_object_id, object_id 2 from user_objects where object_name='PART_RANGE_HASH'; OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH P1 57014 PART_RANGE_HASH P1_D1 57017 57017 PART_RANGE_HASH P1_D2 57018 57018 PART_RANGE_HASH P1_D3 57019 57019 PART_RANGE_HASH P1_D4 57020 57020 PART_RANGE_HASH P1_D5 57021 57021 PART_RANGE_HASH P1_D6 57022 57022 PART_RANGE_HASH P1_D7 57023 57023 PART_RANGE_HASH P1_D8 57024 57024 PART_RANGE_HASH P2 57015 PART_RANGE_HASH P3 57016 OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH SYS_SUBP148 57025 57025 PART_RANGE_HASH SYS_SUBP149 57026 57026 PART_RANGE_HASH 57013 14 rows selected. SQL> SQL> set serveroutput on size 100000 SQL> declare 2 cursor cur1 is select rowid, c2 from part_range_hash; 3 p1 number; 4 p2 number; 5 p3 number; 6 p4 number; 7 p5 number; 8 begin 9 for x in cur1 loop 10 dbms_rowid.rowid_info(x.rowid,p1,p2,p3,p4,p5); 11 dbms_output.put_line('ROWID= '||x.rowid||', rowid_type='||p1||', data_object_id='||p2|| 12 ', relative_fno='||p3||', block_number='||p4||', row_number='||p5); 13 end loop; 14 end; 15 / ROWID= AAAN65AAJAAAALIAAA, rowid_type=1, data_object_id=57017, relative_fno=9, block_number=712, row_number=0 ROWID= AAAN66AAJAAAAPgAAA, rowid_type=1, data_object_id=57018, relative_fno=9, block_number=992, row_number=0 ROWID= AAAN67AAJAAAAPwAAA, rowid_type=1, data_object_id=57019, relative_fno=9, block_number=1008, row_number=0 ROWID= AAAN67AAJAAAAPwAAB, rowid_type=1, data_object_id=57019, relative_fno=9, block_number=1008, row_number=1 ROWID= AAAN67AAJAAAAPwAAC, rowid_type=1, data_object_id=57019, relative_fno=9, block_number=1008, row_number=2 ROWID= AAAN68AAJAAAAXAAAA, rowid_type=1, data_object_id=57020, relative_fno=9, block_number=1472, row_number=0 ROWID= AAAN68AAJAAAAXAAAB, rowid_type=1, data_object_id=57020, relative_fno=9, block_number=1472, row_number=1 ROWID= AAAN68AAJAAAAXAAAC, rowid_type=1, data_object_id=57020, relative_fno=9, block_number=1472, row_number=2 ROWID= AAAN68AAJAAAAXAAAD, rowid_type=1, data_object_id=57020, relative_fno=9, block_number=1472, row_number=3 ROWID= AAAN69AAJAAAAXIAAA, rowid_type=1, data_object_id=57021, relative_fno=9, block_number=1480, row_number=0 ROWID= AAAN69AAJAAAAXIAAB, rowid_type=1, data_object_id=57021, relative_fno=9, block_number=1480, row_number=1 ROWID= AAAN6+AAJAAAAXgAAA, rowid_type=1, data_object_id=57022, relative_fno=9, block_number=1504, row_number=0 ROWID= AAAN6+AAJAAAAXgAAB, rowid_type=1, data_object_id=57022, relative_fno=9, block_number=1504, row_number=1 ROWID= AAAN6/AAJAAAAXoAAA, rowid_type=1, data_object_id=57023, relative_fno=9, block_number=1512, row_number=0 ROWID= AAAN6/AAJAAAAXoAAB, rowid_type=1, data_object_id=57023, relative_fno=9, block_number=1512, row_number=1 ROWID= AAAN6/AAJAAAAXoAAC, rowid_type=1, data_object_id=57023, relative_fno=9, block_number=1512, row_number=2 ROWID= AAAN7AAAJAAAAX4AAA, rowid_type=1, data_object_id=57024, relative_fno=9, block_number=1528, row_number=0 ROWID= AAAN7AAAJAAAAX4AAB, rowid_type=1, data_object_id=57024, relative_fno=9, block_number=1528, row_number=1 ROWID= AAAN7BAAJAAAAYAAAA, rowid_type=1, data_object_id=57025, relative_fno=9, block_number=1536, row_number=0 ROWID= AAAN7CAAJAAAAaoAAA, rowid_type=1, data_object_id=57026, relative_fno=9, block_number=1704, row_number=0 PL/SQL procedure successfully completed. SQL> alter table PART_RANGE_HASH modify partition p1 coalesce subpartition; Table altered. SQL> SQL> select object_name, subobject_name, data_object_id, object_id 2 from user_objects where object_name='PART_RANGE_HASH'; OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH P1 57014 PART_RANGE_HASH P1_D1 57017 57017 PART_RANGE_HASH P1_D2 57018 57018 PART_RANGE_HASH P1_D3 57019 57019 PART_RANGE_HASH P1_D4 57027 57020 PART_RANGE_HASH P1_D5 57021 57021 PART_RANGE_HASH P1_D6 57022 57022 PART_RANGE_HASH P1_D7 57023 57023 PART_RANGE_HASH P2 57015 PART_RANGE_HASH P3 57016 PART_RANGE_HASH SYS_SUBP148 57025 57025 OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH SYS_SUBP149 57026 57026 PART_RANGE_HASH 57013 13 rows selected. SQL> SQL> select count(1) from part_range_hash subpartition(p1_d1); COUNT(1) ---------- 1 SQL> select count(1) from part_range_hash subpartition(p1_d2); COUNT(1) ---------- 1 SQL> select count(1) from part_range_hash subpartition(p1_d3); COUNT(1) ---------- 3 SQL> select count(1) from part_range_hash subpartition(p1_d4); COUNT(1) ---------- 6 SQL> select count(1) from part_range_hash subpartition(p1_d5); COUNT(1) ---------- 2 SQL> select count(1) from part_range_hash subpartition(p1_d6); COUNT(1) ---------- 2 SQL> select count(1) from part_range_hash subpartition(p1_d7); COUNT(1) ---------- 3 SQL> -- p1_d8, the last subpartition is gone SQL> -- All rows in p1_d8 went to p1_d4 SQL> select rowid, c1, c2, c3 from PART_RANGE_HASH; ROWID C1 C2 C3 ------------------ ---------- -- -- AAAN65AAJAAAALIAAA 3 xx c AAAN66AAJAAAAPgAAA 6 xx f AAAN67AAJAAAAPwAAA 8 xx h AAAN67AAJAAAAPwAAB 11 xx k AAAN67AAJAAAAPwAAC 14 xx n AAAN7DAAJAAAAbEAAA 2 xx b AAAN7DAAJAAAAbEAAB 4 xx d AAAN7DAAJAAAAbEAAC 15 xx o AAAN7DAAJAAAAbEAAD 18 xx r AAAN7DAAJAAAAbEAAE 1 xx a AAAN7DAAJAAAAbEAAF 13 xx m ROWID C1 C2 C3 ------------------ ---------- -- -- AAAN69AAJAAAAXIAAA 7 xx g AAAN69AAJAAAAXIAAB 12 xx l AAAN6+AAJAAAAXgAAA 5 xx e AAAN6+AAJAAAAXgAAB 17 xx q AAAN6/AAJAAAAXoAAA 9 xx i AAAN6/AAJAAAAXoAAB 10 xx j AAAN6/AAJAAAAXoAAC 16 xx p AAAN7BAAJAAAAYAAAA 150 yy b AAAN7CAAJAAAAaoAAA 250 ww c 20 rows selected. SQL> SQL> select object_name, subobject_name, data_object_id, object_id 2 from user_objects where object_name='PART_RANGE_HASH'; OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH P1 57014 PART_RANGE_HASH P1_D1 57017 57017 PART_RANGE_HASH P1_D2 57018 57018 PART_RANGE_HASH P1_D3 57019 57019 PART_RANGE_HASH P1_D4 57027 57020 PART_RANGE_HASH P1_D5 57021 57021 PART_RANGE_HASH P1_D6 57022 57022 PART_RANGE_HASH P1_D7 57023 57023 PART_RANGE_HASH P2 57015 PART_RANGE_HASH P3 57016 PART_RANGE_HASH SYS_SUBP148 57025 57025 OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH SYS_SUBP149 57026 57026 PART_RANGE_HASH 57013 13 rows selected. SQL> SQL> declare 2 cursor cur1 is select rowid, c2 from part_range_hash; 3 p1 number; 4 p2 number; 5 p3 number; 6 p4 number; 7 p5 number; 8 begin 9 for x in cur1 loop 10 dbms_rowid.rowid_info(x.rowid,p1,p2,p3,p4,p5); 11 dbms_output.put_line('ROWID= '||x.rowid||', rowid_type='||p1||', data_object_id='||p2|| 12 ', relative_fno='||p3||', block_number='||p4||', row_number='||p5); 13 end loop; 14 end; 15 / ROWID= AAAN65AAJAAAALIAAA, rowid_type=1, data_object_id=57017, relative_fno=9, block_number=712, row_number=0 ROWID= AAAN66AAJAAAAPgAAA, rowid_type=1, data_object_id=57018, relative_fno=9, block_number=992, row_number=0 ROWID= AAAN67AAJAAAAPwAAA, rowid_type=1, data_object_id=57019, relative_fno=9, block_number=1008, row_number=0 ROWID= AAAN67AAJAAAAPwAAB, rowid_type=1, data_object_id=57019, relative_fno=9, block_number=1008, row_number=1 ROWID= AAAN67AAJAAAAPwAAC, rowid_type=1, data_object_id=57019, relative_fno=9, block_number=1008, row_number=2 ROWID= AAAN7DAAJAAAAbEAAA, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=0 ROWID= AAAN7DAAJAAAAbEAAB, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=1 ROWID= AAAN7DAAJAAAAbEAAC, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=2 ROWID= AAAN7DAAJAAAAbEAAD, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=3 ROWID= AAAN7DAAJAAAAbEAAE, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=4 ROWID= AAAN7DAAJAAAAbEAAF, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=5 ROWID= AAAN69AAJAAAAXIAAA, rowid_type=1, data_object_id=57021, relative_fno=9, block_number=1480, row_number=0 ROWID= AAAN69AAJAAAAXIAAB, rowid_type=1, data_object_id=57021, relative_fno=9, block_number=1480, row_number=1 ROWID= AAAN6+AAJAAAAXgAAA, rowid_type=1, data_object_id=57022, relative_fno=9, block_number=1504, row_number=0 ROWID= AAAN6+AAJAAAAXgAAB, rowid_type=1, data_object_id=57022, relative_fno=9, block_number=1504, row_number=1 ROWID= AAAN6/AAJAAAAXoAAA, rowid_type=1, data_object_id=57023, relative_fno=9, block_number=1512, row_number=0 ROWID= AAAN6/AAJAAAAXoAAB, rowid_type=1, data_object_id=57023, relative_fno=9, block_number=1512, row_number=1 ROWID= AAAN6/AAJAAAAXoAAC, rowid_type=1, data_object_id=57023, relative_fno=9, block_number=1512, row_number=2 ROWID= AAAN7BAAJAAAAYAAAA, rowid_type=1, data_object_id=57025, relative_fno=9, block_number=1536, row_number=0 ROWID= AAAN7CAAJAAAAaoAAA, rowid_type=1, data_object_id=57026, relative_fno=9, block_number=1704, row_number=0 PL/SQL procedure successfully completed. SQL> -- Again SQL> alter table PART_RANGE_HASH modify partition p1 coalesce subpartition; Table altered. SQL> SQL> -- p1_d7, the last subpartition is gone SQL> select object_name, subobject_name, data_object_id, object_id 2 from user_objects where object_name='PART_RANGE_HASH'; OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH P1 57014 PART_RANGE_HASH P1_D1 57017 57017 PART_RANGE_HASH P1_D2 57018 57018 PART_RANGE_HASH P1_D3 57028 57019 PART_RANGE_HASH P1_D4 57027 57020 PART_RANGE_HASH P1_D5 57021 57021 PART_RANGE_HASH P1_D6 57022 57022 PART_RANGE_HASH P2 57015 PART_RANGE_HASH P3 57016 PART_RANGE_HASH SYS_SUBP148 57025 57025 PART_RANGE_HASH SYS_SUBP149 57026 57026 OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH 57013 12 rows selected. SQL> SQL> select count(1) from part_range_hash subpartition(p1_d1); COUNT(1) ---------- 1 SQL> select count(1) from part_range_hash subpartition(p1_d2); COUNT(1) ---------- 1 SQL> select count(1) from part_range_hash subpartition(p1_d3); COUNT(1) ---------- 6 SQL> select count(1) from part_range_hash subpartition(p1_d4); COUNT(1) ---------- 6 SQL> select count(1) from part_range_hash subpartition(p1_d5); COUNT(1) ---------- 2 SQL> select count(1) from part_range_hash subpartition(p1_d6); COUNT(1) ---------- 2 SQL> -- All rows in p1_d7 went to p1_d3 SQL> select rowid, c1, c2, c3 from PART_RANGE_HASH; ROWID C1 C2 C3 ------------------ ---------- -- -- AAAN65AAJAAAALIAAA 3 xx c AAAN66AAJAAAAPgAAA 6 xx f AAAN7EAAJAAAAW8AAA 8 xx h AAAN7EAAJAAAAW8AAB 11 xx k AAAN7EAAJAAAAW8AAC 14 xx n AAAN7EAAJAAAAW8AAD 9 xx i AAAN7EAAJAAAAW8AAE 10 xx j AAAN7EAAJAAAAW8AAF 16 xx p AAAN7DAAJAAAAbEAAA 2 xx b AAAN7DAAJAAAAbEAAB 4 xx d AAAN7DAAJAAAAbEAAC 15 xx o ROWID C1 C2 C3 ------------------ ---------- -- -- AAAN7DAAJAAAAbEAAD 18 xx r AAAN7DAAJAAAAbEAAE 1 xx a AAAN7DAAJAAAAbEAAF 13 xx m AAAN69AAJAAAAXIAAA 7 xx g AAAN69AAJAAAAXIAAB 12 xx l AAAN6+AAJAAAAXgAAA 5 xx e AAAN6+AAJAAAAXgAAB 17 xx q AAAN7BAAJAAAAYAAAA 150 yy b AAAN7CAAJAAAAaoAAA 250 ww c 20 rows selected. SQL> SQL> select object_name, subobject_name, data_object_id, object_id 2 from user_objects where object_name='PART_RANGE_HASH'; OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH P1 57014 PART_RANGE_HASH P1_D1 57017 57017 PART_RANGE_HASH P1_D2 57018 57018 PART_RANGE_HASH P1_D3 57028 57019 PART_RANGE_HASH P1_D4 57027 57020 PART_RANGE_HASH P1_D5 57021 57021 PART_RANGE_HASH P1_D6 57022 57022 PART_RANGE_HASH P2 57015 PART_RANGE_HASH P3 57016 PART_RANGE_HASH SYS_SUBP148 57025 57025 PART_RANGE_HASH SYS_SUBP149 57026 57026 OBJECT_NAME SUBOBJECT_NAME DATA_OBJECT_ID OBJECT_ID -------------------- -------------------- -------------- ---------- PART_RANGE_HASH 57013 12 rows selected. SQL> SQL> declare 2 cursor cur1 is select rowid, c2 from part_range_hash; 3 p1 number; 4 p2 number; 5 p3 number; 6 p4 number; 7 p5 number; 8 begin 9 for x in cur1 loop 10 dbms_rowid.rowid_info(x.rowid,p1,p2,p3,p4,p5); 11 dbms_output.put_line('ROWID= '||x.rowid||', rowid_type='||p1||', data_object_id='||p2|| 12 ', relative_fno='||p3||', block_number='||p4||', row_number='||p5); 13 end loop; 14 end; 15 / ROWID= AAAN65AAJAAAALIAAA, rowid_type=1, data_object_id=57017, relative_fno=9, block_number=712, row_number=0 ROWID= AAAN66AAJAAAAPgAAA, rowid_type=1, data_object_id=57018, relative_fno=9, block_number=992, row_number=0 ROWID= AAAN7EAAJAAAAW8AAA, rowid_type=1, data_object_id=57028, relative_fno=9, block_number=1468, row_number=0 ROWID= AAAN7EAAJAAAAW8AAB, rowid_type=1, data_object_id=57028, relative_fno=9, block_number=1468, row_number=1 ROWID= AAAN7EAAJAAAAW8AAC, rowid_type=1, data_object_id=57028, relative_fno=9, block_number=1468, row_number=2 ROWID= AAAN7EAAJAAAAW8AAD, rowid_type=1, data_object_id=57028, relative_fno=9, block_number=1468, row_number=3 ROWID= AAAN7EAAJAAAAW8AAE, rowid_type=1, data_object_id=57028, relative_fno=9, block_number=1468, row_number=4 ROWID= AAAN7EAAJAAAAW8AAF, rowid_type=1, data_object_id=57028, relative_fno=9, block_number=1468, row_number=5 ROWID= AAAN7DAAJAAAAbEAAA, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=0 ROWID= AAAN7DAAJAAAAbEAAB, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=1 ROWID= AAAN7DAAJAAAAbEAAC, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=2 ROWID= AAAN7DAAJAAAAbEAAD, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=3 ROWID= AAAN7DAAJAAAAbEAAE, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=4 ROWID= AAAN7DAAJAAAAbEAAF, rowid_type=1, data_object_id=57027, relative_fno=9, block_number=1732, row_number=5 ROWID= AAAN69AAJAAAAXIAAA, rowid_type=1, data_object_id=57021, relative_fno=9, block_number=1480, row_number=0 ROWID= AAAN69AAJAAAAXIAAB, rowid_type=1, data_object_id=57021, relative_fno=9, block_number=1480, row_number=1 ROWID= AAAN6+AAJAAAAXgAAA, rowid_type=1, data_object_id=57022, relative_fno=9, block_number=1504, row_number=0 ROWID= AAAN6+AAJAAAAXgAAB, rowid_type=1, data_object_id=57022, relative_fno=9, block_number=1504, row_number=1 ROWID= AAAN7BAAJAAAAYAAAA, rowid_type=1, data_object_id=57025, relative_fno=9, block_number=1536, row_number=0 ROWID= AAAN7CAAJAAAAaoAAA, rowid_type=1, data_object_id=57026, relative_fno=9, block_number=1704, row_number=0 PL/SQL procedure successfully completed. SQL> drop table part_range_hash; Table dropped. SQL> SQL> spool off