Issue:- Copy Table data from one schema to another schema in Oracle DB
Platform:- Opkey On-Premise and SaaS.
Step 1. First, we have to get the schema name using below query,
sys_context('USERENV,SESSION_USER') as "USER NAME",
sys_context('USERENV', 'CURRENT_SCHEMA') as “CURRENT SCHEMA”
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;