OraFAQ Forum: Server Utilities » error while importing the dump file

Home » RDBMS Server » Server Utilities » error while importing the dump file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error while importing the dump file [message #245458]

Sun, 17 June 2007 10:57

sushmi
Messages: 6
Registered: May 2007

Junior Member

The dump is created by the application automatically in zip format. The application i am using is made in java. But whenever i try to use the dump i get the error. The application server runs on LINUX and the importing is made on the windows 2000 professional /XP.

This is creating a great nuisance to me. My work is halted and i am very upset as i could not get out of this problem.

whenever i try to importing the dump file using following command at cmd prompt, error is thrown :

C:\>set NLS_LANG=.WE8ISO8859P1

C:\>IMP MID_JUN_17/NEACBP@MID_200 FILE=c:\EDB1672420071830.dmp LOG=C:\IMP_NUN_1
7.LOG BUFFER=100000 FULL=Y

Import: Release 9.2.0.1.0 - Production on Sun Jun 17 21:28:47 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

Report message to a moderator

Re: error while importing the dump file [message #245463 is a reply to message #245458]

Sun, 17 June 2007 12:38

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Tranfer between platform must be done in BINARY format.

Regards
Michel

Report message to a moderator

Re: error while importing the dump file [message #245688 is a reply to message #245458]

Mon, 18 June 2007 08:50

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Additionally, by any chance, was the export done against a 10g database? You are using a 9i import which cannot read a 10g export. You need to use the 10g import command.

Report message to a moderator

Re: error while importing the dump file [message #245690 is a reply to message #245458]

Mon, 18 June 2007 09:07

sushmi
Messages: 6
Registered: May 2007

Junior Member

how to tranfer files at binary mode.
i used pendrive to tranfer the file to my system.

Report message to a moderator

Re: error while importing the dump file [message #245693 is a reply to message #245690]

Mon, 18 June 2007 09:18

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't know "pendrive", don't you have a help with it?
If not, use ftp and the "bin" command.

Regards
Michel

Report message to a moderator

Re: error while importing the dump file [message #245866 is a reply to message #245458]

Tue, 19 June 2007 01:55

vasudev_boppa2001
Messages: 11
Registered: May 2007

Junior Member

you can import db from lower to heigher version (Imp done by 9i and exp in 10g). But you can't do vice versa.
Regards
Vasu

Report message to a moderator

Re: error while importing the dump file [message #245892 is a reply to message #245866]

Tue, 19 June 2007 03:10

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

you can import db from lower to heigher version (Imp done by 9i and exp in 10g).

This is contradictory.
You can import in 10g an export from 9i.

Here we don't know the export file version but the import is done in 10g.
Maybe the problem comes from that the import program in a 9i version but not sure unless the source database was also a 10g and export with a 10g export program.

Regards
Michel

Report message to a moderator

Re: error while importing the dump file [message #246986 is a reply to message #245892]

Fri, 22 June 2007 13:57

sushmi
Messages: 6
Registered: May 2007

Junior Member

The dump files was created from Oracle 10g and the export was also tried in Oracle 10g.
Is there any way to figure out the dump is not corrupted. Is the problem is due to the corrupt dump.

Report message to a moderator

Re: error while importing the dump file [message #246989 is a reply to message #246986]

Fri, 22 June 2007 14:05

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Is the problem is due to the corrupt dump

Surely and surely comes from a non-binary transfer.
Nothing new from the first post.

Regards
Michel

Report message to a moderator

Re: error while importing the dump file [message #246991 is a reply to message #245458]

Fri, 22 June 2007 14:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>The dump files was created from Oracle 10g and the export was also tried in Oracle 10g.

Then why in the world are you using a V9.2 import utility to process V10 dump file(s)?????????????

>Import: Release 9.2.0.1.0 - Production on Sun Jun 17 21:28:47

I suspect that V9.2 import gets rather confused when asked to process a V10.2 dump file.

>Surely and surely comes from a non-binary transfer.
Or may be a different reason.

Report message to a moderator

Re: error while importing the dump file [message #246997 is a reply to message #246986]

Fri, 22 June 2007 15:04

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

sushmi wrote on Fri, 22 June 2007 14:57

The dump files was created from Oracle 10g and the export was also tried in Oracle 10g.

Maybe you should re-read all of the answers.

Report message to a moderator

Re: error while importing the dump file [message #247010 is a reply to message #245458]

Fri, 22 June 2007 16:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

 exp security/security file=security.dmp owner=security rows=no statistics=none

Export: Release 10.2.0.2.0 - Production on Fri Jun 22 14:15:13 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: table data (rows) will not be exported

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SECURITY 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SECURITY 
About to export SECURITY's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SECURITY's tables via Conventional Path ...
. . exporting table                        ACCOUNT
. . exporting table                 ACCOUNT_ACCESS
. . exporting table            ACCOUNT_ACCESS_TYPE
. . exporting table                 ACCOUNT_CONFIG
. . exporting table                 ACCOUNT_STATUS
. . exporting table                             BB
. . exporting table                         CONFIG
. . exporting table                       CUSTOMER
. . exporting table                CUSTOMER_CONFIG
. . exporting table             CUSTOMER_IP_ACCESS
. . exporting table                CUSTOMER_STATUS
. . exporting table                  CUSTOMER_TYPE
. . exporting table                         GROUPS
. . exporting table           GROUP_ACCOUNT_ACCESS
. . exporting table              GROUP_PERMISSIONS
. . exporting table          GROUP_RESOURCE_ACCESS
. . exporting table        INTERNAL_USER_CUSTOMERS
. . exporting table                  IPB_OPERATION
. . exporting table                            LOG
. . exporting table                       LOG_TYPE
. . exporting table                MANAGE_SESSIONS
. . exporting table                     MM_ACCOUNT
. . exporting table                     MOVIE_USER
. . exporting table                          PARAM
. . exporting table                     PARAM_NAME
. . exporting table                    PERMISSIONS
. . exporting table                     PLAN_TABLE
. . exporting table                        PRODUCT
. . exporting table                 PRODUCT_ACCESS
. . exporting table            PRODUCT_ACCESS_TYPE
. . exporting table                      RESOURCES
. . exporting table                RESOURCE_ACCESS
. . exporting table           RESOURCE_ACCESS_TYPE
. . exporting table                       SESSIONS
. . exporting table                  TYPE_6_BACKUP
. . exporting table                          USERS
. . exporting table            USER_ACCOUNT_ACCESS
. . exporting table            USER_ACCOUNT_CONFIG
. . exporting table                    USER_CONFIG
. . exporting table                    USER_GROUPS
. . exporting table                     USER_LEVEL
. . exporting table          USER_PASSWORD_HISTORY
. . exporting table               USER_PERMISSIONS
. . exporting table           USER_RESOURCE_ACCESS
. . exporting table                    USER_STATUS
. . exporting table                      USER_TYPE
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

I then switch my environment to be configured for a V9.2 database

imp dbadmin/admindb file=security.dmp fromuser=security touser=security

Import: Release 9.2.0.7.0 - Production on Fri Jun 22 14:18:18 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

Please NOTE no file transfer was involved & error message is strikingly similar to OPs.

QED?

Report message to a moderator

Re: error while importing the dump file [message #254211 is a reply to message #247010]

Thu, 26 July 2007 03:12

sushmi
Messages: 6
Registered: May 2007

Junior Member

This is the same thing i did and the same error i get during the export. But my 10g oracle is installed on linux platform.
But this problem is solved when i try importing on the 10g linux on linux platform

Report message to a moderator

Re: error while importing the dump file [message #254385 is a reply to message #254211]

Thu, 26 July 2007 11:26

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

00010, 00000, "not a valid export file, header failed verification"
// *Cause:  Either the file was not generated by Export or it was corrupted.
// *Action: If the file was indeed generated by Export, report this an
//          Import bug and submit the export file to customer support.

Report message to a moderator

Previous Topic:	export Fail - only answer this if you're a lazy arrogant SOB like me
Next Topic:	Error Handling In Sql Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:32:33 CDT 2024