我的是10g,想导入8的dmp文件,但是报错.
于是在10g里面我新建一个数据库 "db"
导出到exp system/123456@db file=d:db_back.dmp full=y
没有问题,文件正常导出了.然后就用Database Configuration Assistant删除了"db"数据库
再导入就报错!!
D:>imp system/123456@db file=d:\db_back.dmp full=y
Export: Release 10.2.0.1.0 - Production on 星期二 3月 2 10:14:45 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: 遇到 ORACLE 错误 12154
ORA-12154: TNS: 无法解析指定的连接标识符
EXP-00000: 导出终止失败
请问怎么解决???
网上说要改变tnaname文件
我现在是这样的,有一个叫"ttt"的数据库
tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
Generated by Oracle configuration tools.
TTT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = china-ca0297241)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ttt)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
具体要怎么改??希望大家指点一下