Oracle 傳統 exp/imp (Data Pump 前身) 仍廣泛用於中小型資料庫邏輯備份、跨版本遷移、表結構同步。本文整理命令列模式完整參數與實戰範例。
$ORACLE_HOME/bin 在 PATH)。HOST exp ... 呼叫。exp system/manager@TEST FILE=d:/daochu.dmp FULL=Y
exp system/manager@TEST FILE=d:/daochu.dmp OWNER=(system,sys)
exp aichannel/aichannel@TESTDB2 FILE=d:/data/newsmgnt.dmp TABLES=(inner_notify,notify_staff_relat)
exp system/manager@TEST FILE=d:/daochu.dmp TABLES=(table1) QUERY=\"WHERE filed1 LIKE '00%'\"
\",Linux 用 ' 包裹整個參數。exp ... COMPRESS=Y -- 導入時嘗試將 extent 合併為初始 extent (注意: 10g+ 預設 COMPRESS=Y)
imp system/manager@TEST FILE=d:/daochu.dmp FULL=Y
imp aichannel/aichannel@HUST FULL=Y FILE=d:/data/newsmgnt.dmp IGNORE=Y
imp system/manager@TEST FILE=d:/daochu.dmp TABLES=(table1)
-- 參數檔 import.par FROMUSER=src_schema TOUSER=target_schema ROWS=Y INDEXES=Y GRANTS=Y CONSTRAINTS=Y BUFFER=409600 FILE=/backup/exp.dmp LOG=/backup/imp.log imp PARFILE=import.par
-- SYS 執行 CREATE USER target_user IDENTIFIED BY pwd; GRANT CONNECT, RESOURCE, DBA, IMP_FULL_DATABASE, EXP_FULL_DATABASE TO target_user;
F:\Work\Oracle_Data\backup>imp userid=test/test full=y file=inner_notify.dmp Import: Release 8.1.7.0.0 - Production ... . importing AICHANNEL's objects into AICHANNEL . . importing table "INNER_NOTIFY" 4 rows imported Import terminated successfully with warnings.
expdp/impdp (並行、網路模式、可壓縮/加密)。exp/imp 已不再增強,12c+ 仍支援但建議遷移至 Data Pump。