Issue:- Copy Table data from one schema to another schema in Oracle DB

Platform:- Opkey On-Premise and SaaS.

Solution:-

Step 1. First, we have to get the schema name using below query,

SELECT

sys_context('USERENV,SESSION_USER') as "USER NAME",

sys_context('USERENV', 'CURRENT_SCHEMA') as “CURRENT SCHEMA”

FROM dual;

Step 2. Now we have to write the below query in our Execute Query command in OpKey. Here, the table name is taken as (Customers and Cust3) from Schema (Boruto and Cases)

Insert into system.Cust2 (Customer_Id,Customer_Name,City) select  Customer_ID, Customer_Name, City from system.Boruto

Step 3:- Now we have validated in the Cust3 table that all records were inserted or not.

Select * from Cust2;