Oracle Database Errors or Warnings from Error ORA-30552 to ORA-30565

SQLServerF1

ORA-30552: The package/procedure/function cannot be changed
Cause: The package/procedure/function is deterministic and some object depends on it
Action: Drop the other object which depends on the package/function/procedure you are trying to change
ORA-30553: The function is not deterministic
Cause: The function on which the index is defined is not deterministic
Action: If the function is deterministic, mark it DETERMINISTIC. If it is not deterministic (it depends on package state, database state, current time, or anything other than the function inputs) then do not create the index. The values returned by a deterministic function should not change even when the function is rewritten or recompiled.
ORA-30554: function-based index string.string is disabled
Cause: An attempt was made to access a function-based index that has been marked disabled because the function on which the index depends has been changed.
Action: Perform one of the following actions: — drop the specified index using the DROP INDEX command — rebuild the specified index using the ALTER INDEX REBUILD command — enable the specified index using the ALTER INDEX ENABLE command — make the specified index usable using the ALTER INDEX UNUSABLE command

ORA-30555: global index partitioning key is an expression
Cause: An attempt was made to use an expression as a partitioning key in an index.
Action: Do not attempt to use an expression as index partitioning key.
ORA-30556: functional index is defined on the column to be modified
Cause: An ALTER TABLE MODIFY COLUMN was issued on a column on which a functional index exists.
Action: Drop the functional index before attempting to modify the column.
ORA-30557: function based index could not be properly maintained
Cause: The user updated a column on which a function based index is present which was not successfully updated
Action: Determine the error in updating the index and fix the problem

ORA-30558: internal error [string] in function based index
Cause: This is an internal error.
Action: Contact Worldwide support with the exact error text.
ORA-30563: outer join operator (+) not allowed in select-list
Cause: An attempt was made to reference (+) in select-list.
Action: Do not use the operator in select-list.
ORA-30564: Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
Cause: The clause INVALIDATE or UPDATE GLOBAL INDEXES is allowed only for ADD partition to a HASH partitioned table or ADD subpartition to a composite partitioned table.
Action: Remove clause and reissue operation
ORA-30565: Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
Cause: The clause INVALIDATE or UPDATE GLOBAL INDEXES was specified more than once.
Action: Remove all but one of the INVALIDATE or UPDATE GLOBAL INDEXES clause and reissue the statement

Above are list of Oracle Database Errors or Warnings from Error ORA-30552 to ORA-30565 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *