select * from view: ORA-3113, view's select works AND ...

select * from view where rownum>0; works:

select * from vwpcontractschargessummed
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

select count(*) from pf.vwpcontractschargessummed
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

select count(order_id) from pf.vwpcontractschargessummed
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

select order_id from pf.vwpcontractschargessummed where rownum=1;

  ORDER_ID
----------
     65303

select order_id from pf.vwpcontractschargessummed where rownum<11;

     10 rows selected.

101

     100 rows selected.

select order_id from pf.vwpcontractschargessummed
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

1001

     1000 rows selected.

10001    

     10000 rows selected.

100001

     13241 rows selected.

select * from pf.vwpcontractschargessummed where rownum<=13241;

     13241 rows selected.

select * from pf.vwpcontractschargessummed where 1=1