Home » RDBMS Server » Server Utilities » import problem in linux
import problem in linux [message #243446] Thu, 07 June 2007 05:50 Go to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
I have a database dump on windows of oracle XE. I need to import this into 10g on linux. any help on the commands will help
Re: import dump into linux [message #243456 is a reply to message #243446] Thu, 07 June 2007 06:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
imp help=yes

Transfer your file in binary mode not text one.

Regards
Michel
Re: import dump into linux [message #243461 is a reply to message #243456] Thu, 07 June 2007 06:25 Go to previous messageGo to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
how to transfer in binary mode
Re: import dump into linux [message #243464 is a reply to message #243446] Thu, 07 June 2007 06:37 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

May be I am wrong.First , how u exported by expdp or exp command? If you export by expdp then to import it.

1. Copy the dump file in Unix pc.
2. Then try this code
<code> create directory datapump1 as '<put a directory name>';
grant read , write on directory datapump1 to <user_name>;
impdp <user name>/<password> directory=datapump1 dumpfile=<dump filename>

If you export by exp command then try,
imp <username>/<password> file=<filename.dmp> FULL=yes;

[Updated on: Thu, 07 June 2007 06:41]

Report message to a moderator

import problem in linux [message #243466 is a reply to message #243446] Thu, 07 June 2007 06:43 Go to previous messageGo to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
I have exported the file from oracle 10xe server which is under windows xp platform by using the following command

exp nom/log@xe file=nom.dmp

then i want to import this file to oracle 10g server which is under linux server

i am trying to import from one of the client windows 2003 Terminal server by using following command

imp nom/log@orcl file=d:\nom.dmp full=t

but it is giving the following error:

IMP-00010: NOT AVALID EXPORT FILE,HEADER FAIL VERIFICATION
IMP-00010: IMPORT TERMINATED SUCCESSFULLY

WHAT WOULD BE THE PROBLEM?

THANKS IN ADVANCE

Re: import problem in linux [message #243467 is a reply to message #243466] Thu, 07 June 2007 06:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://www.orafaq.com/forum/t/50094/0/


U should some try to see before post new topic.Thanks.


Arju
Re: import problem in linux [message #243483 is a reply to message #243466] Thu, 07 June 2007 08:15 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
mudalimuthu wrote on Thu, 07 June 2007 07:43

imp nom/log@orcl file=d:\nom.dmp full=t



This is an invalid directory for unix.
Re: import problem in linux [message #243501 is a reply to message #243483] Thu, 07 June 2007 09:49 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
if you exported it by datapump then go with Cadot commands and if you export it by EXP then

like this
imp username/password file=/export/home/oracle/full.dmp full=yes

Re: import problem in linux [message #243527 is a reply to message #243466] Thu, 07 June 2007 11:05 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Verify you transfer in binary mode.
How to do it depends on your file transfer tool.
With ftp just use "bin" command before "get" or "put".

Regards
Michel
Previous Topic: Importing specific tables in oracle database using unix
Next Topic: Export / Import
Goto Forum:
  


Current Time: Mon Dec 05 09:05:26 CST 2016

Total time taken to generate the page: 0.10354 seconds