DATABASE SNAPSHOT statement

Oracle Database Snapshot Backup

A database snapshot is a point-in-time image of a database that is taken without affecting the performance of the database. Database snapshots can be used to protect data, to support development and testing, and to provide a read-only view of the database for reporting purposes.

When you create a database snapshot, Oracle Database creates a duplicate of the datafiles, redo logs, and control files of the database. The snapshot is read-only and does not occupy any additional disk space.

You …