26.oracleocp題庫dba經(jīng)典輔助學(xué)習(xí)

1、總體目數(shù)據(jù)移課程目標(biāo)描述可用的數(shù)據(jù)遷移的方創(chuàng)建和應(yīng)用目錄對(duì)用SQL*Loader 從一個(gè)非Oracle數(shù)據(jù)庫導(dǎo)數(shù)解釋數(shù)據(jù)泵總體目數(shù)據(jù)移課程目標(biāo)描述可用的數(shù)據(jù)遷移的方創(chuàng)建和應(yīng)用目錄對(duì)用SQL*Loader 從一個(gè)非Oracle數(shù)據(jù)庫導(dǎo)數(shù)解釋數(shù)據(jù)泵的體系在Oracle數(shù)據(jù)庫之間用數(shù)據(jù)泵導(dǎo)入和導(dǎo)出數(shù)用外部表移動(dòng)數(shù)講師 1SQL*Loader: 概導(dǎo)入數(shù)據(jù)文控制文字段處丟接選挑文丟棄文日志文Oracle Directory SQLLoader Data External 創(chuàng)建目錄對(duì)12354目錄對(duì)象概數(shù)據(jù)遷移: 體系結(jié)構(gòu)概數(shù)據(jù)元數(shù)外部直接通引導(dǎo)程數(shù)據(jù)數(shù)據(jù)/元數(shù)據(jù)動(dòng)力 SQL Loader DataPu

2、mp External SQL*LoaderOverview Full Notes Page用 SQL*Loader加載數(shù)2ComparingDirectandConventional Path Loads Full Notes Page裝載方數(shù)常規(guī)加直通路徑加UsesUsesdatasavesSQL*LoaderOverview Full Notes Page用 SQL*Loader加載數(shù)2ComparingDirectandConventional Path Loads Full Notes Page裝載方數(shù)常規(guī)加直通路徑加UsesUsesdatasaves(fasterAlwaysgen

3、eratesredo Generatesredoonlyunderspecifc condtionsallconstra onlyPRIMARYKEY,UNIQUE, and NOT NULLFires INSERTDoesnotfireINSERTCanload oclustered Doesnotload oAllowsotheruserstomodify tablesduringloadPreventsotherusersfrommaking changes to tables during load operatonSQL*Loader Control File Full Notes

4、PageSQL*Loader 控制文SQL*Loader 控制文件SQL*Loader 的指示被導(dǎo)數(shù)據(jù)的位數(shù)據(jù)格配置詳細(xì)資料內(nèi)存管丟中斷處理詳細(xì)資數(shù)據(jù)操作詳細(xì)資數(shù)據(jù)泵優(yōu)數(shù)據(jù)作為服務(wù)器端高速移動(dòng)數(shù)據(jù)和元數(shù)據(jù)的工具,數(shù)據(jù)泵可以通過DBMS_DATAPUMP啟數(shù)據(jù)泵優(yōu)數(shù)據(jù)作為服務(wù)器端高速移動(dòng)數(shù)據(jù)和元數(shù)據(jù)的工具,數(shù)據(jù)泵可以通過DBMS_DATAPUMP啟提供以下工具基于Web界數(shù)據(jù)存取方法直通路對(duì)于長時(shí)間運(yùn)行的任務(wù)，取消其附屬關(guān)系并重新安排附屬關(guān)重啟數(shù)據(jù)對(duì)于導(dǎo)入工作空間需求數(shù)據(jù)采樣和元數(shù)據(jù)壓3高級(jí)特征采任務(wù): 測(cè)試數(shù)據(jù)方法: 確定來源于源數(shù)據(jù)庫抽樣和卸下的百分例如卸下44 的HR.EMPLOYEES表

5、例如卸下整個(gè)導(dǎo)出30 工作量expdphr/hrle1.dmp精細(xì)對(duì)象的 SQL LoaderData Expor l數(shù)據(jù)泵用途: 界面和模數(shù)據(jù)庫導(dǎo)出和導(dǎo)入界面命令參數(shù)文交互式命令數(shù)據(jù)庫控制文數(shù)據(jù)泵導(dǎo)出和導(dǎo)入模式全方表表空可變表空數(shù)據(jù)泵的導(dǎo)入和導(dǎo)客戶機(jī)程數(shù)據(jù)數(shù)據(jù)目數(shù)據(jù)服務(wù)器進(jìn)任數(shù)據(jù)數(shù)據(jù)轉(zhuǎn)轉(zhuǎn)主文件文件主“網(wǎng)絡(luò)模式服務(wù)器進(jìn)數(shù)據(jù)任客戶機(jī)程 SQL Loader DataPump External 數(shù)據(jù)泵文件文件位置的優(yōu)先順序 Per-file目數(shù)據(jù)泵文件文件位置的優(yōu)先順序 Per-file目4數(shù)據(jù)泵導(dǎo) SQL LoaderData Import 數(shù)據(jù)泵文件名和大計(jì)劃和運(yùn)行DataPumpFilesL

6、ocation Full Notes Page導(dǎo)出選項(xiàng)文數(shù)據(jù)泵導(dǎo)入:轉(zhuǎn)數(shù)據(jù)泵導(dǎo)入:轉(zhuǎn)同樣也可以利用TRANSFORM從表和索引中分離STORAGETABLESPACE字僅僅數(shù)據(jù)泵導(dǎo)入:轉(zhuǎn)數(shù)據(jù)泵導(dǎo)入:轉(zhuǎn)同樣也可以利用TRANSFORM從表和索引中分離STORAGETABLESPACE字僅僅STORAGE子重建數(shù)據(jù)類型的目改變放置置域和文件大利用數(shù)據(jù)文件利用表利用REMAP 5用數(shù)據(jù)泵的任數(shù)據(jù)庫直通路徑: 需要考慮的事數(shù)據(jù)泵自動(dòng)選路徑直通路外部表,如果數(shù)據(jù)包含簇在卸載和加載時(shí)的不同分?jǐn)?shù)據(jù)直通路外部數(shù)據(jù)初始化性能數(shù)據(jù)泵的性能可以被下列數(shù)據(jù)參數(shù)影響下列參數(shù)可以設(shè)置到高點(diǎn)下列參數(shù)是定義大小數(shù)據(jù)泵:性能考

