Question reg. Total Recall and switching of UNDO tablespace
Dear all,
we're using Total Recall to persist historic data.
I'd would like configure our database to use a new UNDO tablespace.
As Total Recall will store the historic data in UNDO and flush it to the SYS_FBA_HIST_* and SYS_FBA_TCRV_* tables lazily, I'd like to know when I can drop the old undo tbs WITHOUT endagering or deleting Total recall data which has not yet been written to the SYS_FBA_HIST_* tables.
I have established on a test system that creating a new UNDO TBS and altering the system to use it will not necessarily force a flush - so how do I proceed?
we're using Total Recall to persist historic data.
I'd would like configure our database to use a new UNDO tablespace.
As Total Recall will store the historic data in UNDO and flush it to the SYS_FBA_HIST_* and SYS_FBA_TCRV_* tables lazily, I'd like to know when I can drop the old undo tbs WITHOUT endagering or deleting Total recall data which has not yet been written to the SYS_FBA_HIST_* tables.
I have established on a test system that creating a new UNDO TBS and altering the system to use it will not necessarily force a flush - so how do I proceed?
0