Imp Error
Contents |
about this utility, refer to Oracle9i Database Utilities. IMP-00000 Import terminated unsuccessfully Cause: Import encountered an Oracle error. Action: imp-00008 unrecognized statement in the export file 10g Look up the accompanying Oracle message in the ORA message chapters imp-00008 unrecognized statement in the export file 11g of this manual, and take appropriate action. IMP-00001 respond with either string, string, RETURN or '.' imp-00058 oracle error 12154 encountered to quit Cause: An invalid response was entered. Action: Enter any of the responses shown in the message. IMP-00002 failed to open string for read Cause: Import
Imp-00058 Imp-00000 Import Terminated Unsuccessfully
failed to open the export file for reading. This message is usually followed by a device message from the operating system. Action: Take appropriate action to restore the device. IMP-00003 ORACLE error number encountered Cause: Import encountered the referenced Oracle error. Action: Look up the Oracle message in the ORA message chapters of this manual, imp-00058 oracle error 12560 encountered and take appropriate action. IMP-00004 invalid username or password Cause: An invalid username or password was specified. Action: Retry with a valid username and password. IMP-00005 all allowable logon attempts failed Cause: An attempt was repeatedly made to log on with an invalid username or password. Action: Retry with valid username and password. IMP-00006 failed to allocate memory of size number Cause: Import failed to allocate the necessary memory. Action: Decrease the import buffer size so that less memory is required, or increase the runtime memory size for Import. IMP-00007 must be a DBA to import objects to another user's account Cause: The privileges needed to import into another user's account do not exist. Only a database administrator can import into another user's account. Action: Ask the database administrator to do the import. IMP-00008 unrecognized statement in the export file: string Cause: Import did not recognize a statement in the export file. Either the export file was corrupted, or an Impo
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 imp 00058 oracle error 1034 encountered with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Imp-00058: Oracle Error 904 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
Imp 00058 Ora 12154
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 imp to import into an Oracle database. I am running the command: https://docs.oracle.com/cd/B10501_01/server.920/a96525/impus.htm imp
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 http://dba.stackexchange.com/questions/7437/oracle-imp-crashes-without-error Learn more about Stack Overflow the company Business Learn more about hiring developers or http://www.justskins.com/forums/annoying-imp-error-146882.html posting ads with us Database Administrators Questions 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 others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody oracle error can ask a question Anybody can answer The best answers are voted up and rise to the top Oracle imp crashes without error up vote 3 down vote favorite I have Oracle 10g XE database locally. I export schema with something like exp %USER%/%PASSWD%@XE statistics=NONE owner=%USER% file=dump.dmp Exp is 10.2.0.1.0 version - so is the DB. Than I take this dump to another machine and try to import 00058 oracle error it to another remote machine. With imp %USER%/%PASSWD%/'192.168.0.100/%SID%' ignore=y file=dump.dmp full=y Oracle client with imp is version 11.2.0.1.0 and Oracle DB (normal, not express) is version 11.2.0.2.0 The problem is that after printing several messages about importing tables it suddenly stops: . . importing table "TABLE_1" 17180 rows imported . . importing table "TABLE_2" 0 rows imported . . importing table "TABLE_3" 49 rows imported$: and does not even give a newline symbol in the end. The problem persists with rows=N and with only selected tables from this schema. So can anybody tell: Where can be some error logs to know what is wrong? Some workaround (still using exp/imp utilities preferably) - we need to import dumps regularly (it is for continuous integration server), we need to do it from remote host (so impdp is hardly an option with need to mount so remote volumes), dependency on other DB is highly undesirable (dblink). UPD: Unfortunately for all curious we have solved the problem switching continuous integration system to Oracle XE, where is no such problem. Sysadm has already switched off this server, so I cannot try anything. Sorry. oracle-11g-r2 oracle-10g export import share|improve this question edited Dec 1 '11 at 11:08 asked Oct 3
database from one server to another. .. . importing table "WWW_POLL" 24347 rows imported IMP-00017: following statement failed with ORACLE error 1031: "CREATE INDEX "TTPERSPROF_EMAIL" ON "TRUSTEE_PERSONALPROFILE" (LOWER("EMAIL"" ") ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 17530880 NEXT 87244" "80 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1" " BUFFER_POOL DEFAULT) TABLESPACE "NAL_IDX" LOGGING" IMP-00003: ORACLE error 1031 encountered ORA-01031: insufficient privileges IMP-00017: following statement failed with ORACLE error 1031: "CREATE INDEX "TTPERSPROF_USERNAME" ON "TRUSTEE_PERSONALPROFILE" (LOWER("USE" "RNAME") ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 11714560 NEXT" " ... Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode July 8th,10:07 AM #1 Annoying IMP error Hi, I'm getting the following errorwhen importing my database from one server to another. .. . importing table "WWW_POLL" 24347 rows imported IMP-00017: following statement failed with ORACLE error 1031: "CREATE INDEX "TTPERSPROF_EMAIL" ON "TRUSTEE_PERSONALPROFILE" (LOWER("EMAIL"" ") ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 17530880 NEXT 87244" "80 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1" " BUFFER_POOL DEFAULT) TABLESPACE "NAL_IDX" LOGGING" IMP-00003: ORACLE error 1031 encountered ORA-01031: insufficient privileges IMP-00017: following statement failed with ORACLE error 1031: "CREATE INDEX "TTPERSPROF_USERNAME" ON "TRUSTEE_PERSONALPROFILE" (LOWER("USE" "RNAME") ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 11714560 NEXT" " 5816320 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GR" "OUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "NAL_IDX" LOGGING" IMP-00003: ORACLE error 1031 encountered ORA-01031: insufficient privileges About to enable constraints... Import terminated successfully with warnings. The NAL_IDX space was created like this: CREATE TABLESPACE NAL_IDX DATAFILE '/global/dbdg/u03/oradata/GM_PRD/nal_idx01.dbf' SIZE 1048584K AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL AUTOALLOCATE; Than sk in advance Dave Dave Campbell Guest July 8th,01:14 PM #2 Re: Annoying IMP error First, make sure that the user that will own the index has the proper quota on the NAL_IDX tablespace