Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to execute an import of a dmp file an not obtaining the final results of the import. It's really weird because i obtained really big files (nohup.out and imp_xxx.log) with the following content :

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 - 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

Imp command:

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 &
share|improve this question
Are you sure it's running the Oracle import program, and not something else? What does which imp tell you (assuming you're not on Windows)? – Colin 't Hart Feb 13 '14 at 10:30
which imp tell me the following folder : /oracle/ora_10.2.0/bin/imp . Operating systems AIX (unix). – Jorge Vega Sánchez Feb 13 '14 at 10:35
I'm wondering if the "*" character in your password has done anything, as it's not escaped – Phil Feb 13 '14 at 10:41
No problem when i did the exp. And data was imported. – Jorge Vega Sánchez Feb 13 '14 at 10:43
Thanks, Phil, i changed * in password and now works fine. – Jorge Vega Sánchez Feb 13 '14 at 12:29
up vote 2 down vote accepted

I imagine the unescaped * character in your password is causing problems in the shell.

Escape it and you should be ok.

share|improve this answer
Yes, i changed it with a # character a now works fine. Thanks. – Jorge Vega Sánchez Feb 13 '14 at 16:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.