Source schema – scott
Source DB – Track
Target schema – scott_temp
Target DB – testdb
Server – oel6-node01.localdomain (192.168.189.101)

First I am creating a blank schema scott_temp on target database

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
TESTDB    READ WRITE

SQL> CREATE USER "SCOTT_TEMP" IDENTIFIED BY tiger
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";

GRANT "CONNECT" TO "SCOTT_TEMP";
GRANT "RESOURCE" TO "SCOTT_TEMP";
ALTER USER "SCOTT_TEMP" DEFAULT ROLE "CONNECT", "RESOURCE";
GRANT UNLIMITED TABLESPACE TO "SCOTT_TEMP";  2    3
User created.

SQL> SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
User altered.

SQL>

Grant succeeded.

SQL> select object_name from dba_objects where owner='SCOTT_TEMP';

no rows selected

now verify the source schema scott on track database

SQL>  select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
TRACK     READ WRITE

SQL> select object_name from dba_objects where owner='SCOTT_TEMP';

OBJECT_NAME
--------------------------------------------------------------------------------
PK_DEPT
PK_EMP
SALGRADE
EMP
BONUS
DEPT

6 rows selected.

SQL>

Now create connections for scott@track and scott_temp@testdb in sql developer.

once connections are created go to database copy tab


Select source and target connection.

you can filteer the object you want to copy.in our case i am copying entire scott schema to scott_temp schema


Once job is finished

You can see that object are now copied to our target database

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
TESTDB    READ WRITE

SQL> select object_name from dba_objects where owner='SCOTT_TEMP';

OBJECT_NAME
--------------------------------------------------------------------------------------------------------------------------------
DEPT
BONUS
EMP
SALGRADE
PK_EMP
PK_DEPT

6 rows selected.