Oacle enables data import and export between different sub-Devices

You can export a data table from the local Oracle database with the file name. dmp, and then import the dmp file to the oracle table of another host. Deep feelings. I am not familiar with the functions of oracle files.

First, modify the content of tnsnames. ora (D: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ tnsnames. ora in the oracle Installation Directory:

ORA10G = // local oracle ID (existing file content)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.10.10) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10g)
)
)
ORA10G2 = // *** Remote Computer oracle ID (to be added )***
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.3.43.130) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10g)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
)
(CONNECT_DATA =
(SID = PL *** tProc)
(PRESENTATION = RO)
)
)
 
Import and Export commands:
Exp ckkh/ckkh @ ora10g file = c: \ datanewsmgnt. dmp tables = (ckkh_account, ckkh_account_tmp)
// Export the table data of the database marked as ora10g to disk C
Imp ckkh/ckkh @ ora10g2 file = c: \ datanewsmgnt. dmp full = y
// Import the exported dmp file to the database marked as ora10g2.