Oracle
Oracle数据库
BuLingLings
这个作者很懒,什么都没留下…
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
linux服务器修改oracle字符集
由于导出的dmp字符集与oracle服务器字符集不一致,导致导入失败 操作命令 [oracle@ORACLE ~]$ sqlplus /nolog SQL> conn /as sysdba; SQL>select userenv(‘language’) from dual; --查看服务端字符集 SQL>SHUTDOWN IMMEDIATE --关闭数据库 SQL>STARTUP MOUNT --启动到 Mount SQL>ALTER SYSTEM ENABLE R.转载 2020-10-29 11:02:20 · 348 阅读 · 0 评论 -
oracle导入dmp报ORA-39006--ORA-39213
impdp导入时报错如下 [oracle@dbdev1 expdp_backup]$ impdp system/******@kthis directory=DMP dumpfile=KTHIS_20201021.DMP logfile=impdp_KTHIS_20201021.log remap_schema=***:*** table_exists_action=replace Import: Release 11.2.0.4.0 - Production on Wed Oct 21 15:26:.转载 2020-10-26 18:54:38 · 695 阅读 · 0 评论 -
Python3.6基于cx_Oracle实现查询列名及对应值
官方API说明 Changing Query Results with Rowfactories cx_Oracle “rowfactories” are methods called for each row that is retrieved from the database. The Cursor.rowfactory() method is called with the tuple that would normally be returned from the database. The m原创 2020-10-13 19:07:17 · 1556 阅读 · 0 评论
分享