Pre-requesites:
a. Database must in archivelog mode.
b. Automatic undo tablespace management must be on
c. There should be enough space (depends on your requirement) in undo tablespace.
Steps
1. Verify the flashback feature is on or not using the flashback_on column in the v$database
a. Database must in archivelog mode.
b. Automatic undo tablespace management must be on
c. There should be enough space (depends on your requirement) in undo tablespace.
Steps
1. Verify the flashback feature is on or not using the flashback_on column in the v$database