Imp 00002 Error In Oracle
Contents |
Topic Error messages Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools MySQL database Real Application import file expdat dmp quit Clusters (RAC) Applications View All Enterprise and business performance management Implementing imp-00038 oracle 11g and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data
Imp-00010: Not A Valid Export File, Header Failed Verification
Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation,
Imp-00013: Only A Dba Can Import A File Exported By Another Dba
upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure imp command in oracle Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q Resolving an IMP-00002 error Sections Share this item with your network: Related Expert Q&A Problem with Oracle Repository Administration Utility – SearchOracle Can't open .dmp file – SearchOracle Can't open dump file using IMP – SearchOracle Sponsored News How DBAs Can Drive Oracle Performance With All-Flash Storage –Pure Storage The Benefits of Deduplication for Tier-1 Applications –SimpliVity See More V
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about
Oracle Imp
Stack Overflow the company Business Learn more about hiring developers or posting ads with impdp command us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is ora-39000: bad dump file specification a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error importing oracle dump up vote 2 down vote favorite 1 I am trying http://searchoracle.techtarget.com/answer/Resolving-an-IMP-00002-error to import a dump into two schema in the same oracle DB.Following a workaround to do this. I am trying to run the imp command with the INDEXFILE option to be able to modify the tablespace names in the sql. This is what I get : E:\oracle_10_2\BIN>imp atlantis/atlantis@orcl file=ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp indexfile=index.sql full=y log=imp.log Import: Release 10.2.0.1.0 - Production on Thu Mar 12 15:31:44 2009 Copyright (c) 1982, 2005, Oracle. All rights http://stackoverflow.com/questions/638091/error-importing-oracle-dump 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-00002: failed to open ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp for read Import file: EXPDAT.DMP > Looked like a file permission issue to me so I tried changing it. E:\oracle_10_2\BIN>cacls E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp /p atlantis:F Are you sure (Y/N)?y processed file: E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp E:\oracle_10_2\BIN>cacls E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp CORP\atlantis:F But the problem persists. oracle import dump share|improve this question edited Mar 12 '09 at 10:57 Ólafur Waage 50k11120174 asked Mar 12 '09 at 10:50 atlantis 1,42651932 add a comment| 1 Answer 1 active oldest votes up vote 4 down vote accepted If you are using Oracle 10g consider using new export/import tool Oracle Data Pump in which you can use REMAP_TABLESPACE parameter. Anyway, you missed the path of the exportfile (bassed on the commands fo give permissions). Then You wrote: file=ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp instead of file=E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp Then, the result export command to work is: imp atlantis/atlantis@orcl file=E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp indexfile=index.sql full=y log=imp.log share|improve this answer edited Mar 12 '09 at 11:46 answered Mar 12 '09 at 11:08 FerranB 14.4k154876 Is there an equivalent of the indexfile option for impdb command? –atlantis Mar 12 '09 at 11:30 You can use REMAP_TABLESPACE to import in diferent tablespaces. I've updated
Question Need help? Post your question and get tips & solutions from https://bytes.com/topic/oracle/answers/916721-error-imp-00002-failed-open-xyz-dmp-read a community of 418,570 IT Pros & Developers. It's quick & easy. Error: imp-00002:failed to open the xyz.dmp for read P: 2 sanuu I used the following command: imp un/pwd file=xyz.dmp FULL Y It show the following error imp-00002:failed to open the xyz.dmp for read import file:EXPDAT.DMP > what is the connectstring i in oracle need to use...in the command imp un/pwd@connectstring file=xyz.dmp FULL=Y Aug 27 '11 #1 Post Reply Share this Question 1 Reply P: 2 sanuu I got the solution with imp un/pwd file=xyz.dmp FULL=Y after copying the xyz.dmp file to the install directory..i.e directory where oracle was installed Aug 27 '11 #2 reply Message imp 00002 error Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics Getting Fatal error: Unable to read 4761 bytes Got the error message "Fatal error: Unable to read 4761 bytes" ExecuteNonQuery: Error Cannot open action query '' Bootstrapper Error-Unable to read registry value ERROR: Attempted to read or write protected memory native dll access error - Attempted to read or write protected memory Error, Collection is read only Error when open a set of rows Accessing large >2GB file succeeds fails with open/read AC2000 error on open: can't find file... Browse more Oracle Database Questions on Bytes Question stats viewed: 15916 replies: 1 date asked: Aug 27 '11 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes | Advertise on Bytes | Contact Us Sitemap | Oracle Database Answers Sitemap | Oracle Database Insights Sitemap Follow us to get the Latest Bytes Updates