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

First, make sure that the user that will own the index has the proper
quota on the ARSENAL_IDX tablespace.

Then, make sure that the user that will is creating the index has the
CREATE INDEX or CREATE ANY INDEX system privilege to be able to create
this index.

HTH,
Brian

Dave Campbell wrote:
--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

david.campbell (AT) granadamedia (DOT) com (Dave Campbell) wrote in message news:<d8afeb3.0307080207.1fd21189 (AT) posting (DOT) google.com>...

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

mngong (AT) yahoo (DOT) com (michael ngong) wrote in message news:<ecf365d5.0307081141.4cc6add2 (AT) posting (DOT) google.com>...
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