<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[我是一只愚]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/iteye_2795</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; iteye_2795]]></copyright><item><title><![CDATA[OGG-01411]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82614391</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82614391</guid><author>iteye_2795</author><pubDate>Tue, 10 Feb 2015 16:14:44 +0800</pubDate><description><![CDATA[
低版本的GG投递到高版本的GG，提示错误OGG-01411
 


【OGG-01411】


Description：
Cannot convert input file {0} with format {1} to output file {2} with format {3}



Cause：

The output trail of the data pump has a...]]></description><category></category></item><item><title><![CDATA[Oracle DBMS_JOB]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82606568</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82606568</guid><author>iteye_2795</author><pubDate>Fri, 10 Oct 2014 15:05:59 +0800</pubDate><description><![CDATA[
--创建测试表create table AAHXL(ID NUMBER,NAME VARCHAR2(100),DT TIMESTAMP(6))--创建存储过程create or replace procedure pro_ins_aahxl isli_id int;-- lti_dt timestamp;beginselect nvl(max(id), 0) + 1 into li_id fr...]]></description><category></category></item><item><title><![CDATA[关于Oracle11gR2用EXP导出时报EXP-00011错误的解决方法]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82567194</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82567194</guid><author>iteye_2795</author><pubDate>Thu, 16 Jan 2014 15:56:03 +0800</pubDate><description><![CDATA[
转自：http://www.360doc.com/content/11/0810/11/7472437_139335252.shtml
在导出数据的过程中发现一个问题。数据库服务器环境为Windows2003+Oracle11gR2,具体现象如下：
执行EXP导出时，部分表提示 EXP-00011:表不存在错误,但是查询user_all_tables视图，此表确实是存在的，并且执行sele...]]></description><category></category></item><item><title><![CDATA[Oracle Group By 默认排序文件]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82549901</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82549901</guid><author>iteye_2795</author><pubDate>Tue, 19 Nov 2013 16:00:57 +0800</pubDate><description><![CDATA[
问题描述：
oracle 9i 下的Group By 后面不加order by ,以前都有默认排序的,现在换成11g后就没有排序了
分析：
9i没有hash group by，10g才有_gby_hash_aggregation_enabled 是隐含参数
普通show parameter查不到的
方法：
1、在SYS用户下执行SQL：
 select ksppinm NAME,...]]></description><category></category></item><item><title><![CDATA[ORA-04031案例一则]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82545874</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82545874</guid><author>iteye_2795</author><pubDate>Fri, 25 Oct 2013 11:43:54 +0800</pubDate><description><![CDATA[
ORA-04031案例一则
Oracle Trouble Shootingtrouble4月 29th, 2011
转自：http://www.laoxiong.net/an-ora-04031-case.html
ORA-04031这个错误，几乎每一个专业的DBA都遇到过。这是一个相当严重的错误，Oracle进程在向SGA申请内存时，如果申请失败，则会报这个错误。大部分情况下是在向SGA...]]></description><category></category></item><item><title><![CDATA[ log4j.xml警告log4j:WARN The content of element type "log4j:configuration" must ma]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82541582</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82541582</guid><author>iteye_2795</author><pubDate>Wed, 25 Sep 2013 13:05:29 +0800</pubDate><description><![CDATA[
原因log4j.xml中文件的位置不对，顺序为：
&amp;lt;renderer&amp;gt;&amp;lt;/renderer&amp;gt;&amp;lt;renderer&amp;gt;&amp;lt;/renderer&amp;gt;&amp;lt;renderer&amp;gt;&amp;lt;/renderer&amp;gt;&amp;lt;appender&amp;gt;&amp;lt;/appender&amp;gt;&amp;lt;appender&amp;gt;&amp;lt;/]]></description><category></category></item><item><title><![CDATA[ORA-00600: internal error code]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82541104</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82541104</guid><author>iteye_2795</author><pubDate>Sun, 22 Sep 2013 16:22:11 +0800</pubDate><description><![CDATA[
ORA-00600: internal error code, arguments: [ktbesc_p lugged] while running Oracle Golden Gate replicate against a plugged in (transported) tablespace

October 19, 2012 by Nakinov · Leave a Comment...]]></description><category></category></item><item><title><![CDATA[Orale分区索引]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82486436</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82486436</guid><author>iteye_2795</author><pubDate>Tue, 09 Apr 2013 14:00:50 +0800</pubDate><description><![CDATA[
表可以按range、hash、list分区，表分区后，其上的索引和普通表上的索引有所不同，oracle对于分区表上的索引分为2类，即局部索引和全局索引，下面分别对这2种索引的特点和局限性做个总结。

局部索引local index

1.        局部索引一定是分区索引，分区键等同于表的分区键，分区数等同于表的分区数，一句话，局部索引的分区机制和表的分区机制一样。
2.       ...]]></description><category></category></item><item><title><![CDATA[在线重定义表(DBMS_REDEFINITION)]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82486239</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82486239</guid><author>iteye_2795</author><pubDate>Mon, 08 Apr 2013 15:42:11 +0800</pubDate><description><![CDATA[
         在系统正在运行，外部有程序正在访问表的同时修改表的定义
         应用场景：对于7*24系统，不能直接修改表的定义，需要在保证正常使用的前提下修改表的定义、结构
         相关包：DBMS_REDEFINITION
执行在线重定义所需要权限：
         角色：EXECUTE_CATALOG_ROLE
         权限：CREATEANYT...]]></description><category></category></item><item><title><![CDATA[ORA-14038 global partitioned index must be prefixed 分区索引]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82482105</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82482105</guid><author>iteye_2795</author><pubDate>Wed, 13 Mar 2013 17:02:38 +0800</pubDate><description><![CDATA[
 
CREATE INDEX INX_TEST_COMP1 ON TEST(ID,LRRQ)
TABLESPACE TEST_IDX
NOLOGGING
   GLOBAL PARTITION BY RANGE (LRRQ)
   (
       PARTITION IDX_TEST_LRRQ_201201 VALUES LESS THAN (TO_DATE('20120201',...]]></description><category></category></item><item><title><![CDATA[Windows7(64位)安装Oracle10g]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82481711</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82481711</guid><author>iteye_2795</author><pubDate>Mon, 11 Mar 2013 15:03:54 +0800</pubDate><description><![CDATA[
 1.下载Oracle安装文件，我下载的是64位且能够在Vista下安装的版本，文件名是为10204_vista_w2k8_x64_production_db.zip


下载地址是：http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10204_winx64_vista_win2k8....]]></description><category></category></item><item><title><![CDATA[essbase的乱码的问题]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82474558</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82474558</guid><author>iteye_2795</author><pubDate>Fri, 25 Jan 2013 00:49:50 +0800</pubDate><description><![CDATA[找到我的电脑右键属性——高级——环境变量，找到系统变量里的esslang，双击打开后将Eglish……那一串数改成SimplifiedChinese_China.MS936@Binary]]></description><category></category></item><item><title><![CDATA[vb6 调用 java webservice 错误之解决]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82449588</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82449588</guid><author>iteye_2795</author><pubDate>Mon, 17 Dec 2012 17:20:29 +0800</pubDate><description><![CDATA[webservice 是 Axis1.2.1
vb6中使用soap toolkit调用webservice
 
开始总是报错
 
解决方法：
修改
在服务端中server-config.wsdd中&amp;lt;globalConfiguration&amp;gt;标签中
增加&amp;lt;parameter name=&quot;dotNetSoapEncFix&quot; value=&quot;true&quot;/&amp;gt;
 
v...]]></description><category></category></item><item><title><![CDATA[exp  报错 PLS-00302-SET_NO_OUTLINES]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82442008</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82442008</guid><author>iteye_2795</author><pubDate>Tue, 13 Nov 2012 14:28:53 +0800</pubDate><description><![CDATA[Subject: PLS-00302-SET_NO_OUTLINES must be declared When Using 10.2 Export Utility
Doc ID: NOTE:339062.1
Applies to:
Oracle Server


 - Enterprise Edition - Version: 10.2.0.1.0
This problem can...]]></description><category></category></item><item><title><![CDATA[ EXECUTE IMMEDIATE及Using (精辟啊) ]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82434409</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82434409</guid><author>iteye_2795</author><pubDate>Thu, 11 Oct 2012 10:05:18 +0800</pubDate><description><![CDATA[
当我们碰到有一类存储名称和过程的参数上都相似时，可以使用execute
immediate
来动态执行这些存储过程，在这次的项目中我有一类用“P_InsertInto_”开头的存储过程，后面是表名如：P_InsertInto_AC01、P_InsertInto_AC02等等，用来给AC01、AC02........这些表插入数据的，我们就只能用execute
immediate
动态执...]]></description><category></category></item><item><title><![CDATA[关于oracle字符集 国家字符集和数据库字符集]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82434105</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82434105</guid><author>iteye_2795</author><pubDate>Tue, 09 Oct 2012 22:32:36 +0800</pubDate><description><![CDATA[在imp一个dmp文件的时候，提示不支持要求的字符集转换（从类型850到852）. 
原理：
  ORACLE多国语言设置是为了支持世界范围的语言与字符集，一般对语言提示，货币形式，排序方式和CHAR,VARCHAR2,CLOB,LONG字段的数据的显示等有效。ORACLE的多国语言设置最主要的两个特性就是国家语言设置与字符集设置，国家语言设置决定了界面或提示使用的语言种类
，字符集决定了数...]]></description><category></category></item><item><title><![CDATA[解决Firefox 10+不能访问biee 11.1.1.5.0]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82340326</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82340326</guid><author>iteye_2795</author><pubDate>Fri, 08 Jun 2012 16:14:19 +0800</pubDate><description><![CDATA[1. 打开火狐浏览器，在地址栏输入about:config

2. 右键 新建→字符串 输入general.useragent.override，确定后在输入Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/9.0

3.刷新浏览器访问biee...]]></description><category></category></item><item><title><![CDATA[Oracle OUI 中的安装目录配置文件]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82338518</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82338518</guid><author>iteye_2795</author><pubDate>Mon, 04 Jun 2012 13:56:36 +0800</pubDate><description><![CDATA[系统盘下:
Oracle\Inventory\ContentsXML\inverntory.xml]]></description><category></category></item><item><title><![CDATA[jdk 1.4 多线程池]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82336487</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82336487</guid><author>iteye_2795</author><pubDate>Tue, 29 May 2012 16:15:07 +0800</pubDate><description><![CDATA[http://backport-jsr166.sourceforge.net/index.php]]></description><category></category></item><item><title><![CDATA[DIV SELECT IE 遮盖]]></title><link>https://blog.youkuaiyun.com/iteye_2795/article/details/82326394</link><guid>https://blog.youkuaiyun.com/iteye_2795/article/details/82326394</guid><author>iteye_2795</author><pubDate>Thu, 03 May 2012 00:15:35 +0800</pubDate><description><![CDATA[经测试解决代码仅在IE浏览器有效。

由于层与下拉框之间的优先级是：下拉框 &gt; 层，因此在显示的时候，会因为优先级的次序而会出现div层被select下拉框遮盖的问题。（如果几个元素都是层的话，我们可以通过层的 z-index 属性来设置）解决办法就是：给层中放一个优先级比下拉框更高的元素（iframe），从而解决此问题！具体解决代码如下：




...]]></description><category></category></item></channel></rss>