Imp 00058 Error Oracle
Contents |
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 Stack Overflow the company Business Learn more about hiring developers or posting ads with imp-00058 imp-00000 import terminated unsuccessfully us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack imp-00058 oracle error 12154 encountered Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up imp-00058 oracle error 12560 encountered Using Oracle IMP gives the error IMP-00058 up vote -1 down vote favorite I have received some data in Oracle DMP format that I am trying to use imp to import into an Oracle database. I am running the command: imp
Imp-00058: Oracle Error 1034 Encountered
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss imp-00058 oracle error 1950 encountered the workings and policies of this site About Us Learn more about
Imp 00058 Oracle Error 3135
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions
Imp-00058: Oracle Error 3135 Encountered
Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from http://stackoverflow.com/questions/29166997/using-oracle-imp-gives-the-error-imp-00058 others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Oracle error 12154 while importing DMP file up vote 2 down vote favorite My Setup I'm running Windows 7 64-bit, using Oracle DB http://dba.stackexchange.com/questions/74365/oracle-error-12154-while-importing-dmp-file 11g R2 for Windows 64-bit. I have Oracle SQL Developer Release 3.0 (4.0.2.15.21) as the GUI for my database. Question I followed the instructions from this post on how to import an Oracle .DMP file. I issued this command into the command prompt: C:\>imp sys@dev/password12345 FROMUSER=FOOADMIN TOUSER=FOOADMIN file=c:\fooadmin.dmp full=yes It then prompts me for a password in which I enter the correct one and then I receive this error: IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified IMP-00000: Import terminated unsuccessfully Actual Question: How do I fix this error and be able to import the .dmp file successfully? Or what are some steps I can head towards to potentially get this working...? My Files & What I've Done I have looked through countless posts on this same issue. My tnsnames.ora, listener.ora, & sqlnet.ora are located in this directory: C:\oracle\product\11.2.0\dbhome\NETWORK\ADMIN My connection in my tnsnames.ora file looks like this (I have also tried to put my computer name as the HOST, instead of 127.0.0.1)... DEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCO
2007 - 8:21 pm UTC Category: Database � Version: 8.1.6 Latest Followup You Asked Tom, I export a table that has the following constraints: Primary key https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:1492331695311 Unique key Check Why does an import back into the same schema with ignore=y show errors for unique and check constraints but does not show them for primary key http://www.ora00600.com/wordpress/scripts/exportimport/imp-00058/ constraints that exist also? IMP-00017: following statement failed with ORACLE error 2261: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_UK" UNIQUE ("COLUMN2") USING I" "NDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 oracle error STORAGE(INITIAL 24576 NEXT 409600 M" "INEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUP" "S 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ENABLE " IMP-00003: ORACLE error 2261 encountered ORA-02261: such unique or primary key already exists in the table IMP-00017: following statement failed with ORACLE error 2264: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_CK" CHECK (column2 > '') ENABL" 00058 oracle error "E NOVALIDATE" IMP-00003: ORACLE error 2264 encountered ORA-02264: name already used by an existing constraint About to enable constraints... Import terminated successfully with warnings. Just Curious . Thanks Peter and we said... ignore=y changes the behavior of CREATE statements. If the CREATE statement failed - no data would be imported. Ignore=y says "go ahead, import the data anyway". The failure of the ALTERS affects nothing -- the data is already imported by then, so we just "fail" them (but continue on) Reviews Write a Review ignore=y May 23, 2002 - 11:31 am UTC Reviewer: X Wang from NJ USA I use ignore=y option when I import the data. It only ignore CREATE TABLE command, but failed in CREATE TYPE command. IMP-00015: following statement failed because the object already exists: "CREATE TYPE "MYTYPE_T" TIMESTAMP '2002-02-10:16:24:15' OID 'F4CDB776D6771" "1D3AD090008C7E98428' " How can I ignore create type command? Thank you Followup May 23, 2002 - 3:31 pm UTC it didn't fail, it just keeps on going. ops$tkyte@ORA817DEV.US.ORACLE.COM> drop user a cascade; User dropped. ops$tkyte@ORA817DEV.US.ORACLE.COM> ops$tkyte@ORA81
Robert Jackson | 7 Comments UPDATE: Although these IMP-00058 errors were encountered when using a 10g and 9i client, I believe that it can also apply to other versions of Oracle where there is a mismatch between the client utilities when exporting and importing IMP-00058: ORACLE error 6550 encountered ORA-06550: line 1, column 33: PLS-00302: component ‘SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored IMP-00000: Import terminated unsuccessfully This error was encountered when exporting from a 9i database using a 10g client, and then importing into a 9i databse using the 10g client. I had to export and import using the 9i client in the end. Setting the Correct Path If you are using Windows, type PATH at the command prompt and see what the values are set to. There will most likely be multiple Oracle paths in there. For example, D:\Oracle\Ora92 and D:\Oracle\product\10.2.0\db_1, for a 9i client and a 10g one. The one which appears first will take priority over the others. You can modify which appears first on your command prompt session by copying out the path to a text file, re-arranging it so that either the 9i or 10g one appears first and then copying it back into your command prompt window, with a PATH=D:\Oracle\Ora92…..etc, etc. Making it Permanent You can also modify this parameter for the environment permanently, with the following: Click START -> right click My Computer -> Properties -> Advanced System Settings -> Environment Variables In the "System Variables" box at the bottom there is a PATH variable Click "Edit" and then change the order for which Oracle Home appears first in the list The main image of this post should help you see where you go to when changing the Windows PATH environment variable. Being Explicit If you are still unsure, you can also specify the full path whenever you invoke SQLPlus or IMP/EXP, etc. For example, my PATH variable has has D:\Oracle\Ora92 at the beginning of it but I want to use the 10g Export executable, so I would type: D:\Oracle\Product\10.2.0\db_1\BIN\EXP to invoke the export command If you would like to read more about database monitoring, have a l