Oracle Error 1031 Encountered Import
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > ORA-01031: insufficient privileges on import between two Oracle 8i databases Want to Advertise Here? Solved ORA-01031: insufficient privileges on import between two Oracle 8i databases Posted on 2003-07-08 Oracle Database 1 Verified Solution 8 Comments 4,782 Views Last Modified: 2011-10-03 I'm doing an import of one database into another database. Both are running 8i. The database that the db was exported from had a single schema, the database I'm importing into has several other schema already. I'm tring to consolidate the oracle instances. The error on import is: . . 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 "ARSENAL_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 "ARSENAL_IDX" LOGGING" IMP-00003: ORACLE error 1031 encountered ORA-01031: insufficient privileges About to enable constraints... Import terminated successfully with warnings. The user was created like this: create user arsenal_build002 identified by password default tablespace ARSENAL_DATA temporary tablespace temp; GRANT connect, resource TO arsenal_build002; GRANT SELECT ANY TABLE TO arsenal_build002; GRANT UNLIMITED TABLESPACE TO arsenal_build002; The arsenal_idx tablesapce was created thus: CREATE TABLESPACE ARSENAL_IDX DATAFILE '/global/dbdg/u03/oradata/GM_PRD/arsenal_idx01.dbf' SIZE 200M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL AUTOALLOCATE; Thanks 0 Question by:dc2447 Facebook Twitter Link
2007 - 8:21 pm UTC Category: Database � Version: 8.1.6 Whilst you are here, check out some content from the AskTom team: On HTML DB, Bulking Up, and Speeding Latest Followup You Asked Tom, https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:1492331695311 I export a table that has the following constraints: Primary key Unique key http://stackoverflow.com/questions/29166997/using-oracle-imp-gives-the-error-imp-00058 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 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 oracle error 2 MAXTRANS 255 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" "E NOVALIDATE" IMP-00003: ORACLE error oracle error 1031 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@ORA817DEV.US.ORACLE.COM> grant dba to a identified by a; Grant succeeded. ops$tkyte@ORA817DEV.US.ORACLE.COM> ops$tkyte@ORA817DEV.US.ORACLE.COM> @connect a/a ops$tkyte@ORA817DEV.US.ORACLE.COM> set termout off a@ORA817DEV.US.ORACLE.COM> REM GET afiedt.buf NOLIST a@ORA817DEV.US.ORACLE.COM> set termout on a@ORA817DEV.US.ORACLE.COM> a@ORA817DEV.US.ORACLE.COM> a@ORA817DEV.US.ORACLE.COM> creat
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 us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping 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 imp to import into an Oracle database. I am running the command: imp