Oracle数据库常见的问题

云淡风轻的小白

于 2019-07-14 11:32:56 发布

阅读量275

点赞数

分类专栏： oracle 文章标签： oracle

本文链接：https://blog.youkuaiyun.com/qq_33586100/article/details/95867953

版权

oracle 专栏收录该内容

5 篇文章

订阅专栏

1 在cmd中导入数据库数据


exp myoracle2/myoracle2@orcl 
file=C:\Users\Administrator\Desktop\DataBase\myoracle.dmp  log=... full=y

exp myoracle2/myoracle2@orcl 
file=C:\Users\Administrator\Desktop\DataBase\myoracle.dmp  log=...  tables=myoracle_YJDP_USER

log为保存的日志路径，tables为其中某一个表

在cmd中导出数据库数据

imp myoracle/myoracle@orcl file=... log=... full=y
imp myoracle/myoracle@orcl file=... tables=... log=...

2 解决乱码问题题
新建用户变量NLS_LANG
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

3 配置Navicat
将oracle中的Network 放到client中

4 数据库配置

  <appSettings>
    <add key="sql" value="user id =myweb; password = myweb; Data Source =  (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = orcl)))"/>
  </appSettings>

    public static string connectionString = System.Configuration.ConfigurationManager.AppSettings["sql"];