ORA-55636 On REASSOCIATE_FBA on table with XMLTYPE data type
Hi all
Im running Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
I have enabled flashback archive on a table with a XMLTYPE data type
desc test_table1
Name Null Type
------------------- -------- ---------
PARENT_ID NOT NULL NUMBER
TYPE_ID NOT NULL NUMBER
XCONTENT XMLTYPE()
ALTER TABLE test_table1 flashback archive test_fba:
The command above executes fine and it actually tracks change history in SYS_FBA_HIST_XXXX table. When i execute the following command sequence:
begin
DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA('ejc', 'test_table1');
DBMS_FLASHBACK_ARCHIVE.REASSOCIATE_FBA('ejc','test_table1');
end;
I get the following error