Oracle Cross-Library replication table structure

1. Establish a remote connection first

Create Public database link Link_sjps
Connect to system identified by manager
Using ' (DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.20) (PORT = 1521))
)
(Connect_data =
(service_name = Gzzl)
)
)‘;

2. Duplicate table structure

Create Global temporary table tack_allocation on commit delete rows as select * from [email protected]_sjps. Regress. Rdbms. DEV. US. Oracle.com

Oracle Cross-Library replication table structure