Extremely Large Select Statements (HELP!!)

I'm executing a rather large SELECT statement in Pro*C that could return between 85,000 and 750,000 records. The trouble I run into is I keep getting ORA-01547: Failed to allocate extent of size 912 in Tablespace 'SYSTEM'. I have expanded the tablespace size to 12M and can't extend it any further due to disk space limitiations. Is there an easy way I can break this up into several smaller SELECT's?

Thanks for any information you can offer,

Mike

--
Mike Morgan
morganm_at_cscihp.ecst.csuchico.edu