| IMP disregards first character of commit in .dmp [message #60056] |
Mon, 12 January 2004 21:14  |
Johan Roos
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
System = Linux Rehat8 , Oracle 9.2i
Hi,
We had to migrate the DB from one Server to a nother. before we started we made an export (exp) of the entire DB just for good measure. As the dbf files are extreamly big, we had to ftp the files over to a Backup server(Windows). While the new server was setuped. One of the minor DBF files got currupted and now we are attemting to recover from the .dmp file. When importing the dmp file, imp terminates with invalid command 'OMMIT'. After looking at the content of the dmp file thet text looked like '^MCOMMIT'. Do any body have some advice?
|
|
|
|
| Re: IMP disregards first character of commit in .dmp [message #60062 is a reply to message #60056] |
Tue, 13 January 2004 02:39  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Make sure u do the ftp in BINARY mode.
or
More simpler
create an tnsservicename in the source machine so as to connect to target database. and do the import from the source machine itself
from the source machine
exp dbadmin/pass@localdb
imp dbadmin/pass@targetdb ....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
