SELECT * FROM <table> WHERE ROWID BETWEEN dbms_rowid.rowid_create(1,<object_id>,<file_number>,<block_number>,0) AND dbms_rowid.rowid_create(1,<object_id>,<file_number>,<block_number>,10000);