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.