Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Annoying IMP error

Re: Annoying IMP error

From: michael ngong <mngong_at_yahoo.com>
Date: 8 Jul 2003 12:41:12 -0700
Message-ID: <ecf365d5.0307081141.4cc6add2@posting.google.com>


david.campbell_at_granadamedia.com (Dave Campbell) wrote in message news:<d8afeb3.0307080207.1fd21189_at_posting.google.com>...
> 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 "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 ARSENAL_IDX space was created like this:
>
> CREATE TABLESPACE ARSENAL_IDX
> DATAFILE '/global/dbdg/u03/oradata/GM_PRD/arsenal_idx01.dbf' SIZE
> 1048584K
> AUTOEXTEND ON NEXT 50M
> EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
>
> Than sk in advance
>
> Dave

If you do your exp/imp with full database privileges (DBA ) You may not run into insufficient permissions .
If not grant you may need to grant appropriate rights to the which ever user.

There is a role called imp_full_database ,exp_full_database which lists the rights a user needs to perform the listed tasks, assuming the users are importing the whole database select * from dba_role_sys where grantee='imp-full_database' ; gives you a long listing of the privileges needed to import a full database
which is an extension to the privileges you need to do imports

Michael Tubuo Ngong Received on Tue Jul 08 2003 - 14:41:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US