1. 顯示當前目錄pwd

2 遠程復制scp ics20140902_0200.DMP Oracle@10.10.16.40:./hpdata

3 重啟數(shù)據(jù)庫lsnrctl stop;--監(jiān)聽服務(wù)停止shutdown immediate;startup;

4 進入Oraclesqlplus "/as sysdba"

5 刪用戶SQL>drop user hlj cascade;

6 建用戶SQL>create user hlj identified by hlj default tablespace users;SQL>grant resource to hlj;SQL>grant connect to hlj;SQL>grant dba to hlj;

7 建目錄SQL>create directory HLJDIR as '/home/oracle/hpdata';SQL>Grant read,write on directory DUMPDIR to lh;

--讀取目錄：select * from dba_directories;

8 導入庫impdp hlj/hlj DIRECTORY=DUMPDIR DUMPFILE=ics20140912_1408.DMP remap_schema=ics:hlj FULL=Y IGNORE=Y --新建數(shù)據(jù)庫impdp hlj2/hlj DIRECTORY=HLJDIR DUMPFILE=ics20140919_0820.DMP remap_schema=ics:hlj2 TABLE_EXISTS_ACTION=REPLACE --替換已存在數(shù)據(jù)庫

9 導入表imp ics/ics file=hpdm20140829_6.DMP tables=FNTACCFRZINFO

10 導出庫

expdp hlj/hlj dumpfile=hlj_141124.dmp full=n logfile=full.log directory=DUMPDIR job_name=my_job