Hello Experts,
I have a doubt in the following area.
Row movement must be enabled for all tables in order to use Flashback table feature unless you are flashing back the table TO BEFORE DROP. As per my understanding you can not enable Row Movement for a table which is not partitioned. This this concludes you can not FLASHBACK table with out Row Movement enabled and you can not enable a row movement for non partitioned table. So how can I use FLASHBACK table feature for NON Partitioned table?
Please see the below error message when i tried to enable ROW movement for non partitioned table.
SQL Error: ORA-14066: illegal option for a non-partitioned index-organized table
14066. 00000 - "illegal option for a non-partitioned index-organized table"
*Cause: An attempt was made to issue a CREATE or ALTER TABLE
command on a non-partitioned IOT, but the command contains an
option that is legal only for partitioned index-organized tables.
Such options are: ENABLE ROW MOVEMENT and DISABLE ROW MOVEMENT.
Thanks,