Oracle import/export
import = imp, xport = exp
匯出
1: exp user/pwd file=test.dmp log=test.log owner=test
匯入
1: imp user/pwd file=test.dmp 2: imp user/pwd file=test.dmp FULL=Y 3: imp user/pwd file=test.dmp FULL=Y IGNORE=Y 4: IGNORE:Y 表明忽略表創建的過程，只是將表中的數據導入表中。 5: imp user/pwd file=test.dmp show=n buffer=2048000 ignore=Y commit=y grants=y full=y