Imp-00058 Oracle Error
Contents |
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 the workings and policies of this site About Us Learn more about Stack Overflow the imp-00058 imp-00000 import terminated unsuccessfully company Business Learn more about hiring developers or posting ads with us Database Administrators imp-00058 oracle error 12154 encountered Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish imp-00058 oracle error 12560 encountered to improve their database skills and learn from 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
Imp 00058 Oracle Error 1034 Encountered
are voted up and rise to the top Oracle 10g dump file into Oracle 11g database up vote 2 down vote favorite I went through this link for my answer to the same question. I was not sure if i could continue in the same link, so created a new question. Oracle 10g dump file push into Oracle 11g database Sorry if I am wrong. When I used imp with the following parameters: file=my.dmp oracle error 12154 encountered import log=my.log fromuser=myuser touser=myuser statistics=none, ignore=y, full=y I got the following errors: IMP-00058: ORACLE error 12560 encountered ORA-12560: TNS:protocol adapter error IMP-00000: Import terminated unsuccessfully Also this error message was there the procedure entry point longjmp could not be located in the dynamic link library ORAUTS.DLL The database and devsuite home are installed on Windows in two different drives. I found some references saying I should run the datapump import commands from the 11g home, with this: set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1 set ORACLE_SID=ORCL11R1 I am new to this Oracle database. Should this command be run in command prompt, since the installation is done on Windows, is it "set ORACLE_HOME"? Any suggestion on this would be welcomed. oracle import export datapump share|improve this question edited Aug 12 '14 at 13:03 Colin 't Hart 5,02082131 asked Feb 9 '13 at 11:14 lakshminarayan 1112 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote That error is most likely due to incorrect environment settings indeed, probably your PATH is mixed up too. In a command prompt, assuming that your Oracle 11g home is indeed as you posted above, run: set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1 set ORACLE_SID=ORCL11R1 set PATH=%ORACLE_HOME%\bin;%PATH% Make sure you can connect with sqlplus, then start imp. (Do consider using the expdp/impdp Data pump tools instead though. imp/exp are essentially deprecated in 11g.) sha
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 imp-00058 oracle error 12154 encountered 11g Us Learn more about Stack Overflow the company Business Learn more about hiring developers
Imp 00058 Ora 12154
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Imp-00058 Oracle Error 1950 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 Import error using oracle 10g up vote http://dba.stackexchange.com/questions/34468/oracle-10g-dump-file-into-oracle-11g-database 1 down vote favorite 1 When I am trying to import a file to a 10g database, Error message (given below) appears. Anybody can help me regarding this ? 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 sql oracle oracle10g ora-06550 share|improve this question edited May http://stackoverflow.com/questions/4040291/import-error-using-oracle-10g 19 '11 at 5:42 OMG Ponies 199k37356416 asked Oct 28 '10 at 6:16 Umair Awan 167 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Looks like it is a mismatch between the IMP version and database version. If you use the imp that is in the same oracle bin directory as the oracle executable, you may have better luck. That may mean copying the file to the database server. share|improve this answer answered May 19 '11 at 5:58 Gary Myers 28.7k33057 add a comment| up vote 0 down vote I HAVE SIMILAR SITUATION . But in my case we used to have oracle 9i and we used to use bat files to import data(database) due to client requirements we were asked to upgrade to 11gr2 and we did with no problem but when am trying to build a database from other client(we have all databases hosted on same server) i encountered 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 little bit of googling i found out as i have two oracle h
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 http://stackoverflow.com/questions/29166997/using-oracle-imp-gives-the-error-imp-00058 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping http://www.acehints.com/2012/10/fix-imp-00058-oracle-error-1950.html each other. Join them; it only takes a minute: Sign up 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 oracle error imp to import into an Oracle database. I am running the command: imp
tablespace 'USERS' Import terminated successfully with warnings. Solution Description: Imp utility is trying to create the object under the user x. But for that particular user doesn't have privilege or quota allocated on that particular tablespace (USERS). DBA has to grant sufficient space quota for that user on the particular tablespace which is mentioned in the error message. The syntax is as follows. alter user