ORA-1652: unable to extend temp segment by 256 in tablespace PSAPTEMP
在测试倒出时发生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博客 ” ，链接：https://blog.itpub.net/167898/viewspace-907056/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
-
博文量122
-
访问量619593
最新文章
- SAPGUI 7.30的新图标
- New SAPGUI 7.30 for Windows has been released !!
- 备份400GB文件到移动硬盘
- HP StorageWorks Enterprise Virtual Arrays - Procedure to Extend a Vdisk on HP StorageWorks Command V
- database size increase
- Java on Windows 7
- configuration SAPGUI Java
- Automatic Updates options are greyed out?
- "Error while unpacking program, code LP5. Please report to author."
- 批量查找替换excel单元格中的软回车（alt + enter）
