| import problem in linux [message #243446] |
Thu, 07 June 2007 05:50  |
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 #243464 is a reply to message #243446] |
Thu, 07 June 2007 06:37  |
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 |
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 #243501 is a reply to message #243483] |
Thu, 07 June 2007 09:49 |
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 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
