如何向oracle数据库中导入数据
1.以管理员的权限连接登陆pl/sql。
如果没有可以在oracle中配置一个,oracle安装目录下oracle\product\10.2.0\db_1\NETWORK\ADMIN找到“tnsnames.ora”文件,打开配置一个
ORCL47 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)