7、用PARALLEL參數(shù)最大化工作總協(xié)調(diào)并行執(zhí)生成的文例如expdphr/hrFILESIZE=2G PARALLEL=3LOGFILE=dp_dir1:expfull.log SEGMENT_ATTRIBUTESSTORAGEOIDPCTSPACE:y|n|v:object REMAP_DATAFILE=外部表種使用外部用 驅(qū)動(dòng)將數(shù)外部表種使用外部用 驅(qū)動(dòng)將數(shù) 為裝載方便，你能夠合并來自不同的來源的驅(qū)動(dòng)Oracle 數(shù)據(jù)來自外部文器6總在本節(jié)課中，你學(xué)會(huì)如何描述可行的數(shù)據(jù)移動(dòng)方創(chuàng)建和使用目錄對(duì)使用SQL*Loader從非Oracle數(shù)據(jù)庫或文件加載數(shù)解釋數(shù)據(jù)泵的通用使用數(shù)據(jù)泵導(dǎo)入導(dǎo)出在Orac

8、le數(shù)據(jù)庫之間移動(dòng)數(shù)使用外部表通無關(guān)文件移動(dòng)數(shù)數(shù)據(jù)字查看外部表信息DBA| ALL|DBA| ALL|DBA| ALL|USER_TABLES和其外部表種類CREATETABLE ( TYPE ORACLE_LOADER DEFAUAC S PARAMETERS(recordsdelimitedbyfields terminated by ,missingfieldvaluesare(_name,hire_datechardate_formatdatemaskdd-LOCATION(empxt1.dat,empxt2.dat) PARALLEL REJECT LIMIT UNLIMITED;外

9、部表種類CREATETABLE_name, last_name, department_name) ANIZATION EXTERNAL(TYPEIRECTORYSELECT e.employees e, departments dWHERE e.department_id=d.department_idAND d.department_name in(Marketing, 裝表卸外部文表INSERTCREATETABLE SQL Loader DataPump External7練習(xí)7練習(xí)移動(dòng)數(shù)This practice covers the following UsingtheDataPumpExport Wizardtoselectdatabase objects to be exportedMo