Oracle Database Errors or Warnings from Error ORA-38611 to ORA-38704

SQLServerF1

ORA-38611: FI input cursor’s item type is not supported
Cause: The input cursor’s item type is not number or character type
Action: Redefine the input cursor so that item type is number or character type.
ORA-38612: FI item length cannot exceed half of one database block.
Cause: The item’s length was more than half of one database block.
Action: Redefine the data type of the item column so that its maximum length is less than half of one database block.
ORA-38620: DT expressions in input cursor do not have an alias name
Cause: Expressions in input cursor do not have an alias name.
Action: Add an alias name for the expression.

ORA-38621: Decision Tree maximum depth setting not between [2, 20]
Cause: The user specified a max tree depth not in the range of [2, 20].
Action: The user should adjust the input value to be in the range of [2, 20].
ORA-38622: Decision Tree not enough memory, requires at least stringKB
Cause: The memory size did not satisfy the minimum memory requirement for decision tree building.
Action: In workarea_size_policy=’manual’ mode, set _dtree_area_size to a reasonably larger value. Or, In workarea_size_policy=’auto’ mode, please raise pga_aggregate_target to a reasonably larger value.
ORA-38700: Limit of string flashback database logs has been exceeded.
Cause: The maximum number of flashback database log files was exceeded.
Action: DB_FLASHBACK_RETENTION_TARGET may be set to high. Modify it to a smaller value.

ORA-38701: Flashback database log string seq string thread string: “string”
Cause: This message reports the filename for details of another message.
Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
ORA-38702: Cannot update flashback database log file header.
Cause: Could not write to the flashback database log file.
Action: Restore access to the file.
ORA-38703: Type string in header is not a flashback database log file.
Cause: A corrupt flashback database log file header was read.
Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.
ORA-38704: Checksum error in flashback database log file header.
Cause: The flashback database log file header contained a checksum that does not match the value calculated from the file header as read from disk. This means the file header was corrupt.
Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.

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

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase 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 *