Alessandro Lacava

on Designing and Developing Software. In love with Functional Programming.

How to Create a Copy/backup of a Table In Oracle

You can create a backup of a table (structure and data) in Oracle by using the following syntax:

CREATE TABLE customers_backup AS (SELECT * FROM customers)

The previous example creates the customers_backup table which mirrors the structure and data of the customers table.