This forum is currently locked. You can't register or post questions at this time. (read more)

Imp dmp file in oracle 10g on linux

All posts relating to Oracle database administration.

Moderator: Tim...

irfankundi786
Member
Posts: 7
Joined: Sun Sep 30, 2012 6:16 pm

Imp dmp file in oracle 10g on linux

Postby irfankundi786 » Tue Oct 09, 2012 4:28 pm

i installed my oralce 10g database on linux.
i copy the dmp file in /mnt/erp/file.dmp
now when i give the full=path
how i can mention the full path that is /mtn/erp/file.dmp in linux...
it is quite easy in window which is i think full='d:\Erp\file.dmp'

when i done same thin in linux that is full='/mnt/erp/file.dmp' it give file not open......
help;

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Imp dmp file in oracle 10g on linux

Postby Tim... » Tue Oct 09, 2012 5:09 pm

Hi.

The syntax is the same for both, but you must use FILE, not FULL, to identify the dump file. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

irfankundi786
Member
Posts: 7
Joined: Sun Sep 30, 2012 6:16 pm

Re: Imp dmp file in oracle 10g on linux

Postby irfankundi786 » Tue Oct 09, 2012 5:59 pm

My dmp file is in /mtn/erp/file.dmp

before executing imp i have go to that folder like cd /mnt/erp
after that i execute imp command....
please corect me...




[oracle@lnxdb erp]$ imp


Import: Release 10.2.0.1.0 - Production on Wed Oct 10 08:09:37 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Username: ftw_10oct2012

Password:


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Production
With the Partitioning, OLAP and Data Mining options


Import file: expdat.dmp > FW_LIVE_09_29_2012_12_15_26.dmp


IMP-00002: failed to open FW_LIVE_09_29_2012_12_15_26.dmp for read

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Imp dmp file in oracle 10g on linux

Postby Tim... » Tue Oct 09, 2012 6:38 pm

Hi.

Originally you said the path was "/mnt/erp/". Now you are saying it is "/mtn/erp".

You say at the start of this post the file is called "file.dmp", but in the imp utility you say it is called "FW_LIVE_09_29_2012_12_15_26.dmp". How do you expect anything to work if you can;t even make up your mind what the file location and file name actually are?

When you decide what your file is actually called, you can do something like this,

Code: Select all

imp userid=username/password file=/mnt/erp/file.dmp log=/mnt/erp/file.log.log [addiitonal parameters]


Notice the additional parameters. You will need these to determine what type of import you are doing. If you want to import the whole file contents, then this will be "full=y". The parameters are described in the manual.

http://docs.oracle.com/cd/E11882_01/ser ... m#i1021478

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

irfankundi786
Member
Posts: 7
Joined: Sun Sep 30, 2012 6:16 pm

Re: Imp dmp file in oracle 10g on linux

Postby irfankundi786 » Wed Oct 10, 2012 3:18 pm

sir.
actually i give the path as you mention as file=/mnt/erp/file.dmp
but it return the file is not opened....
i can't understand the problem...
i am logging as oracle user not root...
is there any privilage issue???
i tried to give chmod 777 /mnt/erp but it return permission not permitted error.

help....

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Imp dmp file in oracle 10g on linux

Postby Tim... » Wed Oct 10, 2012 4:58 pm

Hi.

Look at the output you pasted for the import. For the dump file, you have entered, "FW_LIVE_09_29_2012_12_15_26.dmp". The output you posted was,

Import file: expdat.dmp > FW_LIVE_09_29_2012_12_15_26.dmp


How is the import utility to know that when you've typed in "FW_LIVE_09_29_2012_12_15_26.dmp", what you really meant was, "file.dmp"?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

irfankundi786
Member
Posts: 7
Joined: Sun Sep 30, 2012 6:16 pm

Re: Imp dmp file in oracle 10g on linux

Postby irfankundi786 » Sun Oct 14, 2012 9:58 am

i change my file to file.dmp
and copy this file to /mnt/erp folder in root user.
and then i also assign the rights on the folder.but still it return not open the file for read
error imp-00002 failed to open the file

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Imp dmp file in oracle 10g on linux

Postby Tim... » Sun Oct 14, 2012 10:18 am

Hi.

Well, this message means that either the file doesn't exist, or the permissions are not correct to allow the import to see it.

I suggest you log in as the oracle user, attempt to CD into the director and LS it. If you can do that, I would expect the imp to work. If not, then your permissions are incorrect.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 4 guests