南通网站建设案例,网页设计与网站建设指标点,企业网站建设报价明细表,wordpress搭建论坛泉源#xff1a;赛迪网 作者#xff1a;Arvin在梦想的义务环境下#xff0c;假如你在操作时将数据库内的几个数据字典表Truncate丢失#xff0c;将会直接招致数据库不能再承袭使用#xff0c;本文将针对一个相关案例举行详尽的讲解。 案例如下#xff1a; 数据库环境… 泉源赛迪网 作者Arvin 在梦想的义务环境下假如你在操作时将数据库内的几个数据字典表Truncate丢失将会直接招致数据库不能再承袭使用本文将针对一个相关案例举行详尽的讲解。 案例如下 数据库环境Oracle数据库9.2.0.7 RAC。注由于数据库的事故量体别年夜以是数据库没有举行备份。 反省后缔造的被截断表 SQL select object_name,object_type from dba_objects where object_name like IDL%;
OBJECT_NAME OBJECT_TYPE
------------------- ------------------
IDL_CHAR$ TABLE
IDL_SB4$ TABLE
IDL_UB1$ TABLE
IDL_UB2$ TABLE IDL_UB1$表是分外主要的字典表只需出现妨碍数据库就会出现年夜量的ORA-00600错误全部事故将不能举行。 ORA-00600: internal error code, arguments: [17069],
[0xC0000000DDDFA690], [], [], [], [], [], [] ORA-600 17069错误是一个分外难明决的功效功效出现后数据库的某个跟踪日记很快就会出现暴涨的环境由于IDL系列字典表是记实数据库东西编译信息的损失了此中的数据全部进程、Package等都将无法执行。 字典表感化的阐明); IDL_UB1$ is one of four tables that hold compiled PL/SQL code:
IDL_UB1$
IDL_CHAR$
IDL_UB2$
IDL_SB4$
PL/SQL is based on the programming language Ada. As a result, PL/SQL uses a
variant of Descriptive Intermediate Attributed Notation for Ada (DIANA), which
is a tree-structured intermediate language. It is defined using a meta-notation
called Interface Definition Language (IDL). DIANA provides for communication
internal to compilers and other tools.
At compile time, PL/SQL source code is translated into machine-readable
m-code.Both the DIANA and m-code for a procedure or package are stored in the
database.At run time, they are loaded into the shared (memory) pool. The DIANA is
used to compile dependent procedures; the m-code is simply executed.
These four tables hold the DIANA and the so-code m-code. I think m-code is
short for machine-dependent byte code but there is a sizable machine-indenpendent part
as well. If you have a look at sql.bsq, you can see
that Oracle documents the type column of these tables as follows:
part number not null,
/* part: 0 diana, 1 portable pcode,
2 machine-dependentpcode */ 假如出现更为严肃的环境它将招致年夜量零碎DBMS包见效其从新编译也将更为重大。 规单数据库消除全部ORA-600错误的方式 规复的方式是经过进程运转相关的剧本重修和从新编译全部Procedure/Trigger/Package等东西重重天生这些东西的DIANA和so-code m-code首要包括catlog.sql,catproc.sql等剧本。 看重即使以损耗年夜量的功夫为价格一些ORA-00600错误也必须筹划。 版权声明 原创作品答应转载转载时请务必以超链接方式标明文章 原始来因 、作者信息和本声明。不然将穷究纪律责任。 转载于:https://www.cnblogs.com/zgqjymx/archive/2011/03/07/1974381.html
