How to resize Undo

You can shrink the datafile of the UNDO tablespace on the primary database to 1G by using the following command: ASM needs the correct ASM filename. The undo datafile on the standby database will be automatically resized as well. If you get the following error: ORA-03297: file contains used data beyond requested RESIZE value…