Home » RDBMS Server » Server Utilities » IMP-00010: not a valid export file, header failed verification (oracle ,12c,Windows 10 x64)
IMP-00010: not a valid export file, header failed verification [message #665306] Tue, 29 August 2017 09:24 Go to next message
osfar
Messages: 4
Registered: August 2017
Junior Member
hello guys how are you

i have a .DMP file which i recived Compressied by Email
i get the follwing error when i try to import it using imp tool

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

the file was created by Release 11.2.0.3.0

i tried to import it in oracle 11g and oracle 12c and i get the same error

any help please , this is a direct link for the DMP file
https: 1fichier com ?yttxrngg52
so anyone could try to import it and see the result .
Re: IMP-00010: not a valid export file, header failed verification [message #665308 is a reply to message #665306] Tue, 29 August 2017 10:20 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
That error means what it says - probably the file got corrupted at some point.
Re: IMP-00010: not a valid export file, header failed verification [message #665309 is a reply to message #665308] Tue, 29 August 2017 10:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
was file made use exp or expdp?
Re: IMP-00010: not a valid export file, header failed verification [message #665310 is a reply to message #665306] Tue, 29 August 2017 10:47 Go to previous messageGo to next message
osfar
Messages: 4
Registered: August 2017
Junior Member
this is the log file for it

;;;
Export: Release 11.2.0.3.0 - Production on Tue Jan 10 15:15:08 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_01": sys/******** AS SYSDBA directory=DATA_PUMP_DIR dumpfile=Assignment_DUMP.dmp logfile=Assignment_DUMP.log schemas=assignment
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
. . exported "ASSIGNMENT"."ACTORMOVIES" 0 KB 0 rows
. . exported "ASSIGNMENT"."ACTORS" 0 KB 0 rows
. . exported "ASSIGNMENT"."DIRECTORS" 0 KB 0 rows
. . exported "ASSIGNMENT"."MOVIES" 0 KB 0 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
C:\APP\ADMINISTRATOR\ADMIN\ASSET\DPDUMP\ASSIGNMENT_DUMP.DMP
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 15:16:03


i think it was created by exp
Re: IMP-00010: not a valid export file, header failed verification [message #665311 is a reply to message #665310] Tue, 29 August 2017 10:49 Go to previous messageGo to next message
osfar
Messages: 4
Registered: August 2017
Junior Member
and this is the link for the DMP file

https://1fichier.com/?yttxrngg52
Re: IMP-00010: not a valid export file, header failed verification [message #665312 is a reply to message #665311] Tue, 29 August 2017 10:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i think it was created by exp
You think wrongly.
exp does NOT have any DIRECTORY= parameter

[oracle@vbgeneric ~]$ exp help=yes

Export: Release 12.2.0.1.0 - Production on Tue Aug 29 11:57:27 2017

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.



You can let Export prompt you for parameters by entering the EXP
command followed by your username/password:

     Example: EXP SCOTT/TIGER

Or, you can control how Export runs by entering the EXP command followed
by various arguments. To specify parameters, you use keywords:

     Format:  EXP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
     Example: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
               or TABLES=(T1:P1,T1:P2), if T1 is partitioned table

USERID must be the first parameter on the command line.

Keyword    Description (Default)      Keyword      Description (Default)
--------------------------------------------------------------------------
USERID     username/password          FULL         export entire file (N)
BUFFER     size of data buffer        OWNER        list of owner usernames
FILE       output files (EXPDAT.DMP)  TABLES       list of table names
COMPRESS   import into one extent (Y) RECORDLENGTH length of IO record
GRANTS     export grants (Y)          INCTYPE      incremental export type
INDEXES    export indexes (Y)         RECORD       track incr. export (Y)
DIRECT     direct path (N)            TRIGGERS     export triggers (Y)
LOG        log file of screen output  STATISTICS   analyze objects (ESTIMATE)
ROWS       export data rows (Y)       PARFILE      parameter filename
CONSISTENT cross-table consistency(N) CONSTRAINTS  export constraints (Y)

OBJECT_CONSISTENT    transaction set to read only during object export (N)
FEEDBACK             display progress every x rows (0)
FILESIZE             maximum size of each dump file
FLASHBACK_SCN        SCN used to set session snapshot back to
FLASHBACK_TIME       time used to get the SCN closest to the specified time
QUERY                select clause used to export a subset of a table
RESUMABLE            suspend when a space related error is encountered(N)
RESUMABLE_NAME       text string used to identify resumable statement
RESUMABLE_TIMEOUT    wait time for RESUMABLE 
TTS_FULL_CHECK       perform full or partial dependency check for TTS
VOLSIZE              number of bytes to write to each tape volume
TABLESPACES          list of tablespaces to export
TRANSPORT_TABLESPACE export transportable tablespace metadata (N)
TEMPLATE             template name which invokes iAS mode export

Export terminated successfully without warnings.
[oracle@vbgeneric ~]$ 

Re: IMP-00010: not a valid export file, header failed verification [message #665313 is a reply to message #665312] Tue, 29 August 2017 11:11 Go to previous messageGo to next message
osfar
Messages: 4
Registered: August 2017
Junior Member
thank you very much for this great explanation

but my problem now i don't make this DMP file
this file was sent to me as an Hiring-Assignment from a company

the problem is i can't import it
Re: IMP-00010: not a valid export file, header failed verification [message #665314 is a reply to message #665313] Tue, 29 August 2017 11:39 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
osfar wrote on Tue, 29 August 2017 09:11
thank you very much for this great explanation

but my problem now i don't make this DMP file
this file was sent to me as an Hiring-Assignment from a company

the problem is i can't import it
impdp must be used to import the data
Previous Topic: IMPDP ERROR ORA-31693: on ORACLE VIRTUAL COLUMN with Not null
Next Topic: the user data import problem in window 8
Goto Forum:
  


Current Time: Thu Mar 28 11:23:10 CDT 2024