oracle导入导出

 

 1.导出

exp scott/tiger@orcl file=d:\win2008.dmp tables=(T_M_WIN2008_SNMP_G,T_M_WIN2008_SNMP_ST)

2.导入

imp monitoruser/merit@229 full=y file=d:\win2008.dmp ignore=y

 

imp monitoruser/eism@253 full=y file=E:\zhwgreport.dmp ignore=y

 

 

 

exp eism0330/eism@orcl file=F:\eism_20150330.dmp full=y

 

 

imp eism0125/eism@orcl full=y file=F:\zhwdb\eism_bak_20150125.dmp

imp scott/tiger@orcl full=y file=D:\采集数据dmp文件\送测\caijiwin2008.dmp ignore=y

 

 

exp monitoruser/fjdlj_monitor@ZHWGDB file=d:\caiji.dmp0 tables=(T_M_SUSELINUX10_SSH_G,T_M_SUSELINUX11_SSH_G)

 

exp monitoruser/fjdlj_monitor@ZHWGDB file=d:\caiji.dmp1 tables=(T_M_SUN_SSH_G,T_M_UBUNTU_SSH_G,T_M_AIX5_SSH_G,T_M_ASA5505_SNMP_G,T_M_AVAYA8000_SNMP_G,T_M_BAYSTACK470_SNMP_G,T_M_BIGHAMMER6800_SNMP_G,T_M_BITWAYUF3504_SNMP_G,T_M_C2900_SNMP_G,T_M_C2918_SNMP_G)

 

exp monitoruser/fjdlj_monitor@ZHWGDB file=d:\caiji.dmp2 tables=(T_M_C2950_SNMP_G,T_M_C2960_SNMP_G,T_M_C3548_SNMP_G,T_M_C3550_SNMP_G,T_M_C3560_SNMP_G,T_M_C3750_SNMP_G,T_M_C4500_SNMP_G,T_M_C6500_SNMP_G,T_M_C7600_SNMP_G,T_M_CNEXUS7000_SNMP_G)

 

fjdlj_monitor

ZHWGDB

 

 

exp monitoruser/merit@229 file=d:\zhwg229.dmp full=y

 

 

create temporary tablespace MONITORTBSPACE tempfile '/home/oracle/MONITORTBSPACE.dbf' size 1024m autoextend on next 50m maxsize 20480m extent management local;  

 

create user monitoruser identified by eism default tablespace MONITORTSPACE temporary tablespace user_temp;

 

 

exp monitoruser/eism@orcl file=e:\zhwgreport1.dmp owner=monitoruser

 

imp eism0330/eism@eism fromuser=monitoruser touser=monitoruser file=/home/oracle/zhwgreport1.dmp

 

 

 

create tablespace MONITORTBSPACE

logging 

datafile 'E:\oracle\product\10.2.0\oradata\testserver\MONITORTBSPACE.dbf' 

size 5120m 

autoextend on 

next 50m maxsize 10240m 

extent management local;