| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> oracle >> jiao ni zen yang zai Oracle shu ju ku zhong gao su dao chu / dao ru
 

jiao ni zen yang zai Oracle shu ju ku zhong gao su dao chu / dao ru

2008-10-30 08:14:24 编辑來源:互联网 评论
 
本文为【教你怎样在Oracle数据库中高速导出/导入】的拼音翻译版
  qi jin wei zhi , dao chu / dao ru gong ju ji reng shi kua duo ge ping tai zhuan yi shu ju suo xu lao dong qiang du zui xiao de shou xuan shi yong gong ju , jin guan ren men chang chang bao yuan ta su du tai man 。 dao ru zhi shi jiang mei tiao ji lu cong dao chu zhuan chu wen jian zhong du chu lai , ran hou shi yong chang jian de INSERT INTO ming ling jiang qi cha ru dao mu biao biao zhong , yin ci dao ru ke neng shi ge hen man de guo cheng , zhe yi dian bing bu rang ren gan dao chi jing 。
  jin ru Oracle Data Pump,Oracle Database 10g zhong de dao chu / dao ru gong ju bao de geng xin geng kuai de tong lei gong ju , ta bei she ji lai cheng bei di jia su zhe ge guo cheng 。
  Data Pump fan yang le zheng ge dao chu / dao ru guo cheng de che di ge xin 。 ta bu shi shi yong chang jian de SQL ming ling , er shi ying yong zhuan yong API lai yi geng kuai de duo de su du jia zai he xie zai shu ju 。 zai wo de ce shi zhong , wo kan dao dao chu xing neng bi zai zhi jie mo shi xia ti gao le 10-15 bei , dao ru guo cheng xing neng ti gao le 5 bei 。 ci wai , yu shi yong dao chu shi yong gong ju bu tong , ta huan neng gou zhi qu chu te ding lei xing de dui xiang ( ru guo cheng )。
  Data Pump dao chu
  zhe ge xin de shi yong gong ju cheng wei expdp, yi he yuan lai de dao chu exp qu fen kai 。 zai ben li zhong , wo men jiang yong Data Pump lai dao chu yi ge da biao CASES, da xiao yue wei 3GB。Data Pump zai fu wu qi duan shi yong wen jian chu li lai chuang jian he du qu wen jian ; yin ci , mu lu zuo wei wei zhi shi yong 。 zai zhe zhong qing kuang xia , wo men jiang shi yong wen jian xi tong /u02/dpdata1 lai bao cun zhuan chu wen jian 。
  create directory dpdata1 as '/u02/dpdata1';
  grant read, write on directory dpdata1 to ananda;
  
  jie xia lai , wo men jiang dao chu shu ju :
  expdp ananda/abc123 tables=CASES directory=DPDATA1
  dumpfile=expCASES.dmp job_name=CASES_EXPORT
  rang wo men lai fen xi gai ming ling de ge ge bu fen 。 yong hu ID/ kou ling zu he 、 biao he zhuan chu wen jian shen shu de yi yi shi xian er yi jian de 。 yu yuan lai de dao chu bu tong , wen jian shi zai fu wu qi ( bu shi ke hu duan ) shang chuang jian de 。 wei zhi you mu lu shen shu zhi DPDATA1 zhi ding , ta zhi xiang zhi qian chuang jian de /u02/dpdata1。 zhe ge jin cheng huan zai mu lu shen shu zhi ding de wei zhi shang chuang jian yi ge ri zhi wen jian ( tong yang zai fu wu qi shang )。 mo ren di , zhe ge jin cheng shi yong yi ge ming cheng wei DPUMP_DIR de mu lu ; yin ci ke yi chuang jian ta lai dai ti DPDATA1。
  zhu yi shang mian de shen shu job_name, zhe shi ge te shu de shen shu , zai yuan lai de dao chu zhong mei you 。 suo you de Data Pump gong zuo dou tong guo zuo ye lai wan cheng 。Data Pump zuo ye — yu DBMS zuo ye bu tong — zhi shi fu wu qi jin cheng , ta dai biao zhu jin cheng chu li shu ju 。 zhu jin cheng ( cheng wei zhu kong zhi jin cheng ) tong guo gao ji dui lie (AQ) lai xie tiao zhe xiang gong zuo ; ta tong guo zai yun xing qi nei chuang jian de yi ge te shu de biao ( cheng wei zhu biao ) lai shi xian zhe ge mu de 。 zai wo men de li zi zhong , ru guo nin zai expdp yun xing shi jian cha yong hu ANANDA de mo shi , nin jiang zhu yi dao yi ge biao CASES_EXPORT de cun zai ( dui ying shen shu job_name)。 dang expdp jie shu shi , zhe ge biao bei diu qi 。
  dao chu jian kong
  dang Data Pump Export (DPE) yun xing shi , an Control-C; ta jiang zu zhi xiao xi zai ping mu shang xian shi , dan bu ting zhi dao chu jin cheng ben shen 。 xiang fan , ta jiang xian shi DPE ti shi fu ( ru xia suo shi )。 jin cheng xian zai bei ren wei chu yu “ jiao hu shi ” mo shi :
  Export>
  zhe zhong fang fa yuan xu zai zhe ge DPE zuo ye shang shu ru ji tiao ming ling 。 yao cha kan gai yao , zai ti shi fu xia shi yong STATUS ming ling :
  Export> status
  Job:CASES_EXPORT
  Operation:EXPORT
  Mode:TABLE
  State:EXECUTING
  Degree: 1
  Job Error Count: 0
  Dump file:/u02/dpdata1/expCASES.dmp
  bytes written =2048
  Worker 1 Status:
  State:EXECUTING
  Object Schema:DWOWNER
  Object Name:CASES
  Object Type:TABLE_EXPORT/TBL_TABLE_DATA/TABLE/TABLE_DATA
  Completed Objects: 1
  Total Objects: 1
  Completed Rows: 4687818
  
  ji zhu , zhe zhi shi zhuang tai xian shi 。 dao chu zai hou tai gong zuo 。 yao ji xu zai ping mu shang cha kan xiao xi , cong Export> ti shi fu xia shi yong ming ling CONTINUE_CLIENT。
  bing xing cao zuo
  nin ke yi tong guo PARALLEL shen shu wei dao chu shi yong yi ge yi shang de xian cheng lai xian zhu di jia su zuo ye 。 mei ge xian cheng chuang jian yi ge dan du de zhuan chu wen jian , yin ci shen shu dumpfile ying dang yong you he bing xing du yi yang duo de xiang mu 。 nin ke yi zhi ding tong pei fu zuo wei wen jian ming , er bu shi xian shi di shu ru ge ge wen jian ming , li ru :
  expdp ananda/abc123 tables=CASES directory=DPDATA1
  dumpfile=expCASES_%U.dmp parallel=4 job_name=Cases_Export
  zhu yi dumpfile shen shu yong you yi ge tong pei fu %U, ta zhi shi wen jian jiang an xu yao chuang jian , ge shi jiang wei expCASES_nn.dmp, qi zhong nn cong 01 kai shi , ran hou an xu yao xiang shang zeng jia 。
  zai bing xing mo shi xia , zhuang tai ping mu jiang xian shi si ge gong zuo jin cheng 。( zai mo ren mo shi xia , zhi you yi ge jin cheng shi ke jian de 。) suo you de gong zuo jin cheng tong bu qu chu shu ju , bing zai zhuang tai ping mu shang xian shi ta men de jin du 。
  fen li fang wen shu ju wen jian he zhuan chu mu lu wen jian xi tong de shu ru / shu chu tong dao shi hen chong yao de 。 fou ze , yu wei hu Data Pump zuo ye xiang guan de kai xiao ke neng chao guo bing xing xian cheng de xiao yi , bing yin ci er jiang di xing neng 。 bing xing fang shi zhi you zai biao de shu liang duo yu bing xing zhi bing qie biao hen da shi cai shi you xiao de 。
  shu ju ku jian kong
  nin huan ke yi cong shu ju ku shi tu huo de guan yu yun xing de Data Pump zuo ye de geng duo xin xi 。 jian kong zuo ye de zhu shi tu shi DBA_DATAPUMP_JOBS, ta jiang gao su nin zai zuo ye shang you duo shao ge gong zuo jin cheng ( lie DEGREE) zai gong zuo 。 ling yi ge chong yao de shi tu shi DBA_DATAPUMP_SESSIONS, dang ta yu shang shu shi tu he V$SESSION jie he shi jiang gei chu zhu qian tai jin cheng de hui hua SID。
  select sid, serial#
  from v$session s, dba_datapump_sessions d
  where s.saddr = d.saddr;
  
  zhe tiao zhi ling xian shi qian tai jin cheng de hui hua 。 geng duo you yong de xin xi ke yi cong jing bao ri zhi zhong huo de 。 dang jin cheng qi dong shi ,MCP he gong zuo jin cheng zai jing bao ri zhi zhong xian shi ru xia :
  kupprdp:master process DM00 started with pid=23,
   OS id=20530 to execute -
  SYS.KUPM$MCP.MAIN('CASES_EXPORT', 'ANANDA');
  kupprdp:worker process DW01 started with worker
   id=1, pid=24, OS id=20532 to execute -
  SYS.KUPW$WORKER.MAIN('CASES_EXPORT', 'ANANDA');
  kupprdp:worker process DW03 started with worker
   id=2, pid=25, OS id=20534 to execute -
  SYS.KUPW$WORKER.MAIN('CASES_EXPORT', 'ANANDA');
  
  ta xian shi wei shu ju beng cao zuo qi dong de hui hua de PID。 nin ke yi yong yi xia cha xun zhao dao shi ji de SID:
  select sid, program from v$session where paddr in
  (select addr from v$process where pid in (23,24,25));
  
  PROGRAM lie jiang dui ying jing bao ri zhi wen jian zhong de ming cheng xian shi jin cheng DM ( wei zhu jin cheng ) huo DW ( wei gong zuo jin cheng )。 ru guo yi ge gong zuo jin cheng shi yong le bing xing cha xun , bi ru shuo SID 23, nin ke yi zai shi tu V$PX_SESSION zhong kan dao ta , bing ba ta zhao chu lai 。 ta jiang wei nin xian shi cong SID 23 dai biao de gong zuo jin cheng zhong yun xing de suo you bing xing cha xun hui hua :
  select sid from v$px_session where qcsid = 23;
  
  cong shi tu V$SESSION_LONGOPS zhong ke yi huo de qi ta de you yong xin xi lai yu ce wan cheng zuo ye jiang hua fei de shi jian 。
  select sid, serial#, sofar, totalwork
  from v$session_longops
  where opname = 'CASES_EXPORT'
  and sofar != totalwork;
  
  lie totalwork xian shi zong gong zuo liang , gai lie de sofar shu liang bei jia he dao dang qian de shi ke — yin er nin ke yi yong ta lai gu ji huan yao hua duo chang shi jian 。
  Data Pump dao ru
  bu guo , shu ju dao ru xing neng shi Data Pump zhen zheng chu se de di fang 。 yao dao ru xian qian dao chu de shu ju , wo men jiang shi yong
  impdp ananda/abc123 directory=dpdata1
   dumpfile=expCASES.dmp job_name=cases_import
  dao ru jin cheng de mo ren xing wei shi chuang jian biao he suo you xiang guan de dui xiang , ran hou zai biao yi cun zai shi chan sheng yi ge cuo wu 。 ru guo nin xiang ba shu ju tian jia dao yi ge xian you de biao zhong , nin ke yi zai shang shu ming ling xing zhong shi yong TABLE_EXISTS_ACTION=APPEND。
  he shi yong Data Pump dao ru yi yang , zai jin cheng zhong an Control-C jiang jin ru Date Pump Import (DPI) de jiao hu mo shi ; tong yang , ti shi fu shi Import>。
  chu li te ding dui xiang
  nin shi fou you guo zhi xu yao cong yi ge yong hu dao chu te ding de guo cheng , yi zai yi ge bu tong de shu ju ku huo yong hu zhong chong xin chuang jian zhe xie guo cheng de qing kuang ? yu chuan tong de dao chu shi yong gong ju bu tong ,Data Pump yuan xu nin zhi dao chu te ding lei xing de dui xiang 。 li ru , yi xia ming ling rang nin zhi dao chu guo cheng , er bu dao chu qi ta ren he dong xi — bu dao chu biao 、 shi tu 、 shen zhi han shu :
  expdp ananda/iclaim directory=DPDATA1
   dumpfile=expprocs.dmp include=PROCEDURE
  
  yao zhi dao chu yi xie te ding de dui xiang — bi ru shuo , han shu FUNC1 he guo cheng PROC1 — nin ke yi shi yong
  
  expdp ananda/iclaim directory=DPDATA1 dumpfile=expprocs.dmp
  include=PROCEDURE:\"=\'PROC1\'\",FUNCTION:\"=\'FUNC1\'\"
  
  zhe ge zhuan chu wen jian chong dang le yuan dui xiang de yi ge bei fen 。 nin shen zhi ke yi yong ta lai chuang jian DDL jiao ben , yi gong zhi hou shi yong 。 yi ge cheng wei SQLFILE de te shu shen shu yuan xu chuang jian DDL jiao ben wen jian 。
  
  impdp ananda/iclaim directory=DPDATA1
   dumpfile=expprocs.dmp sqlfile=procs.sql
  
  gai zhi ling zai DPDATA1 zhi ding de mu lu zhong chuang jian yi ge ming cheng wei procs.sql de wen jian , bing jiang dui xiang de jiao ben bao han zai dao chu zhuan chu wen jian zhong 。 zhe zhong fang fa bang zhu nin kuai su di zai ling yi ge mo shi zhong chuang jian yuan dui xiang 。
  li yong shen shu INCLUDE yuan xu nin cong zhuan chu wen jian zhong ding yi yao bao han huo pai chu de dui xiang 。 nin ke yi shi yong zi ju INCLUDE=TABLE:"LIKE 'TAB%'" lai jin dao chu na xie ming cheng yi TAB kai tou de biao 。 lei si di , nin ke yi shi yong jie gou INCLUDE=TABLE:"NOT LIKE 'TAB%'" lai pai chu suo you ming cheng yi TAB kai tou de biao 。 zuo wei ling yi zhong xuan ze , nin ke yi shi yong EXCLUDE shen shu lai pai chu te ding de dui xiang 。
  tong guo wai bu biao ,Data Pump huan ke yi yong lai chuan shu biao kong jian ; ta fei chang qiang da , neng gou ji shi di chong ding yi bing xing fang shi , jiang geng duo de biao tian jia dao yi ge xian you de jin cheng zhong deng deng 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
