資源描述:
《網(wǎng)絡(luò)存儲技術(shù)數(shù)據(jù)回滾實驗報告4》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、網(wǎng)絡(luò)存儲技術(shù)課程實驗報告實驗名稱oracle數(shù)據(jù)冋滾系別網(wǎng)絡(luò)工程姓名學(xué)號班級實驗地點6302實驗日期2011-10-9評分指導(dǎo)老師張路橋同組其他成員無一、實驗內(nèi)容(含實驗原理介紹):使用oracle數(shù)據(jù)庫來進(jìn)行數(shù)據(jù)的回滾管理二、實驗?zāi)康模簩W(xué)習(xí)使用oracle數(shù)據(jù)庫用oracle數(shù)據(jù)庫進(jìn)行數(shù)據(jù)的回滾管理三、涉及實驗的相關(guān)情況介紹(包含使用軟件或?qū)嶒炘O(shè)備等情況):VMwareWorkstation,Windows2003server,oracle數(shù)據(jù)庫四、實驗結(jié)果(含程序、數(shù)據(jù)記錄及分析和實驗總結(jié)等,可附頁):登錄數(shù)據(jù)庫數(shù)據(jù)庫(?50L
2、O對話框I編輯器ConnectwdtoOracle9iEntgfpriseEditionRelease9.2.0.1.0ConnectedassystemSQL>
3、F-首先設(shè)立冋滾點,語句savepointa;執(zhí)行數(shù)據(jù)庫的各種操作;使用回滾語句rollback,完成數(shù)據(jù)的回滾;16rowsselectadSQL>savepointa;SQL>deletefromemp2;16rowsdeletadSQL>rollback;RollbackcompleteSQL>select*fromemp2;EMFNOENAMEJOBMGRHIRE
4、DATESALCOMMDEPTNO7369SMITHCLERK79021980-12-177500.00107499ALLENSALESMAN76981981-2-204600.00300.00307521WARDSALESMAN76981981-2-221250.00500.00307566JONESMANAGER78391981-4-22975.00207654MARTINSALESMAN76981981-9-281250.001400.00307698BLAKEMANAGER78391981-5-12850.00307782C
5、LARKMANAGER78391981-6-92450.00107788SCOTTANALYST75661987-4-193000.00207839KINGPRESIDENT1981-11-175000.00107844TURNERSALESMAN76981981-9-81500.000.00307876ADAMSCLERK77881987-5-231100.00207900JAMESCLERK76981981-12-3950.00307902FORDANALYST75661981-12-33000.00207934MILLERCL
6、ERK77821982-1-231300.00108888okMANAGER77821988-12-125000.0099.00201111ZHANGCLERK77821988-9-9455.45255.552016rowsselectedSQL>