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

then I run this on cmd

impdp comari/comari@comari  directory=dump_dir DUMPFILE=OMISPROD_data_20081211.dmp FULL=y LOGFILE=OMISPROD_data_20081211.log


after doing the above command i got the following


C:\>impdp comari/comari@comari  directory=dump_dir DUMPFILE=OMISPROD_data_200812
11.dmp FULL=y LOGFILE=OMISPROD_data_20081211.log

Import: Release 11.1.0.6.0 - Production on Wednesday, 10 November, 2010 10:58:43


Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "c:\app\comari\product\11.1.0\OMISPROD_data_
20081211.dmp" for read
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.



C:\>

I think we are heading somewhere thanks alot you two

On Wed, Nov 10, 2010 at 10:25 AM, Nicholas Loki <lokimwenga@gmail.com> wrote:

Hi Calvin,
 I'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,
Loki

On Wed, Nov 10, 2010 at 9:59 AM, Amarjit Labhuram <amarjit.labhuram@gmail.com> wrote:

Sorry I didnt get that..what is the error you are getting?

Also looking at your import statment do you have a drive dE:\ ?? and when typing the schema name and password with the tns string keep it all as one like so: comari/comari@comari ....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.

Have a great day!

Warm regards,
Amarjit Singh Labhuram.

On Wed, Nov 10, 2010 at 9:32 AM, Calvin Omari <calvinebarongo@gmail.com> wrote:

Hi Techies,
I have tow files
1) OMISPROD_data_2008121
.dmp
2) OMISPROD_data_20081211.dlog

inside a folder called in drive E: and my Oracle home directory is c:\app\comari\product\11.1.01\db_3

I am using the following command to import oracle datafiles .dmp into the database

C:\>impdp comari/comari DUMPFILE=E:\OMISPROD_exp_20100622\OMISPROD_data_2008121
.dmp FULL=y LOGFILE=dE:\OMISPROD_exp_20100622\OMISPROD_data_20081211.dlog


I am getting the following errors

impdp comari/comari @comari DUMPFILE=E:\OMISPROD_exp_20100622\OMISPROD_data_20081211.dmp FULL=y LOGFILE=dE:\OMISPROD_exp_20100622\OMISPROD_data_20081211.log


Regards

I have two files

--
Our greatest fear is not that we are inadequate,
but that we are powerful beyond measure.
It is our light, not our darkness, that frightens us.

Calvin Omari Systems Developer/Designer
http://www.facebook.com/barongo

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

--
Our greatest fear is not that we are inadequate,
but that we are powerful beyond measure.
It is our light, not our darkness, that frightens us.

Calvin Omari Systems Developer/Designer
http://www.facebook.com/barongo

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke