configuration
SQL SERVER 轉 ORACLE 標籤： Oracle 1. 透過SQL SERVER 2008 Standard版本的IMPORT/EXPORT 轉換 2. 安裝Oracle Client/設定TNS 3. Create Oracle User Account/Create Oracle Datafile 4. import data to Oracle 5. 注意事項 環境： Source: SQL Server Express 2008 R2 Target: Oracle DB 10.2.0.4 轉換Server：SQL Server 2008
backup
Oracle檔案異常資料還原(temp,redo,index,file,password,control block error) 標籤： Oracle 檔案異常資料還原(11gAW2 Cheaper6,7)： 一、Temp file error 二、REDO Log file error: 三、Index error 四、File error 五、Password file error 六、Control file error 七、Block Error Oracle Version:10g/11g Temp file error: 分可以重啟及不可以重啟兩種狀況： 可重啟：
database
https://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11257 Alert Log The alert log is an XML file that is a chronological log of database messages and errors. It is stored in the ADR and includes messages about the following: * Critical errors (incidents) * Administrative operations, such