Imp dmp file in oracle 10g on linux

[irfankundi786]

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...]

Hi.

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

Cheers

Tim...

[irfankundi786]

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...]

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...

[irfankundi786]

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...]

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...

[irfankundi786]

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...]

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...