oracle 大数据 分页

SELECT * FROM test 
   WHERE ROWID IN (
      SELECT rid FROM (
        SELECT rid, ROWNUM AS rn FROM (
          SELECT ROWID rid FROM test
           WHERE a1 LIKE '%%'
          ORDER BY id
        ) t1 WHERE  ROWNUM<=10000
      ) t2 WHERE  rn>=9990 
    ) ORDER BY id