OraFAQ Forum: Server Utilities » Cannot do import of Function based Indexes

Home » RDBMS Server » Server Utilities » Cannot do import of Function based Indexes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot do import of Function based Indexes [message #118446]

Thu, 05 May 2005 05:49

shibu.varghese
Messages: 15
Registered: April 2005
Location: Trivandrum

Junior Member

I exported an schema successfully using the EXP utility and then
tried to import it into another DB. Everything went well, except that the Function Based Indexes did not get imported. The error log is being attached.

Please note all the other indexes has been created except for this one. Is their any specific privilege for Function Based Indexes.

Please help me in this regard.

Thanks in advance.

LOg:
IMP-00017: following statement failed with ORACLE error 1031:

"CREATE INDEX "IRES_WLST_ALIAS_IDX1" ON "IRES_WLST_ALIAS"
("AIRLINE_IATA_COD"

"E" , UPPER("FIRST_NAME") ) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INIT"

"IAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "IRESWS16DEMO"
LOGGING"

IMP-00003: ORACLE error 1031 encountered

ORA-01031: insufficient privileges

IMP-00017: following statement failed with ORACLE error 1031:

"CREATE INDEX "IRES_WLST_ALIAS_IDX2" ON "IRES_WLST_ALIAS"
("AIRLINE_IATA_COD"

"E" , UPPER("MIDDLE_NAME") ) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INI"

"TIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "IRESWS16DEMO"
LOGGING"

IMP-00003: ORACLE error 1031 encountered

ORA-01031: insufficient privileges

IMP-00017: following statement failed with ORACLE error 1031:

"CREATE INDEX "IRES_WLST_ALIAS_IDX3" ON "IRES_WLST_ALIAS"
("AIRLINE_IATA_COD"

"E" , UPPER("LAST_NAME") ) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITI"

"AL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "IRESWS16DEMO"
LOGGING"

IMP-00003: ORACLE error 1031 encountered

ORA-01031: insufficient privileges

Report message to a moderator

Re: Cannot do import of Function based Indexes [message #118450 is a reply to message #118446]

Thu, 05 May 2005 06:11

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Make sure the user has quota on tablespace IRESWS16DEMO.
and
< quotingdoc >
You must have the following initialization parameters defined to create a function-based index:

* QUERY_REWRITE_INTEGRITY set to TRUSTED
* QUERY_REWRITE_ENABLED set to TRUE
* COMPATIBLE set to 8.1.0.0.0 or a greater value
< /quotingdoc >

Report message to a moderator

Previous Topic:	ORA-00922 Error While Importing a dump File
Next Topic:	SQL*Load with default value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 09 15:18:38 CST 2025