You may not be doing anything wrong. One limitation of FlashBack is that you must have enough temporary(UNDO) storage to hold the information. If you UNDO tablespace is too small, it will purge the oldest data until it has enough space.