Cliff的部落格

原文出處：http://www.xxlinux.com/linux/article/development/database/20060707/2489.html

Oracle 導出工具exp交互式命令行方式的使用的例子

$exp test/test123@app
Enter array fetch buffer size: 4096 > [enter]                           ==> 按 enter 至下一步
Export file: expdat.dmp > [m.dmp]                                       ==> 匯出檔名命名
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > [3]            ==> 輸入選擇 3，指定匯出 Table
Export table data (yes/no): yes > [enter]                               ==> 按 enter 至下一步
Compress extents (yes/no): yes > [enter]                                ==> 按 enter 至下一步
Export done in ZHS16GBK character set and ZHS16GBK NCHAR character set
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > [cmamenu] ==> 輸入要匯出的 Table 名稱
. . exporting table                        CMAMENU       4336 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > [enter]   ==> 離開 exp 指令
Export terminated successfully without warnings.


===