Oracle error

Squiz Matrix Support
1

One of our DBA's has noticed the following error message within the logs of our Matrix ORACLE Database…


Any Ideas???


    EXP-00008: ORACLE error 1031 encountered
    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 468
    ORA-06512: at line 1
    EXP-00078: Error exporting metadata for index SQ_SCH_IDX_VALUE. Index creation will be skipped
    EXP-00008: ORACLE error 1031 encountered
    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 256
    ORA-06512: at line 1
    EXP-00078: Error exporting metadata for index SQ_SCH_IDX_VALUE. Index creation will be skipped
    
    Investigating this further, the error explanation is:
    00078, 0000, "Error exporting metadata for index %s. Index creation will be skipped"
    // *Cause:  Domain indexes export private metadata via anonymous PL/SQL blocks
    //        prior to the CREATE INDEX statement. Export does this by calling
    //        the ODCIIndexGetMetadata method on the implementation type
    //        associated with the index. A problem occurred inside this routine.
    //        Because the metadata is considered an integral part of the index,
    //        the CREATE INDEX statement was not written to the dump file.
    // *Action: Contact the developer of the index's implementation type. If this
    //        is an Oracle-supplied index (perhaps via a data cartridge), contact
    //        Oracle Worldwide Support.
2

Your SYSDBA needs to grant EXECUTE on CTX_DDL to the Matrix user:


[sql]GRANT execute ON ctx_ddl TO matrix_user;[/sql]



That will allow the Matrix user to create and execute Oracle Text indexing.

3

[quote]Your SYSDBA needs to grant EXECUTE on CTX_DDL to the Matrix user:


[sql]GRANT execute ON ctx_ddl TO matrix_user;[/sql]



That will allow the Matrix user to create and execute Oracle Text indexing.

[right][post=“15283”]<{POST_SNAPBACK}>[/post][/right][/quote]



Hi Avi,



Here is the feedback I have from our DBA’s after trying your suggestion:


[quote]I have granted the privileges outlined below to the matrix user, however I am still experiencing the same errors.  I have also tried granting the privilege to the export user, and this did not rectify the issue.[/quote]



Thoughts???

A B)

4

None, I'm afraid – I just exhausted my Oracle knowledge, sadly. I know that on my 10g-based Oracle boxes, that's all I need to do.


I recommend submitting a formal support request so that our sysadmins can investigate.

5

[quote]None, I’m afraid – I just exhausted my Oracle knowledge, sadly. I know that on my 10g-based Oracle boxes, that’s all I need to do.


I recommend submitting a formal support request so that our sysadmins can investigate.

[right][post=“15301”]<{POST_SNAPBACK}>[/post][/right][/quote]



No Probs will do … :slight_smile:



A

6

[quote]No Probs will do …


A

[right][post=“15302”]<{POST_SNAPBACK}>[/post][/right][/quote]



Our DBA’s have a solution!!!



The user performing the export required explicit select privileges on the table that the erroring index was on.

This issue appears to be related to oracle bug #5530761





Something usefull to tuck away for later :ph34r:

A