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
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 -- 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
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
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
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
use this and let me know if it works: impdp comari/comari@comari DUMPFILE=c:\app\comari\product\11.1.01\dump_dir\ OMISPROD_data_200812 11.dmp FULL=y LOGFILE=c:\app\comari\product\11.1.01\dump_dir\ OMISPROD_data_20081211.log Have a great day! Warm regards, Amarjit Singh Labhuram. On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
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
HI Amarjit, this are find 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-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39088: file name cannot contain a path specification C:\> On Wed, Nov 10, 2010 at 11:19 AM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
use this and let me know if it works:
impdp comari/comari@comari DUMPFILE=c:\app\comari\product\11.1.01\dump_dir \OMISPROD_data_200812 11.dmp FULL=y LOGFILE=c:\app\comari\product\11.1.01\dump_dir\ OMISPROD_data_20081211.log
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
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
_______________________________________________ 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
Could you be using impdp for a file created using exp and not expdp? Could you be loading a file created from an earlier version of Oracle? (10g, for instance?) On Wed, Nov 10, 2010 at 11:40 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
HI Amarjit, this are find 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-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39088: file name cannot contain a path specification
C:\>
On Wed, Nov 10, 2010 at 11:19 AM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
use this and let me know if it works:
impdp comari/comari@comari DUMPFILE=c:\app\comari\product\11.1.01\ dump_dir\OMISPROD_data_200812 11.dmp FULL=y LOGFILE=c:\app\comari\product\11.1.01\dump_dir\ OMISPROD_data_20081211.log
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
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
_______________________________________________ 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
If you are using the datapump (expdp or impdp etc.) and you get the following errors: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39087: directory name DATA_PUMP_DIR is invalid There is no directory defined. You have to define it on the server. Choose a user with the rights to create an directory, start sqlplus and enter following command: create directory data_pump_dir as '\exphd\datapump'; for windows... create directory data_pump_dir as 'x:\exportdrive\datapump'; Have a great day! Warm regards, Amarjit Singh Labhuram. On Wed, Nov 10, 2010 at 11:40 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
HI Amarjit, this are find 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-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39088: file name cannot contain a path specification
C:\>
On Wed, Nov 10, 2010 at 11:19 AM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
use this and let me know if it works:
impdp comari/comari@comari DUMPFILE=c:\app\comari\product\11.1.01\ dump_dir\OMISPROD_data_200812 11.dmp FULL=y LOGFILE=c:\app\comari\product\11.1.01\dump_dir\ OMISPROD_data_20081211.log
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
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
_______________________________________________ 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
http://bit.ly/am2Li4 Have a great day! Warm regards, Amarjit Singh Labhuram. On Wed, Nov 10, 2010 at 11:55 AM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
If you are using the datapump (expdp or impdp etc.) and you get the following errors:
ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39087: directory name DATA_PUMP_DIR is invalid
There is no directory defined. You have to define it on the server. Choose a user with the rights to create an directory, start sqlplus and enter following command:
create directory data_pump_dir as '\exphd\datapump';
for windows...
create directory data_pump_dir as 'x:\exportdrive\datapump';
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 11:40 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
HI Amarjit, this are find 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-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39088: file name cannot contain a path specification
C:\>
On Wed, Nov 10, 2010 at 11:19 AM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
use this and let me know if it works:
impdp comari/comari@comari DUMPFILE=c:\app\comari\product\11.1.01\ dump_dir\OMISPROD_data_200812 11.dmp FULL=y LOGFILE=c:\app\comari\product\11.1.01\dump_dir\ OMISPROD_data_20081211.log
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com
wrote:
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
_______________________________________________ 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
On Wed, Nov 10, 2010 at 11:55 AM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
If you are using the datapump (expdp or impdp etc.) and you get the following errors:
ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39087: directory name DATA_PUMP_DIR is invalid
There is no directory defined. You have to define it on the server. Choose a user with the rights to create an directory, start sqlplus and enter following command:
create directory data_pump_dir as '\exphd\datapump';
for windows...
create directory data_pump_dir as 'x:\exportdrive\datapump';
After that, give yourself rights on those drives grant read, write on directory data_pump_dir to the_user Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 11:40 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
HI Amarjit, this are find 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-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39088: file name cannot contain a path specification
C:\>
On Wed, Nov 10, 2010 at 11:19 AM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
use this and let me know if it works:
impdp comari/comari@comari DUMPFILE=c:\app\comari\product\11.1.01\ dump_dir\OMISPROD_data_200812 11.dmp FULL=y LOGFILE=c:\app\comari\product\11.1.01\dump_dir\ OMISPROD_data_20081211.log
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com
wrote:
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
_______________________________________________ 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
_______________________________________________ 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
Hi Calvin, If your data dump file contains schemas' that you are trying to import, I suggest that you use a sys user if user 'comari' is not a sys user. KR, Loki On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
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
yes and also you could create the schemas beforehand. Isn't Oracle so fun..hahahahahahaha!!! Have a great day! Warm regards, Amarjit Singh Labhuram. On Wed, Nov 10, 2010 at 12:02 PM, Nicholas Loki <lokimwenga@gmail.com>wrote:
Hi Calvin, If your data dump file contains schemas' that you are trying to import, I suggest that you use a sys user if user 'comari' is not a sys user.
KR, Loki
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
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
_______________________________________________ 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
Have you tried using imp instead of impdp? imp comari@comariFILE=c:\app\comari\product\11.1.01\dump_dir\OMISPROD_data_20081211.dmp FULL=y LOG=c:\app\comari\product\11.1.01\dump_dir\OMISPROD_data_20081211.log On Wed, Nov 10, 2010 at 12:03 PM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
yes and also you could create the schemas beforehand. Isn't Oracle so fun..hahahahahahaha!!!
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 12:02 PM, Nicholas Loki <lokimwenga@gmail.com>wrote:
Hi Calvin, If your data dump file contains schemas' that you are trying to import, I suggest that you use a sys user if user 'comari' is not a sys user.
KR, Loki
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
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
_______________________________________________ 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
Hi It seems my naivety in Oracle is paying me a price, i have tried creating the directory, first on running the following SQL> create or replace directory data_pump_dir as 'c:\app\comari\product\mydir'; Directory created. then I did the following SQL> grant read on directory data_pump_dir to comari; Grant succeeded. SQL> grant write on directory data_pump_dir to comari; Grant succeeded. SQL> grant read on directory data_pump_dir to comari; Grant succeeded. SQL> grant write on directory data_pump_dir to comari; Grant succeeded. SQL> After running the data pump( am not sure how it was exported was only given the 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-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39088: file name cannot contain a path specification Regards On Wed, Nov 10, 2010 at 12:03 PM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
yes and also you could create the schemas beforehand. Isn't Oracle so fun..hahahahahahaha!!!
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 12:02 PM, Nicholas Loki <lokimwenga@gmail.com>wrote:
Hi Calvin, If your data dump file contains schemas' that you are trying to import, I suggest that you use a sys user if user 'comari' is not a sys user.
KR, Loki
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
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
_______________________________________________ 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
Try imp instead of impdp and give the output here On Wed, Nov 10, 2010 at 4:31 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi It seems my naivety in Oracle is paying me a price, i have tried creating the directory, first on running the following
SQL> create or replace directory data_pump_dir as 'c:\app\comari\product\mydir';
Directory created.
then I did the following
SQL> grant read on directory data_pump_dir to comari;
Grant succeeded.
SQL> grant write on directory data_pump_dir to comari;
Grant succeeded.
SQL> grant read on directory data_pump_dir to comari;
Grant succeeded.
SQL> grant write on directory data_pump_dir to comari;
Grant succeeded.
SQL>
After running the data pump( am not sure how it was exported was only given the
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-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39088: file name cannot contain a path specification
Regards
On Wed, Nov 10, 2010 at 12:03 PM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
yes and also you could create the schemas beforehand. Isn't Oracle so fun..hahahahahahaha!!!
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 12:02 PM, Nicholas Loki <lokimwenga@gmail.com>wrote:
Hi Calvin, If your data dump file contains schemas' that you are trying to import, I suggest that you use a sys user if user 'comari' is not a sys user.
KR, Loki
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari <calvinebarongo@gmail.com
wrote:
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
_______________________________________________ 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
Yea Calvin, imp import command might just do the trick. On Wed, Nov 10, 2010 at 4:36 PM, Mr. Lawi <mail2lawi@gmail.com> wrote:
Try imp instead of impdp and give the output here
On Wed, Nov 10, 2010 at 4:31 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi It seems my naivety in Oracle is paying me a price, i have tried creating the directory, first on running the following
SQL> create or replace directory data_pump_dir as 'c:\app\comari\product\mydir';
Directory created.
then I did the following
SQL> grant read on directory data_pump_dir to comari;
Grant succeeded.
SQL> grant write on directory data_pump_dir to comari;
Grant succeeded.
SQL> grant read on directory data_pump_dir to comari;
Grant succeeded.
SQL> grant write on directory data_pump_dir to comari;
Grant succeeded.
SQL>
After running the data pump( am not sure how it was exported was only given the
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-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39088: file name cannot contain a path specification
Regards
On Wed, Nov 10, 2010 at 12:03 PM, Amarjit Labhuram < amarjit.labhuram@gmail.com> wrote:
yes and also you could create the schemas beforehand. Isn't Oracle so fun..hahahahahahaha!!!
Have a great day!
Warm regards, Amarjit Singh Labhuram.
On Wed, Nov 10, 2010 at 12:02 PM, Nicholas Loki <lokimwenga@gmail.com>wrote:
Hi Calvin, If your data dump file contains schemas' that you are trying to import, I suggest that you use a sys user if user 'comari' is not a sys user.
KR, Loki
On Wed, Nov 10, 2010 at 11:11 AM, Calvin Omari < calvinebarongo@gmail.com> wrote:
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
_______________________________________________ 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
_______________________________________________ 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
participants (4)
-
Amarjit Labhuram -
Calvin Omari -
Mr. Lawi -
Nicholas Loki