Sunday, 3 June 2012

ORA-32588: supplemental logging attribute string exists

ORA-32588: supplemental logging attribute string exists

Cause: specified supplemental logging attribute exits.

Action: retry the alter or create ddl after removing this supplemental logging attribute.

ORA-32587: Cannot drop nonexistent string supplemental logging

ORA-32587: Cannot drop nonexistent string supplemental logging

Cause: specified supplemental log attribute does not exist.

Action: None

ORA-32586: multiple specification of a supplemental logging attribute

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 or alter ddl.

Action: Rewrite the Create or Alter DDL with single occurence of the offending supplemental logging attribute.

ORA-32585: duplicate specification of a supplemental log attribute

ORA-32585: duplicate specification of a supplemental log attribute

Cause: In a create or alter DDL a supplemental log attribute is specified more than once.

Action: Rewrite the Create or Alter DDL such that it has a single occurence of any supplemental log attribute.

ORA-32584: missing LOG keyword

ORA-32584: missing LOG keyword

Cause: keyword LOG is missing.

Action: Use LOG keyword.

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

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.

ORA-32582: table function with left correlation to a table cannot also be left outer-joined to the table

ORA-32582: table function with left correlation to a table cannot also be left outer-joined to the table

Cause: A table function T2 contains a reference to a table T1. T2 is also left outer-joined to T1. This is not allowed.

Action: Remove the reference to T1 from T2 or remove the left outer-join specification (+).