Copy table data between users in Oracle

Table replication under the same Oracle user is also called table backup. Although it is called differently, it is essentially the same:

Syntax: create table AB as select * from B

This means that all copies of Table B are used to create table AB.

Table replication between different users must be performed by users with dba permissions:

For example, under a system user:

Create the orders_back table in the user to back up the orders table in the scott user.

Create table user. orders_back as select * from scott. orders;

The two images below are all under the same user. They are not implemented under the system user, and the principles are the same. If you are interested, study them on your own.

Quick Response after Oracle accidentally deletes table data