Oracle-10g
導入 (imp) 未顯示最終報告統計/結果
我正在嘗試執行 dmp 文件的導入,但未獲得導入的最終結果。這真的很奇怪,因為我獲得了具有以下內容的非常大的文件(nohup.out 和 imp_xxx.log):
Column 98 1 Column 99 Column 100 Column 101 0 Column 102 0 Column 103 Column 104 Column 105 Column 106 0 Column 107 0
預期的:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Data Mining and Real Application Testing options Export file created by EXPORT:V10.02.01 via conventional path import done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) . importing CPEDF33's objects into CPEDF33 . . importing table "x" 0 rows imported . . importing table "x1" 0 rows imported . . importing table "x2" 0 rows imported . . importing table "x3" 2599617 rows imported . . importing table "x4" 2244766 rows imported . . importing table "x5" 1561223 rows imported . . importing table "xx5" 20 rows imported . . importing table "xx4" 1931263 rows imported . . importing table "xx3" 2167 rows imported . . importing table "xx2" 4044280 rows imported . . importing table "xx1" 4126340 rows imported . . importing table "x8" 2453 rows imported . . importing table "x7" 0 rows imported
小鬼命令:
nohup imp MINE/Hi2013* file=H_FULL_20140212.dmp log=imp_H__FULL_20140212.log FROMUSER=MINE TOUSER=MINE STATISTICS=NONE ROWS=Y IGNORE=Y &
我想您密碼中的未轉義
*
字元會導致外殼出現問題。逃脫它,你應該沒事。