在测试倒出时发生ORA-1652 ERROR,是在SAPAPPL1.LOG中 #START: 20070327015019 (EXP) ERROR: DbSlExeRead: rc = 99, table "QCMZPCED" (SQL error 1652) error message returned by DbSl: ORA-01652: unable to extend temp segment by 256 in tablespace PSAPTEMP #STOP: 20070327025836 研究一下,重启RESET帮助不行,看来得加DATAFILE,一口气将DATAFILE加倍了 ALTER TABLESPACE "PSAPTEMP" DEFAULT STORAGE ( MAXEXTENTS UNLIMITED ) ALTER TABLESPACE "PSAPTEMP" ADD DATAFILE 'g:oracleLMXsapdata1temp_5temp.data5' size 2088960 K ALTER TABLESPACE "PSAPTEMP" ADD DATAFILE 'g:oracleLMXsapdata1temp_6temp.data6' size 2088960 K ALTER TABLESPACE "PSAPTEMP" ADD DATAFILE 'g:oracleLMXsapdata1temp_7temp.data7' size 2088960 K ALTER TABLESPACE "PSAPTEMP" ADD DATAFILE 'g:oracleLMXsapdata1temp_8temp.data8' size 2088960 K[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/167898/viewspace-907056/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/167898/viewspace-907056/