Oracle Error Codes

internal data of the advisor repository is inconsistent

Users should not explicitly modify summary advisors internal tables. Such modifications may cause inconsistency in the internal tables and result in this error.

How to Solve :

This is an internal error. Notify ORACLE technical support

unable to position to block number string in dump file “string”

Export or Import was unable to position its file pointer to a specific block within the dump file. This message is usually followed by device messages from the operating system.

How to Solve :

Take appropriate action based on the device messages.

internal data for run number string is inconsistent

Users should not explicitly modify summary advisors internal tables. Such modifications may cause inconsistency in the internal tables and result in this error.

Users can call the DBMS_OLAP.PURGE_RESULTS subprogram to remove the inconsistent data from summary advisors internal tables

unable to close dump file “string”

Export or Import was unable to close the dump file. This message is usually followed by device messages from the operating system.

Take appropriate action to restore the device.

valid workload queries not found

None of the specified queries can be successfully parsed. The error may come from many sources: SQL syntax error, the owner specified by the load_workload subprograms do not match the real user who generates the SQL statement

Only load valid SQL statements into the advisor repository. Make sure the statements can be parsed with privilege of the owner as specified in the owner parameter of the load_workload() subprogram.