首先要更改tnsnames.ora(oracle安装目录中D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora)文件内容: ORA10G =//本地oracle标识(文件已有内容)- B0 L0 Z5 u {4 W/ m- u& h
(DESCRIPTION =
% \$ a" U% R3 G (ADDRESS_LIST =
8 C- m2 O' a% \" U (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))& a5 X% Y& u% @9 P `% x4 ~
)
0 D: W' e. ?6 u A1 _" \ (CONNECT_DATA =! ^% ^$ j9 {: n }
(SERVER = DEDICATED) {: v) R2 m- z4 s, D4 C- l
(SERVICE_NAME = ora10g)% g M7 |* _1 H9 t
)
6 V& i4 I' x& s8 A4 T6 X )' E0 p5 `6 M/ I) f, g
ORA10G2 = //***远程电脑oracle标识(需添加的)***
4 w P9 O7 k7 S8 r3 W! s" [ (DESCRIPTION =
7 V' e2 g) k* A6 ? (ADDRESS_LIST =0 j# h+ x, [+ ~
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.43.130)(PORT = 1521))
' f$ K$ C/ ~5 L/ C )8 _1 ^; i" O/ `9 h G
(CONNECT_DATA =- U( \0 b: r7 K
(SERVER = DEDICATED)
5 ]7 S7 h9 f( F7 R (SERVICE_NAME = ora10g)
" W" i5 U( x" s) }* ` )) c& Y7 l6 D# e$ y, D: N# {/ s
)+ z) w, u: L' @: K8 e4 G+ W0 ?
EXTPROC_CONNECTION_DATA =4 b: P2 E9 `3 R0 H
(DESCRIPTION =1 u. Y+ H4 e6 L- j: ?+ f! U
(ADDRESS_LIST =! n- V+ y U2 M/ e
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))- e! \7 n* _% Z
)8 g$ v% ~% ?7 K# Z* M* ^: ^# f
(CONNECT_DATA =& z% u3 m6 d. G5 P
(SID = PL***tProc)
* G& Y4 e. K9 b+ D3 g (PRESENTATION = RO)
# L2 y8 |3 X7 y) u7 _- X )' \. [" T1 z! v& |3 O7 X# [
)
, G" D5 [/ d2 h4 U- } 通过导入导出命令:
! u. d- k* X2 E5 i1 e exp ckkh/ckkh@ora10g file= c:\datanewsmgnt.dmp tables=(ckkh_account,ckkh_account_tmp)
$ O/ S2 E* X6 n" l- e //将本地标识为ora10g的数据库的表数据导出到c盘: Y8 s1 Q9 ^4 w K5 y2 U
imp ckkh/ckkh@ora10g2 file=c:\datanewsmgnt.dmp full=y
/ Q6 y8 l! a+ \" O' G8 q //将导出的dmp文件导入到标识为ora10g2的数据库中。 |