Database Backup and Recovery (MOSC)

MOSC Banner

ORA-55636 On REASSOCIATE_FBA on table with XMLTYPE data type

edited Jul 15, 2015 11:54AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center