We need to move all of our Flashback Data Archives to a new tablespace (they are currently in several).
The SQL Reference ( http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_1008.htm#BABGBHGE ) describes how to add a tablespace and remove a tablespace for a Flashback Data Archive. However, the text for REMOVE TABLESPACE states:
If the tablespace to be removed contains any data within the retention period of the flashback archive, then that data will be dropped as well. Therefore, you should move your data to another tablespace before removing the tablespace with this clause.
OK, good tip. But how to accomplish this? Is there a direct command to do this? Or do I need to do this piece by piece? i.e. issue
ALTER TABLE xxx MOVE TABLESPACE new_tablespace;
on every SYS_FBA_TCRV_xxx table, every SYS_FBA_DDL_COLMAP_xxx table, every SYS_FBA_HIST_xxx table; also rebuild indexes on those tables to the new tablespace; also move individual partitions on those tables?
Are those operations recommended or supported? Are they enough?