其實對 Oracle 並不是太熟，結果遇到這個錯誤，只好滿臉 黑人問號.jpg
UDE-00600: 作業產生的 ORACLE 錯誤 600 ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] 使用者名稱: UDE-00005: 讀取輸入時發生非預期的檔案結尾
拜 google 大神後，找了個解法，雖然看不懂，但是趕緊記錄起來才是正道啊!!!
1. 建立新的 undo 空間
SQL> create undo tablespace undotbs2 2 datafile '/oracle/undotbs2.dbf' size 100M; Tablespace created.
2. 設置 undo 管理方式為 ’自動‘
SQL> alter system set undo_management=auto scope=spfile; System altered.
3. 設置 undotbs 為新建的undotbs2
SQL> alter system set undo_tablespace=undotbs2 scope=spfile; System altered.
4. 刪除原來損壞的undo表空間
SQL> drop tablespace undotbs02 including contents and datafiles; Tablespace dropped.
5. 重啟 oracle
SQL> startup force; ORACLE instance started. Total System Global Area 1603411968 bytes Fixed Size 2213776 bytes Variable Size 1241516144 bytes Database Buffers 352321536 bytes Redo Buffers 7360512 bytes Database mounted. Database opened.
