最近在使用impdp导入数据的时候,因源库gbk与目标库utf8的字符集不一样,造成导入时目标库中表的字段长度不够。报错信息如下:点击(此处)折叠或打开ORA-02374: conversion error loading table "HN_CM_IRMS_35_TNMS"."PTN_NE_TO_SERVICE"ORA-12899: value too large for colu...【阅读全文】
查看所有用户分区表及分区策略(1、2级分区表均包括):SELECT p.table_name AS 表名, decode(p.partitioning_key_count, 1, '主分区') AS 分区类型,p.partitioning_type AS 分区类型, p.column_name AS 分区键,decode(nvl(q.subpartitioning_key_count, 0), 0, '无子分区', 1, '子分区') AS 有无子分区,q.subpartition...【阅读全文】
如果程序在日志中查询无ora错误,而调度报java.sql.SQLException: 无法从套接字读取更多的数据。请确认在程序中是哪条sql报错了; 如果此sql是大数据集的group by而导致的错误,那么这是一个oracle内部bug(Bug 6818207 - Intermittent Wrong Results/Dump (qeshIHInsertPRowInBkt) using hash GROUP BY of ...【阅读全文】
Oracle 查看统计信息SCRIPT - Select to show Optimizer Statistics for CBO (Doc ID 31412.1)https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=1638430201757426&id=31412.1&_adf.ctrl-state=17ud5ixo9v_65 [oracle@my2950 admin]$ cd /u01/app/oracle/product/11.2.4/db_1/rdbms/admin[oracle@my2950 ad...【阅读全文】
使用DBMS_XPLAN查看执行计划SQL> show user;USER is "SCOTT"SQL>SQL> select count(*) from dba_objects; COUNT(*)---------- 87091SQL> create table t2 as select * from dba_objects;Table created.SQL>SQL> create index idx_t2 on t2(OBJECT_ID);Index created.SQL> SQL> exec dbms_sta...【阅读全文】