Extremely Large Select Statements (HELP!!)
From: Mike Morgan <morganm_at_ecst.csuchico.edu>
Date: Sun, 03 May 1992 01:12:05 GMT
Message-ID: <1992May03.011205.21542_at_ecst.csuchico.edu>
Date: Sun, 03 May 1992 01:12:05 GMT
Message-ID: <1992May03.011205.21542_at_ecst.csuchico.edu>
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.eduReceived on Sun May 03 1992 - 03:12:05 CEST