qi jin wei zhi , dao chu / dao ru gong ju ji reng shi kua duo ge ping tai zhuan yi shu ju suo xu lao dong qiang du zui xiao de shou xuan shi yong gong ju , jin guan ren men chang chang bao yuan ta su du tai man 。 dao ru zhi shi jiang mei tiao ji lu cong dao chu zhuan chu wen jian zhong du chu lai , ran hou shi yong chang jian de INSERT INTO ming ling jiang qi cha ru dao mu biao biao zhong , yin ci dao ru ke neng shi ge hen man de guo cheng , zhe yi dian bing bu rang ren gan dao chi jing 。 jin ru Oracle Data Pump,Oracle Database 10g zhong de dao chu / dao ru gong ju bao de geng xin geng kuai de tong lei gong ju , ta bei she ji lai cheng bei di jia su zhe ge guo cheng 。 Data Pump fan yang le zheng ge dao chu / dao ru guo cheng de che di ge xin 。 ta bu shi shi yong chang jian de SQL ming ling , er shi ying yong zhuan yong API lai yi geng kuai de duo de su du jia zai he xie zai shu ju 。 zai wo de ce shi zhong , wo kan dao dao chu xing neng bi zai zhi jie mo shi xia ti gao le 10-15 bei , dao ru guo cheng xing neng ti gao le 5 bei 。 ci wai , yu shi yong dao chu shi yong gong ju bu tong , ta huan neng gou zhi qu chu te ding lei xing de dui xiang ( ru guo cheng )。 Data Pump dao chu zhe ge xin de shi yong gong ju cheng wei expdp, yi he yuan lai de dao chu exp qu fen kai 。 zai ben li zhong , wo men jiang yong Data Pump lai dao chu yi ge da biao CASES, da xiao yue wei 3GB。Data Pump zai fu wu qi duan shi yong wen jian chu li lai chuang jian he du qu wen jian ; yin ci , mu lu zuo wei wei zhi shi yong 。 zai zhe zhong qing kuang xia , wo men jiang shi yong wen jian xi tong /u02/dpdata1 lai bao cun zhuan chu wen jian 。      create directory dpdata1 as '/u02/dpdata1';   grant read, write on directory dpdata1 to ananda;     jie xia lai , wo men jiang dao chu shu ju :      expdp ananda/abc123 tables=CASES directory=DPDATA1   dumpfile=expCASES.dmp job_name=CASES_EXPORT rang wo men lai fen xi gai ming ling de ge ge bu fen 。 yong hu ID/ kou ling zu he 、 biao he zhuan chu wen jian shen shu de yi yi shi xian er yi jian de 。 yu yuan lai de dao chu bu tong , wen jian shi zai fu wu qi ( bu shi ke hu duan ) shang chuang jian de 。 wei zhi you mu lu shen shu zhi DPDATA1 zhi ding , ta zhi xiang zhi qian chuang jian de /u02/dpdata1。 zhe ge jin cheng huan zai mu lu shen shu zhi ding de wei zhi shang chuang jian yi ge ri zhi wen jian ( tong yang zai fu wu qi shang )。 mo ren di , zhe ge jin cheng shi yong yi ge ming cheng wei DPUMP_DIR de mu lu ; yin ci ke yi chuang jian ta lai dai ti DPDATA1。 zhu yi shang mian de shen shu job_name, zhe shi ge te shu de shen shu , zai yuan lai de dao chu zhong mei you 。 suo you de Data Pump gong zuo dou tong guo zuo ye lai wan cheng 。Data Pump zuo ye — yu DBMS zuo ye bu tong — zhi shi fu wu qi jin cheng , ta dai biao zhu jin cheng chu li shu ju 。 zhu jin cheng ( cheng wei zhu kong zhi jin cheng ) tong guo gao ji dui lie (AQ) lai xie tiao zhe xiang gong zuo ; ta tong guo zai yun xing qi nei chuang jian de yi ge te shu de biao ( cheng wei zhu biao ) lai shi xian zhe ge mu de 。 zai wo men de li zi zhong , ru guo nin zai expdp yun xing shi jian cha yong hu ANANDA de mo shi , nin jiang zhu yi dao yi ge biao CASES_EXPORT de cun zai ( dui ying shen shu job_name)。 dang expdp jie shu shi , zhe ge biao bei diu qi 。 dao chu jian kong dang Data Pump Export (DPE) yun xing shi , an Control-C; ta jiang zu zhi xiao xi zai ping mu shang xian shi , dan bu ting zhi dao chu jin cheng ben shen 。 xiang fan , ta jiang xian shi DPE ti shi fu ( ru xia suo shi )。 jin cheng xian zai bei ren wei chu yu “ jiao hu shi ” mo shi : Export> zhe zhong fang fa yuan xu zai zhe ge DPE zuo ye shang shu ru ji tiao ming ling 。 yao cha kan gai yao , zai ti shi fu xia shi yong STATUS ming ling :      Export> status   Job:CASES_EXPORT   Operation:EXPORT               Mode:TABLE                State:EXECUTING              Degree: 1   Job Error Count: 0   Dump file:/u02/dpdata1/expCASES.dmp   bytes written = 2048      Worker 1 Status:   State:EXECUTING              Object Schema:DWOWNER   Object Name:CASES   Object Type:TABLE_EXPORT/TBL_TABLE_DATA/TABLE/TABLE_DATA   Completed Objects: 1   Total Objects: 1   Completed Rows: 4687818     ji zhu , zhe zhi shi zhuang tai xian shi 。 dao chu zai hou tai gong zuo 。 yao ji xu zai ping mu shang cha kan xiao xi , cong Export> ti shi fu xia shi yong ming ling CONTINUE_CLIENT。 bing xing cao zuo nin ke yi tong guo PARALLEL shen shu wei dao chu shi yong yi ge yi shang de xian cheng lai xian zhu di jia su zuo ye 。 mei ge xian cheng chuang jian yi ge dan du de zhuan chu wen jian , yin ci shen shu dumpfile ying dang yong you he bing xing du yi yang duo de xiang mu 。 nin ke yi zhi ding tong pei fu zuo wei wen jian ming , er bu shi xian shi di shu ru ge ge wen jian ming , li ru :      expdp ananda/abc123 tables=CASES directory=DPDATA1   dumpfile=expCASES_%U.dmp parallel=4 job_name=Cases_Export zhu yi dumpfile shen shu yong you yi ge tong pei fu %U, ta zhi shi wen jian jiang an xu yao chuang jian , ge shi jiang wei expCASES_nn.dmp, qi zhong nn cong 01 kai shi , ran hou an xu yao xiang shang zeng jia 。 zai bing xing mo shi xia , zhuang tai ping mu jiang xian shi si ge gong zuo jin cheng 。( zai mo ren mo shi xia , zhi you yi ge jin cheng shi ke jian de 。) suo you de gong zuo jin cheng tong bu qu chu shu ju , bing zai zhuang tai ping mu shang xian shi ta men de jin du 。 fen li fang wen shu ju wen jian he zhuan chu mu lu wen jian xi tong de shu ru / shu chu tong dao shi hen chong yao de 。 fou ze , yu wei hu Data Pump zuo ye xiang guan de kai xiao ke neng chao guo bing xing xian cheng de xiao yi , bing yin ci er jiang di xing neng 。 bing xing fang shi zhi you zai biao de shu liang duo yu bing xing zhi bing qie biao hen da shi cai shi you xiao de 。 shu ju ku jian kong nin huan ke yi cong shu ju ku shi tu huo de guan yu yun xing de Data Pump zuo ye de geng duo xin xi 。 jian kong zuo ye de zhu shi tu shi DBA_DATAPUMP_JOBS, ta jiang gao su nin zai zuo ye shang you duo shao ge gong zuo jin cheng ( lie DEGREE) zai gong zuo 。 ling yi ge chong yao de shi tu shi DBA_DATAPUMP_SESSIONS, dang ta yu shang shu shi tu he V$SESSION jie he shi jiang gei chu zhu qian tai jin cheng de hui hua SID。      select sid, serial#   from v$session s, dba_datapump_sessions d   where s.saddr = d.saddr;     zhe tiao zhi ling xian shi qian tai jin cheng de hui hua 。 geng duo you yong de xin xi ke yi cong jing bao ri zhi zhong huo de 。 dang jin cheng qi dong shi ,MCP he gong zuo jin cheng zai jing bao ri zhi zhong xian shi ru xia :      kupprdp:master process DM00 started with pid=23, OS id=20530 to execute -   SYS.KUPM$MCP.MAIN('CASES_EXPORT', 'ANANDA');      kupprdp:worker process DW01 started with worker id=1, pid=24, OS id=20532 to execute -   SYS.KUPW$WORKER.MAIN('CASES_EXPORT', 'ANANDA');      kupprdp:worker process DW03 started with worker id=2, pid=25, OS id=20534 to execute -   SYS.KUPW$WORKER.MAIN('CASES_EXPORT', 'ANANDA');     ta xian shi wei shu ju beng cao zuo qi dong de hui hua de PID。 nin ke yi yong yi xia cha xun zhao dao shi ji de SID:      select sid, program from v$session where paddr in   (select addr from v$process where pid in (23,24,25));     PROGRAM lie jiang dui ying jing bao ri zhi wen jian zhong de ming cheng xian shi jin cheng DM ( wei zhu jin cheng ) huo DW ( wei gong zuo jin cheng )。 ru guo yi ge gong zuo jin cheng shi yong le bing xing cha xun , bi ru shuo SID 23, nin ke yi zai shi tu V$PX_SESSION zhong kan dao ta , bing ba ta zhao chu lai 。 ta jiang wei nin xian shi cong SID 23 dai biao de gong zuo jin cheng zhong yun xing de suo you bing xing cha xun hui hua :      select sid from v$px_session where qcsid = 23;     cong shi tu V$SESSION_LONGOPS zhong ke yi huo de qi ta de you yong xin xi lai yu ce wan cheng zuo ye jiang hua fei de shi jian 。      select sid, serial#, sofar, totalwork   from v$session_longops   where opname = 'CASES_EXPORT'   and sofar != totalwork;     lie totalwork xian shi zong gong zuo liang , gai lie de sofar shu liang bei jia he dao dang qian de shi ke — yin er nin ke yi yong ta lai gu ji huan yao hua duo chang shi jian 。 Data Pump dao ru bu guo , shu ju dao ru xing neng shi Data Pump zhen zheng chu se de di fang 。 yao dao ru xian qian dao chu de shu ju , wo men jiang shi yong      impdp ananda/abc123 directory=dpdata1 dumpfile=expCASES.dmp job_name=cases_import dao ru jin cheng de mo ren xing wei shi chuang jian biao he suo you xiang guan de dui xiang , ran hou zai biao yi cun zai shi chan sheng yi ge cuo wu 。 ru guo nin xiang ba shu ju tian jia dao yi ge xian you de biao zhong , nin ke yi zai shang shu ming ling xing zhong shi yong TABLE_EXISTS_ACTION=APPEND。 he shi yong Data Pump dao ru yi yang , zai jin cheng zhong an Control-C jiang jin ru Date Pump Import (DPI) de jiao hu mo shi ; tong yang , ti shi fu shi Import>。 chu li te ding dui xiang nin shi fou you guo zhi xu yao cong yi ge yong hu dao chu te ding de guo cheng , yi zai yi ge bu tong de shu ju ku huo yong hu zhong chong xin chuang jian zhe xie guo cheng de qing kuang ? yu chuan tong de dao chu shi yong gong ju bu tong ,Data Pump yuan xu nin zhi dao chu te ding lei xing de dui xiang 。 li ru , yi xia ming ling rang nin zhi dao chu guo cheng , er bu dao chu qi ta ren he dong xi — bu dao chu biao 、 shi tu 、 shen zhi han shu :      expdp ananda/iclaim directory=DPDATA1 dumpfile=expprocs.dmp include=PROCEDURE     yao zhi dao chu yi xie te ding de dui xiang — bi ru shuo , han shu FUNC1 he guo cheng PROC1 — nin ke yi shi yong       expdp ananda/iclaim directory=DPDATA1 dumpfile=expprocs.dmp   include=PROCEDURE:\"=\'PROC1\'\",FUNCTION:\"=\'FUNC1\'\"    zhe ge zhuan chu wen jian chong dang le yuan dui xiang de yi ge bei fen 。 nin shen zhi ke yi yong ta lai chuang jian DDL jiao ben , yi gong zhi hou shi yong 。 yi ge cheng wei SQLFILE de te shu shen shu yuan xu chuang jian DDL jiao ben wen jian 。       impdp ananda/iclaim directory=DPDATA1 dumpfile=expprocs.dmp sqlfile=procs.sql    gai zhi ling zai DPDATA1 zhi ding de mu lu zhong chuang jian yi ge ming cheng wei procs.sql de wen jian , bing jiang dui xiang de jiao ben bao han zai dao chu zhuan chu wen jian zhong 。 zhe zhong fang fa bang zhu nin kuai su di zai ling yi ge mo shi zhong chuang jian yuan dui xiang 。 li yong shen shu INCLUDE yuan xu nin cong zhuan chu wen jian zhong ding yi yao bao han huo pai chu de dui xiang 。 nin ke yi shi yong zi ju INCLUDE=TABLE:"LIKE 'TAB%'" lai jin dao chu na xie ming cheng yi TAB kai tou de biao 。 lei si di , nin ke yi shi yong jie gou INCLUDE=TABLE:"NOT LIKE 'TAB%'" lai pai chu suo you ming cheng yi TAB kai tou de biao 。 zuo wei ling yi zhong xuan ze , nin ke yi shi yong EXCLUDE shen shu lai pai chu te ding de dui xiang 。 tong guo wai bu biao ,Data Pump huan ke yi yong lai chuan shu biao kong jian ; ta fei chang qiang da , neng gou ji shi di chong ding yi bing xing fang shi , jiang geng duo de biao tian jia dao yi ge xian you de jin cheng zhong deng deng 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
追忆.绯红色的审判
新竹的果子风
热裤女孩
凯宾斯基酒店随拍
金色草原
菜园小品
情人谷
广东惠州—巽寮湾的海景
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有