ORACLE导入表

#!/bin/bash
cd /home/oracle/backup
impdp ami/ami directory=MY_DUMP dumpfile=S_KPI_DATA.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_S_SQL_STATS.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_SERVER_COMM_DATA.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_SOCKET_INFO.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TMNL_COMM_ANALY_STATS.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TMNL_COMM_DATA.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TMNL_COMM_DURA_STATS.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TMNL_COMM_HOUR_ANALY.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TMNL_LOGON.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TRAFFIC_AVG_STATS.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TRAFFIC_DIFF_STATS.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TRAFFIC_MONITOR.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TRAFFIC_MONITOR_DET.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TRAFFIC_PORT_STATS.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_TRAFFIC_PROTOCOL.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_U_TERMINAL_STATS.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=E_UNENCRYPTED_TMNL.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=HIS_KPI_CONFIG_PM.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=I_MASTER_ORA_DATA.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=I_MASTER_WEB_DATA.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=S_WARNING_HANDLE_INFO.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=S_WARNING_INFO.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=FULL.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=j.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=p.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=s.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=t.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=v.dmp remap_schema=ami:ami
impdp ami/ami directory=MY_DUMP dumpfile=f.dmp remap_schema=ami:ami