Oracle-10g

導入 (imp) 未顯示最終報告統計/結果

  • February 13, 2014

我正在嘗試執行 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 &

我想您密碼中的未轉義*字元會導致外殼出現問題。

逃脫它,你應該沒事。

引用自:https://dba.stackexchange.com/questions/58853