Oracle
Oracle数据库
BuLingLings
这个作者很懒,什么都没留下…
展开
-
linux服务器修改oracle字符集
由于导出的dmp字符集与oracle服务器字符集不一致,导致导入失败操作命令[oracle@ORACLE ~]$ sqlplus /nologSQL> conn /as sysdba;SQL>select userenv(‘language’) from dual; --查看服务端字符集SQL>SHUTDOWN IMMEDIATE --关闭数据库SQL>STARTUP MOUNT --启动到 MountSQL>ALTER SYSTEM ENABLE R.转载 2020-10-29 11:02:20 · 256 阅读 · 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=replaceImport: Release 11.2.0.4.0 - Production on Wed Oct 21 15:26:.转载 2020-10-26 18:54:38 · 562 阅读 · 0 评论 -
Python3.6基于cx_Oracle实现查询列名及对应值
官方API说明Changing Query Results with Rowfactoriescx_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 · 1266 阅读 · 0 评论