Re: Annoying IMP error

mngong_at_yahoo.com (michael ngong) wrote in message news:<ecf365d5.0307081141.4cc6add2_at_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
>
>

.......Sorry I hit post ,rather than preview message !!!!!!!!!!!!!!!  There is no view called dba_role_sys or a role imp-full_database hopefully no one was misled yet by that ....!!!!!!

 If you do exp/imp with full database privileges (DBA ) You may  not run into errors indicating you have insufficient permissions .

 If not, you may need to grant appropriate rights to which  ever user needs to do the imp/exp.  

 There are two roles 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_privs

      where grantee='IMP_FULL_DATABASE' ; select * from dba_sys_privs

      where grantee='IMP_FULL_DATABASE' ; Do the same for EXP_FULL_DATABASE
 This gives a listing of the privileges needed to import/export a full  database you probably need less rights to do the likes of a table import...   

 Michael Tubuo Ngong Received on Wed Jul 09 2003 - 08:53:49 CDT