Onnie - 電腦世界

for oracle (from oracle client)
資料庫的滙入與滙出

1.滙出(dos command)
exp username/passwd@tns_name file=WhatYouWantToSave tables=table1(,table2,table3,...) statistics=none

2.drop(toad)
drop table1

3.滙入(dos command)
imp username/passwd@tns_name file=WhatYouHaveExpedFile tables=table1(,table2,...)