Moving an Oracle table can move it to another tablespace and another database with TNS.
cat /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora
target =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv2.cloud.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl2)
)
)
alter table hr.employees move tablespace users@target online parallel 16;
We can all transactions on all databases .
Build it Oracle.