| problem while Importing dmp file [message #325891] |
Mon, 09 June 2008 07:26  |
suneelvarma_27
Messages: 28
Registered: April 2008
|
Junior Member |
|
|
i am trying to import dmp file into Oracle 10g which is exported from Oracle 8i. It is giving the following error.
;;;
Import: Release 10.1.0.2.0 - Production on Monday, 09 June, 2008 17:32
Copyright (c) 2003, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "C:\dm dmp\pbk.dmp"
Pls help me..
Thanks in advance
[Updated on: Mon, 09 June 2008 07:32] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: problem while Importing dmp file [message #326036 is a reply to message #325970] |
Tue, 10 June 2008 00:14  |
suneelvarma_27
Messages: 28
Registered: April 2008
|
Junior Member |
|
|
i am using the following command to import
C:\Documents and Settings\Administrator>imp
Import: Release 10.1.0.2.0 - Production on Tue Jun 10 10:34:38 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Username: pbk
Password: ...
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Import file: EXPDAT.DMP > pbk.dmp
Enter insert buffer size (minimum is 8192) 30720> 30720
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
Pls tell me what was the problem
[Updated on: Tue, 10 June 2008 00:20] Report message to a moderator |
|
|
|
|
|
| Re: problem while Importing dmp file [message #326161 is a reply to message #326036] |
Tue, 10 June 2008 07:02 |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
| suneelvarma_27 wrote on Tue, 10 June 2008 00:14 | i am using the following command to import
C:\Documents and Settings\Administrator>imp
Import: Release 10.1.0.2.0 - Production on Tue Jun 10 10:34:38 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Username: pbk
Password: ...
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Import file: EXPDAT.DMP > pbk.dmp
Enter insert buffer size (minimum is 8192) 30720> 30720
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
Pls tell me what was the problem
|
Mention your export dump file path correctly
Import file: EXPDAT.DMP >
Regards,
Seenu
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
