Hi Calvin,<br> If your data dump file contains schemas&#39; that you are trying to import, I suggest that you use a sys user if user &#39;comari&#39; is not a sys user. <br><br>KR,<br>Loki<br><br><div class="gmail_quote">On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com">calvinebarongo@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">I initially did not have a directory i have created one in \11.1.0 called dump_dir and saved my dump and log files there i also granted read and write privelleges to user comari<br>
<br>then I run this on cmd<br><br>impdp comari/comari@comari  directory=dump_dir DUMPFILE=OMISPROD_data_20081211.dmp FULL=y LOGFILE=OMISPROD_data_20081211.log<br>

<br><br>after doing the above command i got the following<br><br><br><span style="color: rgb(51, 51, 255);">C:\&gt;impdp comari/comari@comari  directory=dump_dir DUMPFILE=OMISPROD_data_200812</span><br style="color: rgb(51, 51, 255);">

<span style="color: rgb(51, 51, 255);">11.dmp FULL=y LOGFILE=OMISPROD_data_20081211.log</span><br style="color: rgb(51, 51, 255);"><br style="color: rgb(51, 51, 255);"><span style="color: rgb(51, 51, 255);">Import: Release 11.1.0.6.0 - Production on Wednesday, 10 November, 2010 10:58:43</span><br style="color: rgb(51, 51, 255);">

<br style="color: rgb(51, 51, 255);"><br style="color: rgb(51, 51, 255);"><span style="color: rgb(51, 51, 255);">Copyright (c) 2003, 2007, Oracle.  All rights reserved.</span><br style="color: rgb(51, 51, 255);"><br style="color: rgb(51, 51, 255);">

<span style="color: rgb(51, 51, 255);">Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Produc</span><br style="color: rgb(51, 51, 255);"><span style="color: rgb(51, 51, 255);">tion</span><br style="color: rgb(51, 51, 255);">

<span style="color: rgb(51, 51, 255);">With the Partitioning, OLAP, Data Mining and Real Application Testing options</span><br style="color: rgb(51, 51, 255);"><span style="color: rgb(51, 51, 255);">ORA-39001: invalid argument value</span><br style="color: rgb(51, 51, 255);">

<span style="color: rgb(51, 51, 255);">ORA-39000: bad dump file specification</span><br style="color: rgb(51, 51, 255);"><span style="color: rgb(51, 51, 255);">ORA-31640: unable to open dump file &quot;c:\app\comari\product\11.1.0\OMISPROD_data_</span><br style="color: rgb(51, 51, 255);">

<span style="color: rgb(51, 51, 255);">20081211.dmp&quot; for read</span><br style="color: rgb(51, 51, 255);"><span style="color: rgb(51, 51, 255);">ORA-27041: unable to open file</span><br style="color: rgb(51, 51, 255);">

<span style="color: rgb(51, 51, 255);">OSD-04002: unable to open file</span><br style="color: rgb(51, 51, 255);"><span style="color: rgb(51, 51, 255);">O/S-Error: (OS 2) The system cannot find the file specified.</span><br style="color: rgb(51, 51, 255);">

<br style="color: rgb(51, 51, 255);"><br style="color: rgb(51, 51, 255);"><br style="color: rgb(51, 51, 255);"><span style="color: rgb(51, 51, 255);">C:\&gt;</span><br><br>I think we are heading somewhere thanks alot you two<div>
<div></div><div class="h5"><br>
<br><br><br><br><br><br><div class="gmail_quote">On Wed, Nov 10, 2010 at 10:25 AM, Nicholas Loki <span dir="ltr">&lt;<a href="mailto:lokimwenga@gmail.com" target="_blank">lokimwenga@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">


Hi Calvin,<br> I&#39;m with Amarjit on this one, no error shown. Also I noticed you left out the DIRECTORY option. Have you created a DIRECTORY object within your database instance and have you mapped this to an existing directory on your system. Hope this helps some.<br>



<br>BR,<br><font color="#888888">Loki</font><div><div></div><div><br><br><div class="gmail_quote">On Wed, Nov 10, 2010 at 9:59 AM, Amarjit Labhuram <span dir="ltr">&lt;<a href="mailto:amarjit.labhuram@gmail.com" target="_blank">amarjit.labhuram@gmail.com</a>&gt;</span> wrote:<br>


<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Sorry I didnt get that..what is the error you are getting?<div><br></div><div>Also looking at your import statment do you have a drive <span style="font-family: arial,sans-serif; font-size: 13px; border-collapse: collapse; color: rgb(255, 102, 0);">dE:\ </span><span style="font-family: arial,sans-serif; font-size: 13px; border-collapse: collapse;">?? and when typing the schema name and password with the tns string keep it all as one like so: </span><span style="font-family: arial,sans-serif; font-size: 13px; border-collapse: collapse; color: rgb(51, 51, 255);">comari/comari@comari </span><span style="font-family: arial,sans-serif; font-size: 13px; border-collapse: collapse;">....that is assuming the schema comari exists as in your import statment it is not indicated into which schema you are importing the dump into.</span></div>






<div><font face="arial, sans-serif"><span style="border-collapse: collapse;"><br clear="all"></span></font>Have a great day!<br><br>Warm regards,<br>Amarjit Singh Labhuram.<div><br></div>
<br><br><div class="gmail_quote"><div><div></div><div>On Wed, Nov 10, 2010 at 9:32 AM, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com" target="_blank">calvinebarongo@gmail.com</a>&gt;</span> wrote:<br>



</div></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div>


<br clear="all">Hi Techies,<br>I have tow files<br>1) OMISPROD_data_2008121<br>
.dmp<br>2) OMISPROD_data_20081211.dlog<br>
<br>inside a folder called in drive E: and my Oracle home directory is c:\app\comari\product\11.1.01\db_3<br><br>I am using the following command to import oracle datafiles .dmp into the database <br><br><span style="color: rgb(255, 102, 0);">C:\&gt;impdp comari/comari DUMPFILE=E:\OMISPROD_exp_20100622\OMISPROD_data_2008121</span><br style="color: rgb(255, 102, 0);">







<span style="color: rgb(255, 102, 0);">.dmp FULL=y LOGFILE=dE:\OMISPROD_exp_20100622\OMISPROD_data_20081211.dlog</span><br style="color: rgb(255, 102, 0);"><br><br>I am getting the following errors<br><br><span style="color: rgb(51, 51, 255);">impdp comari/comari @comari DUMPFILE=E:\OMISPROD_exp_20100622\OMISPROD_data_20081211.dmp FULL=y LOGFILE=dE:\OMISPROD_exp_20100622\OMISPROD_data_20081211.log</span><br style="color: rgb(51, 51, 255);">







<br><br>Regards<br><br><div style="text-align: right;">I have two files<br></div><font color="#888888">-- <br>Our greatest fear is not that we are inadequate,<br>but that we are powerful beyond measure.<br>It is our light, not our darkness, that frightens us.<br>







<br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> <br>
</font><br></div></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Our greatest fear is not that we are inadequate,<br>but that we are powerful beyond measure.<br>


It is our light, not our darkness, that frightens us.<br><br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> <br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>