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