OraFAQ Forum: Linux » Imp file in oracle 10g on linux

Home » Infrastructure » Linux » Imp file in oracle 10g on linux

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Imp file in oracle 10g on linux [message #568125]

Tue, 09 October 2012 10:54

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

I want to imp dmp file in oracle 10g on linux.
now my problem is my file is locate in /mnt/erp/erp/file.dmp
when i give the user and password then it asked for exdat.dmp>'full path'
at the path how i can mention the path that is /mnt/erp/erp/file
how.

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568127 is a reply to message #568125]

Tue, 09 October 2012 10:59

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is the file /mnt/erp/erp/file.dmp or /mnt/erp/erp/file?
Note that you can always specify your file on the command line.

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568128 is a reply to message #568127]

Tue, 09 October 2012 11:10

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

my dmp file is locate in erp folder and then i copy the erp folder in /mnt.
in window it is easy as we copy the full path like path='mnt/erp/erp/file.dmp'
but how i can do this in linux to access dmp file to imp...

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568129 is a reply to message #568128]

Tue, 09 October 2012 11:46

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The same way?
I don't understand your problem can you explain it with more details?

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568130 is a reply to message #568125]

Tue, 09 October 2012 11:58

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

dear sir..
when i login to user and giver paswword after that it want the path
thats is full='/mnt/erp/file.dmp'
it return erro that failed to opened the file...
please check the sytax of path is corect in linux???

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568131 is a reply to message #568130]

Tue, 09 October 2012 12:02

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste what you did and got.

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568133 is a reply to message #568131]

Tue, 09 October 2012 12:19

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

[root@lnxdb tmp]# tar zxpf /mnt/cdrom/VMware-workstation-full-7.0.0-203739.tar.gz
tar:
/mnt/cdrom/VMware-workstation-full-7.0.0-203739.tar.gz: Cannot open: No such file or directory
tar:
Error is not recoverable: exiting now
tar: Child returned status 2
tar: Error exit delayed from previous errors

[root@lnxdb tmp]#
*************************************************

[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

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568134 is a reply to message #568131]

Tue, 09 October 2012 12:23

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

Pleas consider after imp part...
which after ********************

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568136 is a reply to message #568134]

Tue, 09 October 2012 12:34

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ls -l FW_LIVE_09_29_2012_12_15_26.dmp

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568142 is a reply to message #568136]

Tue, 09 October 2012 12:51

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

ls -l FW_LIVE_09_29_2012_12_15_26.dmp
failed to open the file....error...

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568143 is a reply to message #568142]

Tue, 09 October 2012 12:53

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

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

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

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568146 is a reply to message #568143]

Tue, 09 October 2012 13:12

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to create and put your file in the directory you want before you can use imp on this file in this directory, of course, otherwise how Oracle will find the file?
And you have to take of the privileges of these directory and file to be sure that Oracle is able to read it.

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568295 is a reply to message #568125]

Wed, 10 October 2012 09:54

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

sir i have ealier mentioned that i create the folder that is name erp in /mnt folder.
now how i can giver the priveliged.
please

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568296 is a reply to message #568295]

Wed, 10 October 2012 10:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

chmod 777 /mnt/
chmod 777 /mnt/erp/

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568297 is a reply to message #568296]

Wed, 10 October 2012 10:13

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

chmod 777 /mnt/
changing the permission of /mnt/ not permitted

i login as oracle user not root...
please

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568308 is a reply to message #568297]

Wed, 10 October 2012 11:15

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So ask your sysadmin to give you the privileges on the directory you use, or use another directory.

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568311 is a reply to message #568308]

Wed, 10 October 2012 11:26

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

sir.
iam the owner of sysadmin which is root...
i want to know how i grant right to oracle user from root.
is this corect wany
chmod 777 /mnt/erp to oracle ????

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568350 is a reply to message #568311]

Thu, 11 October 2012 01:43

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which privileges do you want to grant to "oracle" on this directory?
Do you know what are the privileges on files and directories on Linux and how to set them?

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568516 is a reply to message #568296]

Sat, 13 October 2012 01:06

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

sir,

i login as root and paste this command but its not works...
i want to grant right on folder to user oracle which is created for oracle installation and my group is dba or oinstall

[root@lnxdb ~]# chown oracle.dba /mnt/erp/file.dmp

chown: cannot access `/mnt/erp/file.dmp': No such file or directory

[root@lnxdb ~]# chown oracle:dba /mnt/erp/file.dmp

chown: cannot access `/mnt/erp/file.dmp': No such file or directory

[root@lnxdb ~]#
------------------------------
please help...

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568518 is a reply to message #568516]

Sat, 13 October 2012 01:31

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ls -l /mnt/erp/file.dmp

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568522 is a reply to message #568518]

Sat, 13 October 2012 02:15

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

login as root and paste the command
ls -l /mnt/erp/file.dmp
it return
-rwxr-xr-x 1 root root 232208384 sep date /mnt/erp/file.dmp

i want to change the right and giver the full right to the user oracle....
please give the command

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568524 is a reply to message #568522]

Sat, 13 October 2012 02:21

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

To import you only need read privilege.
Post
ls -ld /mnt
ls -ld /mnt/erp

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568525 is a reply to message #568524]

Sat, 13 October 2012 02:33

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

i past your comand like
ls -ld /mnt
ls -ld /mnt/erp
after that i have log in as oracle user and try to imp but it still return error like
imp-00002 file to open the file....

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568528 is a reply to message #568525]

Sat, 13 October 2012 03:06

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste, everything.

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568540 is a reply to message #568528]

Sat, 13 October 2012 08:55

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

ls -ld /mnt
result is
drwxr-xr-x 4 root 4096 oct date /mnt

ls -ld /mnt/erp
result is

drwxrwxrwx 2 root 4096 oct date /mnt/erp

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568544 is a reply to message #568540]

Sat, 13 October 2012 09:14

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

COPY AND PASTE.

I give up.
We can't what is real and is faked in what you post.

Regards
Michel

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568546 is a reply to message #568544]

Sat, 13 October 2012 09:21

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

sir actuall my linux is installed on vmware and no vmtool is installed so it is very difficult for me to copy from vmware and past in win 7 becuase my net is on on win 7 thats whay i write the result of command.

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568547 is a reply to message #568546]

Sat, 13 October 2012 09:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

irfankundi786@yahoo.com wrote on Sat, 13 October 2012 07:21

sir actuall my linux is installed on vmware and no vmtool is installed so it is very difficult for me to copy from vmware and past in win 7 becuase my net is on on win 7 thats whay i write the result of command.

so how EXACTLY do you get the dump file into the vmware environment?
post COPY & PASTE steps so we can see what you do & how OS responds.

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568549 is a reply to message #568547]

Sat, 13 October 2012 10:29

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

I copy the dmp file to usb and paste this in /mnt/erp folder in root user ..
thats it.

Report message to a moderator

Re: Imp file in oracle 10g on linux [message #568564 is a reply to message #568547]

Sun, 14 October 2012 04:29

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

Waiting for yours expert views

Report message to a moderator

Previous Topic:	.bash_profile sourced automatically on login
Next Topic:	rpm istallation of linux RHEL 5.1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 20:18:56 CST 2024