Preparing your Oracle environment - undo retention

For the data migration process, the interval of the Undo retention should be increased to handle the database changes.

The recommended minimum setting for this parameter is 4 hours:


alter system set undo_retention=14400 scope=both

After the data migration, this parameter can be reset to the previous value.