Home » RDBMS Server » Server Utilities » problem while Importing dmp file (Oracle 10g, XP)
problem while Importing dmp file [message #325891] Mon, 09 June 2008 07:26 Go to next message
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 #325893 is a reply to message #325891] Mon, 09 June 2008 07:32 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-31619: invalid dump file "string"

Cause: Either the file was not generated by Export or it was corrupted.

Action: If the file was indeed generated by Export, report this as an Import bug and submit the export file to Oracle Customer Support.


You
invalid dump file "C:\dm dmp\pbk.dmp"
What happens if you put the pbk.dmp file into a directory which doesn't contain space in its name?
Re: problem while Importing dmp file [message #325894 is a reply to message #325893] Mon, 09 June 2008 07:34 Go to previous messageGo to next message
suneelvarma_27
Messages: 28
Registered: April 2008
Junior Member
i am importing usinig the following command
impdp username/password DIRECTORY=SUNIL DUMPFILE=PBK.DMP


SUNIL is the directory i have created as
CREATE OR REPLACE DIRECTORY SUNIL AS 'C:\dm dmp'
GRANT READ,WRITE ON DIRECTORY SUNIL TO username/password



it is giving the same error

[Updated on: Mon, 09 June 2008 07:38]

Report message to a moderator

Re: problem while Importing dmp file [message #325897 is a reply to message #325894] Mon, 09 June 2008 07:54 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
1
CREATE OR REPLACE DIRECTORY SUNIL AS 'C:\dm dmp'

Me
What happens if you put the pbk.dmp file into a directory which doesn't contain space in its name?


2
GRANT READ,WRITE ON DIRECTORY SUNIL TO username/password
What's password doing here?
Re: problem while Importing dmp file [message #325907 is a reply to message #325897] Mon, 09 June 2008 08:07 Go to previous messageGo to next message
suneelvarma_27
Messages: 28
Registered: April 2008
Junior Member
i have crated SUNIL directory as 'C:\dmdmp' now..
even though it is giving same problem..

sorry, i have written wrong there.. that is only username

[Updated on: Mon, 09 June 2008 08:09]

Report message to a moderator

Re: problem while Importing dmp file [message #325910 is a reply to message #325907] Mon, 09 June 2008 08:34 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
I am surprised no one saw this yet.

You cannot use datapump on a regular export file taken from an 8i database. There was no datapump in 8i.
Re: problem while Importing dmp file [message #325937 is a reply to message #325910] Mon, 09 June 2008 11:21 Go to previous messageGo to next message
suneelvarma_27
Messages: 28
Registered: April 2008
Junior Member
Could you please tell me the procedure how to import that 8i dmp file into Oracle 10g with detail...(along with commands)

Thanks in advance...

[Updated on: Mon, 09 June 2008 11:22]

Report message to a moderator

Re: problem while Importing dmp file [message #325942 is a reply to message #325937] Mon, 09 June 2008 11:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use imp in standard way.

Regards
Michel
Re: problem while Importing dmp file [message #325945 is a reply to message #325937] Mon, 09 June 2008 11:39 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
suneelvarma_27 wrote on Mon, 09 June 2008 09:21
Could you please tell me the procedure how to import that 8i dmp file into Oracle 10g with detail...(along with commands)

Thanks in advance...



imp help=yes

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
Re: problem while Importing dmp file [message #325949 is a reply to message #325945] Mon, 09 June 2008 11:50 Go to previous messageGo to next message
suneelvarma_27
Messages: 28
Registered: April 2008
Junior Member
Many Thanks for Quick replay...
i will try and contact if any problem occurs

[Updated on: Mon, 09 June 2008 11:50]

Report message to a moderator

Re: problem while Importing dmp file [message #325970 is a reply to message #325910] Mon, 09 June 2008 14:41 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
joy_division wrote on Mon, 09 June 2008 15:34
I am surprised no one saw this yet.

You cannot use datapump on a regular export file taken from an 8i database. There was no datapump in 8i.


./fa/450/0/ ./fa/1637/0/ ./fa/2115/0/ ./fa/3958/0/
Re: problem while Importing dmp file [message #326036 is a reply to message #325970] Tue, 10 June 2008 00:14 Go to previous messageGo to next message
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 #326052 is a reply to message #326036] Tue, 10 June 2008 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Pls tell me what was the problem

Quote:
not a valid export file

How did you get the file?

Regards
Michel
Re: problem while Importing dmp file [message #326161 is a reply to message #326036] Tue, 10 June 2008 07:02 Go to previous messageGo to next message
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
Re: problem while Importing dmp file [message #326217 is a reply to message #326161] Tue, 10 June 2008 12:58 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Incorrect. If the file could not be found you would be given an appropriate message.
This is either not an export file or it was ftp'd in ascii mode.
Re: problem while Importing dmp file [message #326220 is a reply to message #325891] Tue, 10 June 2008 13:04 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Another possibility is that the dump file was made with a higher version of Export utility.
Re: problem while Importing dmp file [message #326227 is a reply to message #326220] Tue, 10 June 2008 13:44 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If we can trust OP's first sentence, this is not the case here.

Regards
Michel
Previous Topic: EXPORT PROCEDURES,PACKAGES
Next Topic: running multiple sql loader files at once in windows (merged)
Goto Forum:
  


Current Time: Thu Dec 08 14:19:15 CST 2016

Total time taken to generate the page: 0.08935 seconds