今天在日志里看到一个错误，如下：

ORA-01555 caused by SQL statement below (SQL ID: 5kn7xufxuvy28, Query Duration=1267 sec, SCN: 0x0000.027686e5):
Wed Apr  2 09:42:57 2008
SELECT
   ROWID, WEEK_ID, WEEK_DAY, MARKET_ID,
   MULTIPLE_RECORD_IND, START_HOUR, START_MINUTE,
   STATION_REPORT_SEQUENCE, STATION, STATION_CALL_LETTER,
   PARENT_PLUS_IND, BROADCAST_CHANNEL, STATION_TYPE,
   PROGRAM_NAME, PROGRAM_SHORT_NAME, PROGRAM_CODE,
   PROGRAM_TYPE, PROGRAM_NAME_IND_VIP, PROGRAM_NAME_IND_OTHER,
   PROGRAM_NAME_IND_OFF, PROGRAM_NAME_IND_WITHHELD, PROGRAM_SOURCE,
   HH_RATING_METRO_A, HUT_METRO_A, SHARE_METRO_A,
   HH_PROJECTED_METRO_A, HH_RATING_METRO_B, HUT_METRO_B,
   SHARE_METRO_B, HH_PROJECTED_METRO_B, HH_RATING_DMA_SRA,
   HUT_DMA_SRA, SHARE_DMA_SRA<89>

ORA-1555应该是与temp表空间的错误，不明白一条select也会用到temp表空间？而且这条语句也没有用order by.
整个语句就是：
SELECT
   ROWID, WEEK_ID, WEEK_DAY, MARKET_ID,
   MULTIPLE_RECORD_IND, START_HOUR, START_MINUTE,
   STATION_REPORT_SEQUENCE, STATION, STATION_CALL_LETTER,
   PARENT_PLUS_IND, BROADCAST_CHANNEL, STATION_TYPE,
   PROGRAM_NAME, PROGRAM_SHORT_NAME, PROGRAM_CODE,
   PROGRAM_TYPE, PROGRAM_NAME_IND_VIP, PROGRAM_NAME_IND_OTHER,
   PROGRAM_NAME_IND_OFF, PROGRAM_NAME_IND_WITHHELD, PROGRAM_SOURCE, ....
FROM VIP_VW.HUTPUT_2005 Tbl