Oracle Error 00010
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting
Imp-00010 Not A Valid Export File Header Failed Verification 11g
StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion oracle export version parameter Excel-DB Don Burleson Blog
Impdp Oracle 11g
IMP-00010: not a valid export file tips Oracle Database Tips by Burleson Consulting January 14, 2015 Question: I exported all the tables oracle expdp in my database using exp export utility. All the tables exported successfully. I specified exp file path correctly. I tried to import the export file (called backupt.dmp) into other database using following import command: imp scott/tiger@orcl1 file=c:\backupt.dmp formuser=exa touser=scott ignore=y IMP-00010: not a valid export file, header failed verification exp command in oracle IMP-00000: Import terminated unsuccessfully I specified exp file path correctly, yet I still get this IMP-00010 error. What could have caused the export to be treated as invalid? Answer: The Oracle Oracle does note that the most common cause of the ORA-00010 invalid export file is a corrupted export file, but there are other cases that throw the ORA-00010 error message: IMP-00010: 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. If you did indeed use export (exp or expdp) to do the export, and you verified your path to the dmp file, the "IMP-00010: not a valid export file, header failed verification" error can be caused by these issues: Corru
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm http://www.dba-oracle.com/t_imp_00010_not_a_valid_export_file.htm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/getting-error-imp00010not-a-valid-export-file-header-failed-verification-4071079 Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Getting error imp-00010:not a valid export file, header failed verification ashutosh gupta asked Mar 2, 2011 | Replies (5) I have problem with import of exported DMP file into 10g. The export is made on 11g db. and I got the error imp-00010:not a valid export file,header failed verification Join this group Popular White Paper On This Topic Best Practices for SMB BI 5Replies Best Answ
Import terminated unsuccessfully The cause according to Oracle error description is “Either the file was not generated by Export or it was corrupted”. The first obvious reason might be that the file is corrupted. However, if you downloaded it correctly (using binary http://dbtricks.com/?p=60 transfer in the FTP as opposed to ASCII transfer) and you have no other reason to believe that the file is indeed corrupted. You might want to explore other options. The most common reason for this error is mismatch of IMP and EXP versions. While it should not be a problem to import a file that was created with an earlier version of EXP using a newer version of IMP, trying to use it the other way will generate the above error. In oracle error other words, you can import a file that was created with 10g version of EXP using a 9i version of IMP. If this is the case, try to export the file using a lower version of EXP or try to import the file to a higher version Database. Later you can export it again using a lower version of the EXP utility. Another reason, over looked many times, is that the file was exported using Data Pump (EXPDP not EXP) . If you oracle error 00010 are not the one who exported the file, try to restore it using the Data Pump import utility IMPDP. Since Data Pump is gaining traction and it is creating .dmp files it is possible that the dmp file in your hands was created using it. This entry was posted in Uncategorized and tagged data pump, EXP, expdp, export, IMP, impdp, import, Oracle on March 3, 2009 by Asaf Tal. Post navigation ← How to Configure the ODBC on Oracle XE Client Restart Data Pump after import errors → 2 thoughts on “Common reasons for IMP-00010 during import” Iris Berge June 2, 2009 at 8:06 pm I just ported data through exp/imp from an 11g database into a 10g. To do this I moved the 11g exp.exe file into an archive folder and then made a copy of the 10g exp.exe and all of it's supporting drivers and copied them into the $Oracle_Home\bin folder, then when I ran the 11g export it used the 10g exp headers whick will import correctly with the imp.exe from 10g. Hope this will help someone ;O) Sankar January 5, 2012 at 2:39 am What are all other supporting drivers needs to copy along with 10g exp.exe from 10g to 11g env. Leave a Reply Cancel reply Your email address will not be published. Required fields are marked * Name * Email * Website Comment You may use these HTML tags and attributes: