TABLES

How To Copy Table Including Data, Indexes, Constraints?

We can create a table in oracle based on structure or data or both of another table.

First we will create a test table to check all the scenarios.

Test table setup: