All pastes #838474 Raw Edit

Something

public text v1 · immutable
#838474 ·published 2007-12-30 11:56 UTC
rendered paste body
SQL> select * from (select block_id ,segment_name from dba_extents where file_id= 5 order by 1) where rownum =3;


no rows selected

SQL> select * from (select block_id ,segment_name from dba_extents where file_id=5 order by 1) where rownum <3;

  BLOCK_ID SEGMENT_NAME
---------- ---------------
         9 REGIONS
        17 REG_ID_PK