1ãä½ æä½æ误ï¼è¿ä¸ªsqlï¼ä¸ç¥éä½ æä¹æ³çï¼é¾éä½ æ³å é¤TEMPè¿ä¸ªè¡¨ç©ºé´ã
2ãTEMPä¸è¬æ¯oracleé»è®¤ç临æ¶è¡¨ç©ºé´ï¼ä¸è¬ä¸å»ºè®®å é¤ï¼å 为å¯è½æç¨æ·ç¨å°è¿ä¸ªè¡¨ç©ºé´ã
3ãå¦æå é¤ï¼æ£ç¡®å
·ä½æä½æ¯ï¼
æ¾åºä½¿ç¨TEMpçç¨æ·
SELECT USERNAME,TEMPORARY_TABLESPACE FROM DBA_USERS where TEMPORARY_TABLESPACE ='TEMP';
ä¿®æ¹ä½¿ç¨è¯¥è¡¨ç©ºé´çç¨æ·çé»è®¤è¡¨ç©ºé´ï¼ä¸¾ä¾:
alter user xxx temporary tablespace 表空é´å;
设置tempdefault为é»è®¤ä¸´æ¶è¡¨ç©ºé´
alter database default temporary tablespace 表空é´å;
ç¶åç¨ä½ ååºæ¥çè¯å¥å é¤å³å¯
drop tablespace temp including contents and datafile;
4ãæ§è¡ä¸è¿°æä½åï¼ä½ çsqlæ éæ§è¡ï¼dba_XXXé½æ¯dbmsèªå¨ç»´æ¤çï¼
5ã继第åç¹ï¼ä½ æ§è¡äºè¿ä¸ªdeleteè¯å¥å°±æ¯oracleå¯å¨èªæ£åºéäºï¼å½ç¶èµ·ä¸æ¥ï¼
6ãé®é¢æ¥å¿ï¼å¤§è´ç®å½ï¼ä¾å®é
æåï¼ï¼/oracle/admin/å®ä¾å/bdump/alert_å®ä¾å.log
7ãçæ¥å¿ç»æï¼åå³å®å¦ä½å¤çï¼ä»¥éå¯oracleï¼
温馨提示:答案为网友推荐,仅供参考