Imp 00058 Error
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 Overflow
Imp-00058 Oracle Error 12154 Encountered
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
FILE=SI_DESIGN_SETS_12Mar2015.dmp I get the result: Import: Release 11.2.0.1.0 - Production on Fri Mar 20 11:59:37 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. IMP-00058: ORACLE error 1031 encountered ORA-01031: insufficient privilegesUsername: Running this command with other dmp files has worked in the past. Any ideas on how to get past this error? oracle import oracle11g imp share|improve this question edited Mar 20 '15 at 13:34 Martin Prikryl 34.6k1549134 asked Mar 20 '15 at 12:54 Mat 758 Then the imp 00058 ora 12154 user you are logging in as is missing some privileges. –OldProgrammer Mar 20 '15 at 12:58 I got that, but I can't tell which privileges - as I said, I have been able to import other dmp files. Is there any way to limit IMP to only look at creating tables and data? –Mat Mar 20 '15 at 13:00 You were successful before connecting as the same user? Is this a full dump (which needs imp_full_database) while previous ones were schema/table dumps, perhaps? –Alex Poole Mar 20 '15 at 13:09 That could be the case, I didn't generate the dmp files. I can see if I can get that permission and try again. Do you know how I would find out if it is a full dump? –Mat Mar 20 '15 at 13:19 Sorry, I missed that was was prompting for username; so that user can't even connect properly. Can you connect to that user/pass@tns with SQL*Plus? Are you trying to connect as a privileged user maybe? –Alex Poole Mar 20 '15 at 14:26 | show 3 more comments 1 Answer 1 active oldest votes up vote 0 down vote accepted In case anyone is wondering, I managed to get them to regenerate them and bizarrely adding "FEEDBACK=1000" to the import command actually made some of the old ones work! share|improve this answer answered Apr 2 '15 at 19:23 Mat 758 add a comment| Your Answer draft saved draft discarded Sign
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 imp-00058 oracle error 1950 encountered more about Stack Overflow the company Business Learn more about hiring developers or posting imp 00058 oracle error 3135 ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and imp-00058 oracle error 904 encountered answer site for database professionals who wish 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 http://stackoverflow.com/questions/29166997/using-oracle-imp-gives-the-error-imp-00058 a question Anybody can answer The best answers 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 http://dba.stackexchange.com/questions/34468/oracle-10g-dump-file-into-oracle-11g-database if I am wrong. When I used imp with the following parameters: file=my.dmp 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% Ma
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » Working http://www.sqlservercentral.com/Forums/Topic1153418-1044-1.aspx with Oracle » IMP-00058: ORACLE error 1658 encountered on... IMP-00058: ORACLE error 1658 encountered on tablespace users -some pointers/advice needed Rate Topic Display Mode Topic Options Author Message ResenderResender Posted Wednesday, August 3, 2011 5:46 AM SSC-Addicted Group: General Forum Members Last Login: Thursday, December 3, 2015 8:16 AM Points: 465, Visits: 1,558 I'm posting this here cause on the OTN-forum I'm getting nothing but grief and oracle error no real help.I'm doing an import of quite a large database via a dmp file, one of the most frequent error is:IMP-00058: ORACLE error 1658 encounteredORA-01658:ORA-01658: unable to create INITIAL extent for segment in tablespace USERS.I've looked up this error and increased the size of my users datafile (up to maxiumum blocksize possible),still I'm getting this error.Anyone can give me a tip on what to do. 00058 oracle error Post #1153418 PaulB-TheOneAndOnlyPaulB-TheOneAndOnly Posted Saturday, August 6, 2011 12:21 PM Hall of Fame Group: General Forum Members Last Login: Tuesday, January 28, 2014 8:15 AM Points: 3,065, Visits: 4,639 Resender (8/3/2011)I'm posting this here cause on the OTN-forum I'm getting nothing but grief and no real help.I'm doing an import of quite a large database via a dmp file, one of the most frequent error is:IMP-00058: ORACLE error 1658 encounteredORA-01658:ORA-01658: unable to create INITIAL extent for segment in tablespace USERS.I've looked up this error and increased the size of my users datafile (up to maxiumum blocksize possible),still I'm getting this error.Anyone can give me a tip on what to do.Problem is lack of space on USERS tablespace.Not sure what you mean with "maximum blocksize", blocksize has nothing to do with how much you can extend a tablespace either by resizing/letting a specific datafile grow on demand OR adding a new datafile.I'll suggest to check how much is Oracle intending to allocate for such table, do to this just run a import with show=yes and rows=no parameters... search log file looking for the specific table CREATE statement, there you will find how much space is Oracle intending to allo