ORA-55631: Table has columns with data types that are not supported by Flashback Data Archive ORACLE 报错 故障修复 远程处理

文档解释

ORA-55631: Table has columns with data types that are not supported by Flashback Data Archive

Cause: An attempt was made to add a column of data type that is not supported by Flashback Data Archive. Or, the table on which Flashback Data Archive is being enabled contains column(s) with data types not supported by Flashback Data Archive.

Action: Do not use FLASHBACK ARCHIVE clause for this object. If adding column, do not use LONG or Nested Table column data type.

ORA-55631错误是由于Flashback Data Archive支持的数据类型不支持表中的字段所引发的。

官方解释

• CHAR

• NCHAR

• VARCHAR2

• NVARCHAR2

• RAW

• LONG

• CLOB

• NCLOB

• BLOB

• BFILE

• DATE

• TIMESTAMP

• INTERVAL DAY TO SECOND

常见案例

一般处理方法及步骤

1.删除不支持的小数类型字段。

2.在将表添加到FDA存档之前，先将不支持的字段类型更改为受支持的字段类型。

3.使用 ALTER TABLE 语句将表添加到FDA存档。