1:配置远程的sid:
找到数据库的装目录(如:C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN)下的tnsnames.ora文件添加以下远程sid:
ORA10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 远程ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 远程库的sid)
)
)
去到保存dmp文件的目录下:imp username/pwd@远程sid file=pathname+filename [full=y]
如imp user/user@text file='test.dmp' full=Y