oracle导出命令full=n,oracle导入导出命令

Su–oracle

导出数据库指令：

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

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

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

导入数据库指令：

impdp YBDCS_BACK/drgs1@10.10.202.135/orcl directory=DATA_PUMP_DIR dumpfile=YBDCS.dmp  logfile=YBDCS.logschemas=YBDCSremap_schema=YBDCS:YBDCS_BACK

create user YBDCS_BACK identified by drgs1;

connect,resource,dba toYBDCS_BACK;

impdpsystem/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_62table_exists_action=replace transform=OID:N,SEGMENT_ATTRIBUTES:N

identified by

impdpsystem/oracle@192.168.100.155/orcl dumpfile= FASP_test1_20160524.dmpdirectory=data_pump_dir remap_schema=FASP_test1:FASP_test1logfile=FASP_test1_20160524.log schemas=FASP_test1table_exists_action=replace transform=OID:N,SEGMENT_ATTRIBUTES:N

impdpsystem/oracle@192.168.100.60/ltdb dumpfile=pay_150001_nm_hhq02.dmp directory=data_pump_dir remap_schema=pay_150001_nm_hhq:pay_150001mhlogfile=pay_150001_nm_hhq_20161026.log schemas=pay_150001_nm_hhqtable_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导入库

新数据库要先指定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变为oracle

(2)创建新用户，密码、赋权限

(3)回到

目录下

输入导入命令：(1)或(2)

(1)impdp system/oracle(导入数据库sys)@192.168.3.36/orcl directory=dp_dir(Linux数据库安装地址) dumpfile=FASP_62_2015081001.DMP(需要导入的dmp文件) logfile=FASP_62_2015081001.log(导入时生成的日志文件) schemas=FASP_62(原数据库) remap_schema=FASP_62(原数据库用户):fasp_62(现数据库用户) 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/orcldumpfile=OA_0608_20150806.DMP directory=dp_dir remap_schema=OA_0608:oa_5100logfile=OA_0608_20150806.log

(3)

impdpEFMIS_8009/1@192.168.100.226/orcl directory=DATA_PUMP_DIRdumpfile=EFMIS_8009_20151125.dmpdplogfile=EFMIS_8009_20151125.logschemas=EFMIS_62remap_schema=EFMIS_62:EFMIS_8009transform=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

directory=dumpdir

select * from dba_directories t;