Flashback logs not deleted while importing a huge table
Hi,
Oracle 12.2.0.1. EE with OL7, we use OMF, multitenant and local undo:
Today we had to export, truncate, import a table of near 80G, because we had to freeing wasted space due former deletion of many rows in that table.
I know, enable row movement and shrink space would be also an option, but we decided to take this way.
While importing the dump with direct_path option enabled, we observed that the FRA was filled up with archived logs and flashback logs up to 95% of db_recovery_file_dest_size. No flashback logs were deleted.
There are only archived and flashback logs in the FRA. At 95 Percent occupied space we decide to increase "db_recovery_file_dest_size", the import succeded.