Can't run a big query

We also ran into trouble running this query:

   select * from bern.tw_methods where methodref in ( select distinct methodref from bern.tw_methods where packageref in ( 100 ) ) 

The solution appears to be to execute:

  1) ALTER TABLESPACE "TEMP" DEFAULT STORAGE ( MAXEXTENTS UNLIMITED ); 

  2) ALTER DATABASE DATAFILE '/u01/oradata/b73/temp01.dbf' AUTOEXTEND ON NEXT 2K; 

For #2 it's been suggested using 50K. That's okay, since it's reclaimed, anyway.