Category Archives: ORA Database Error Messages

ORA-32592: all columns in log group can not be no log columns

oracle

ORA-32592: all columns in log group can not be no log columns
Cause: A supplemental log group must have at least one column of scalar type that is not marked as no log
Action: Redefine the supplemental log group with at least one column of scalar type that is not marked as no log

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32591: connect string too long

oracle

ORA-32591: connect string too long
Cause: The connect string specified for the database link was more than 2000 characters
Action: Specify a connect string less than 2000 chracters

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32590: log group specification not allowed here

oracle

ORA-32590: log group specification not allowed here
Cause: Supplemental log specification is not allowed in the statement
Action: Remove the supplemental log specification from the statement

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32589: unable to drop minimal supplemental logging

oracle

ORA-32589: unable to drop minimal supplemental logging
Cause: Minimal supplemental logging could not be dropped as one of primary key, foreign key, unique or all column supplemental logging is enabled at the database level
Action: Use V$DATABASE to determine the databasewide supplemental logging directives. Minimal supplemental logging could be dropped if and only if no other databasewide supplemental logging directives are enabled

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32588: supplemental logging attribute string exists

oracle

ORA-32588: supplemental logging attribute string exists
Cause: specified supplemental logging attribute exits
Action: retry the alter/create ddl after removing this supplemental logging attribute

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32587: Cannot drop nonexistent string supplemental logging

oracle

ORA-32587: Cannot drop nonexistent string supplemental logging
Cause: specified supplemental log attribute does not exist
Action: None

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32586: multiple specification of a supplemental logging attribute

oracle

ORA-32586: multiple specification of a supplemental logging attribute
Cause: The primary key, unique index, foreign key or all column supplemental logging attribute can be specified at most once in a create/alter ddl
Action: Rewrite the Create/Alter DDL with single occurence of the offending supplemental logging attribute

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32585: duplicate specification of a supplemental log attribute

oracle

ORA-32585: duplicate specification of a supplemental log attribute
Cause: In a create/alter DDL a supplemental log attribute is specified more than once
Action: Rewrite the Create/Alter DDL such that it has a single occurence of any supplemental log attribute

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32584: missing LOG keyword

oracle

ORA-32584: missing LOG keyword
Cause: keyword LOG is missing
Action: Use LOG keyword

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32583: query passed to table function has wrong number of elements in select list

oracle

ORA-32583: query passed to table function has wrong number of elements in select list
Cause: The query used as an input to a table function which takes a a ref cursor as argument has wrong number of elements in the select list which does not correspond to the elements in ref cursor. The ref cursor mentioned here refers to the one referenced in order by parition clauses. This is not allowed
Action: Make sure that the select list of the query matches the ref cursor columns as defined in the function

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/