oracle數(shù)據(jù)庫(kù)基礎(chǔ)知識(shí)(華為內(nèi)部培訓(xùn)資料)

1、課程課程IL001100ACLE數(shù)據(jù)庫(kù)基礎(chǔ)知識(shí)數(shù)據(jù)庫(kù)基礎(chǔ)知識(shí)ISSUE1.0開(kāi)心開(kāi)心Java整理整理IL001100ACLE數(shù)據(jù)庫(kù)基礎(chǔ)知識(shí)ISSUE1.0目錄ii2.4.3數(shù)據(jù)庫(kù)管理工具........................................................................................................362.5ACLE用戶及權(quán)限管理.......

2、............................................................................................362.5.1ACLE的用戶管理................................................................................................372.5.2ACLE的權(quán)限管理

3、................................................................................................382.6ACLE數(shù)據(jù)庫(kù)的備份與恢復(fù)............................................................................................392.6.1Expt轉(zhuǎn)入程

4、序.......................................................................................................402.6.2Impt轉(zhuǎn)入程序.....................................................................................................

5、..422.6.3增量卸出裝入..........................................................................................................44第3章ACLE數(shù)據(jù)庫(kù)的網(wǎng)絡(luò)應(yīng)用..................................................................................

6、.......463.1SQL產(chǎn)品介紹...............................................................................................................463.2配置客戶機(jī)服務(wù)器結(jié)構(gòu)...........................................................................

7、...........................473.2.1配置listener.a.......................................................................................................473.2.2配置tnsnames.a文件..................................................

8、.........................................48第4章常用任務(wù)示例................................................................................................................514.1如何恢復(fù)被誤刪的數(shù)據(jù)文件.......................................

9、.........................................................514.2如何殺掉吊死session.........................................................................................................514.3如何修改字符集............................

10、......................................................................................514.4如何追加表空間..................................................................................................................514.5如何加

11、大表的maxextents值..............................................................................................524.6如何查詢無(wú)效對(duì)象...................................................................................................

12、............524.7怎樣分析SQL語(yǔ)句是否用到索引.......................................................................................524.8怎樣判斷是否存在回滾段競(jìng)爭(zhēng)...................................................................................

13、..........534.9怎樣手工跟蹤函數(shù)存儲(chǔ)過(guò)程執(zhí)行情況.................................................................................544.10多種業(yè)務(wù)使用同一數(shù)據(jù)庫(kù)如何分配回滾段.........................................................................544.11怎樣倒出、

14、倒入文本數(shù)據(jù)..................................................................................................544.11.1倒出..........................................................................................................

15、..............544.11.2倒入........................................................................................................................554.12如何更新當(dāng)前數(shù)據(jù)庫(kù)日志備份方式為archive...............................................

16、....................564.13Unix環(huán)境下如何實(shí)現(xiàn)自動(dòng)備份..........................................................................................564.13.1設(shè)置運(yùn)行環(huán)境...........................................................................

17、..............................564.13.2倒出數(shù)據(jù)................................................................................................................564.13.3異地備份......................................................

18、..........................................................574.13.4啟動(dòng)備份進(jìn)程.........................................................................................................584.14怎樣分析ACLE故障...........................