Su –oracle

導出數(shù)據(jù)庫指令：

expdp ?YBDCS/drgs@10.10.202.135/orcl directory=DATA_PUMP_DIR ?dumpfile=YBDCS.dmp logfile=YBDCS.log schemas=YBDCS

?

?

expdp system/oracle@192.168.100.151/orcl directory= DATA_PUMP_DIR ?dumpfile= OA_0720_20160215.dmp logfile= OA_0720_20160215.log schemas= OA_0720

?

?

expdp system/oracle@192.168.100.159/orcl directory= DATA_PUMP_DIR ?dumpfile=FASP_test1_20160524.dmp logfile=FASP_test1_20160524.log schemas=FASP_test1

?

??

導入數(shù)據(jù)庫指令：

impdp YBDCS_BACK/drgs1@10.10.202.135/orcl directory=DATA_PUMP_DIR dumpfile=YBDCS.dmp ?logfile=YBDCS.log ?schemas=YBDCS remap_schema=YBDCS:YBDCS_BACK

?

create user YBDCS_BACK identified by drgs1;

grant?connect,resource,dba?to?YBDCS_BACK;

?

impdp system/oracle@192.168.100.181/orcl dumpfile=EFMIS_62_20160215.dmp directory=data_pump_dir remap_schema=EFMIS_62:EFMIS_2004 logfile=EFMIS_2004_20160215.log schemas=EFMIS_62 table_exists_action=replace transform=OID:N,SEGMENT_ATTRIBUTES:N

identified by

impdp system/oracle@192.168.100.155/orcl dumpfile= FASP_test1_20160524.dmp directory=data_pump_dir remap_schema= FASP_test1:FASP_test1 logfile= FASP_test1_20160524.log schemas= FASP_test1? table_exists_action=replace transform=OID:N,SEGMENT_ATTRIBUTES:N

?

impdp system/oracle@192.168.100.60/ltdb dumpfile=pay_150001_nm_hhq02.dmp directory=data_pump_dir remap_schema=pay_150001_nm_hhq:pay_150001mh logfile=pay_150001_nm_hhq_20161026.log schemas=pay_150001_nm_hhq table_exists_action=replace transform=OID:N,SEGMENT_ATTRIBUTES:N

?

? imp system/oracle@orcl file=/u01/app/oracle/admin/orcl/dpdump/fasp2_87-20160815.dmp log= /u01/app/oracle/admin/orcl/dpdump/fasp2_87_98.log fromuser=fasp2_87 touser=fasp2_20160908

?

?

?impdp system/oracle directory=data_pump_dir dumpfile=FASP_35_20160607.DMP logfile=FASP_35_0228.log schemas=FASP_35 remap_schema=FASP_35:FASP_35 table_exists_action=replace transform=OID:N,SEGMENT_ATTRIBUTES:N

?

?

impdp system/oracle@ltdb directory=data_pump_dir dumpfile=ODSPDM20170307.pdm,ODSPDM20160906.pdm logfile=lk_1500_0411.log schemas=fasp_1500,efmis_1500 remap_schema=mdm:mdm ?transform=oid:n,segment_attributes:n

1、Linux導入庫

新數(shù)據(jù)庫要先指定dmp導入目錄

　　winscp登陸oracle/oracle

1.sqlplus / as sysdba

2.create or replace directory dumpdir as ‘/home/oracle/dp_dir/’;

? 或create directory dp_dir as '/home/oracle/dp_dir/';

3.grant read,write on directory dumpdir to 用戶名;

??? 或grant read,write on directory dp_dir to scott;

4.quit

5.impdp system/oracle dumpfile=20140724.DMP directory=dumpdir remap_schema=olduser:newuser（olduser為導出的用戶名，newuser為你新建的用戶名）

（1）將提供的dmp文件放到oracle目錄下：/home/oracle/dp_dir?? 151目錄為/u01/app/oracle/admin/orcl/dpdump

將dmp文件由root變?yōu)閛racle

（2）創(chuàng)建新用戶，密碼、賦權限

（3）回到

目錄下

輸入導入命令：（1）或（2）

（1）impdp system/oracle（導入數(shù)據(jù)庫sys）@192.168.3.36/orcl directory=dp_dir（Linux數(shù)據(jù)庫安裝地址） dumpfile=FASP_62_2015081001.DMP（需要導入的dmp文件） logfile=FASP_62_2015081001.log（導入時生成的日志文件） schemas=FASP_62(原數(shù)據(jù)庫) remap_schema=FASP_62（原數(shù)據(jù)庫用戶）:fasp_62（現(xiàn)數(shù)據(jù)庫用戶） table_exists_action=replace transform=OID:N,SEGMENT_ATTRIBUTES:N

impdp system/oracle@192.168.5.210/orcl directory=dp_dir dumpfile=OA_0608_20150806.DMP? logfile=OA_0608_20150806.log schemas=OA_0608 remap_schema=OA_0608:oa_5100 table_exists_action=replace transform=OID:N,SEGMENT_ATTRIBUTES:N

（2） impdp system/oracle@192.168.5.210/orcl dumpfile=OA_0608_20150806.DMP directory=dp_dir remap_schema=OA_0608:oa_5100 logfile=OA_0608_20150806.log

（3）?

impdp EFMIS_8009/1@192.168.100.226/orcl directory=DATA_PUMP_DIR dumpfile=EFMIS_8009_20151125.dmpdp logfile=EFMIS_8009_20151125.log schemas=EFMIS_62 remap_schema=EFMIS_62:EFMIS_8009 transform=oid:n,segment_attributes:n

?

impdp ZQY_FASP/1@192.168.100.226/orcl directory=DATA_PUMP_DIR dumpfile=OA_8005_20151125.DMPDP logfile=ZQY_FASP20151030.log remap:schema=FASP_62:ZQY_FASP

LRM-00101: unknown parameter name 'remap:schema'

?

?

導出：Linux下導出

expdp fasp_20000/123（用戶名）@192.168.3.36/orcl directory=dp_dir （dmp文件導出后存放地址）dumpfile=fasp_2000020150812.dmp（導出的dmp文件名字） logfile=fasp_2000020150812.log schemas=fasp_20000

expdp system/oracle dumpfile=EFMIS_62_20151125.dmpdp logfile=EFMIS_62_20151125.log schemas=EFMIS_62

?

?

?

?

?

directory=dumpdir??

select * from dba_directories t;

轉載于:https://blog.51cto.com/13693838/2333710

總結

以上是生活随笔為你收集整理的oracle导入导出命令的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內容還不錯，歡迎將生活随笔推薦給好友。