How to bring data from One Schema to Second Schema in Oracle

This is specify to Oracle 11

If you need to bring (transfer) data from older database schema (UDBTEST) to new schema (UDBBETA) in oracle database then you will follow there procedures:

1- Create a Link between both schema(s)
2- Run insert query

Step: 1 For this step you must have admin permission on database

ORACLE LINKS
HERE SOURCE IS UDBTEST and target is UDBBETA. Link is created in target and accessed in target.

Run it from UDBBETA:
select count(*) from team1_user@UDBTEST2BETA;

Link created in udbbeta connected to udbtest.:
CREATE PUBLIC DATABASE LINK UDBTEST2BETA
CONNECT TO 'yourusername' IDENTIFIED BY 'yourpassword'
USING 'udbtest'
/

Step 2: Run this command
Insert into
Select * from @UDBTEST2UDBBETA;

commit;