<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congni0477的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congni0477</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congni0477]]></copyright><item><title><![CDATA[birthday]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312443</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312443</guid><author>congni0477</author><pubDate>Fri, 19 Sep 2008 15:51:03 +0800</pubDate><description><![CDATA[今天是GF生日，祝她生日快乐,天天开心。
                                                            
                    
          ...]]></description><category></category></item><item><title><![CDATA[～help others～]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312441</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312441</guid><author>congni0477</author><pubDate>Wed, 27 Aug 2008 17:44:41 +0800</pubDate><description><![CDATA[帮助别人解决问题真爽。不仅能帮别人，还能给自己增加经验值，爽啊！！

                                                            
        ...]]></description><category></category></item><item><title><![CDATA[vmware上linux安装9204（二）]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312442</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312442</guid><author>congni0477</author><pubDate>Fri, 22 Aug 2008 19:13:30 +0800</pubDate><description><![CDATA[继续上次的安装步骤，文件里面有详细的步骤。Install_Oracle9204_on_CentOS4.2.rar
                                                         ...]]></description><category></category></item><item><title><![CDATA[linux中设置oracle自动归档]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312452</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312452</guid><author>congni0477</author><pubDate>Fri, 22 Aug 2008 18:30:48 +0800</pubDate><description><![CDATA[在刚刚装完了oracle数据库后自动归档默认是禁用的，所以即使当你打开归档是时候
自动归档（Automatic archival）也是Disabled：我这里测试是用archivelog
SQL&gt; archive lo...]]></description><category></category></item><item><title><![CDATA[vmware下安装oracle9204详细步骤(一)]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312440</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312440</guid><author>congni0477</author><pubDate>Tue, 19 Aug 2008 23:29:50 +0800</pubDate><description><![CDATA[在网上看到好多哥们都在找oracle在vmware+Linux上安装oracle的帖子，自己摸索了下，现
在把自己安装的步骤详细记录如下：
 我的环境：
windowxp＋vmware workstation5.0...]]></description><category></category></item><item><title><![CDATA[data block物理结构介绍]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312451</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312451</guid><author>congni0477</author><pubDate>Fri, 08 Aug 2008 11:45:30 +0800</pubDate><description><![CDATA[data block物理结构介绍链接:http://www.onlineseo.cn/html/200711/10/20071110131812.html
                                    ...]]></description><category></category></item><item><title><![CDATA[hints的详细用法(转)]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312490</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312490</guid><author>congni0477</author><pubDate>Fri, 08 Aug 2008 11:14:39 +0800</pubDate><description><![CDATA[基于代价的优化器是很聪明的，在绝大多数情况下它会选择正确的优化器，减轻了DBA的负担。但有时它也聪明反被聪明误，选择了很差的执行计划，使某个语句的执行变得奇慢无比。此时就需要DBA进行人为的干预，告诉优化器使用我们指定...]]></description><category></category></item><item><title><![CDATA[删除表中重复记录总结]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312521</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312521</guid><author>congni0477</author><pubDate>Mon, 04 Aug 2008 16:26:44 +0800</pubDate><description><![CDATA[方法一： 

delete from tb_channel a where a.rowid in 
(select max(b.rowid) from tb_channle b 
where a.policyno...]]></description><category></category></item><item><title><![CDATA[数据库启动常见问题]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312448</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312448</guid><author>congni0477</author><pubDate>Fri, 01 Aug 2008 17:22:32 +0800</pubDate><description><![CDATA[常见的数据库不能启动的原因：
 (蓝色字体为sqlplus界面操作，红色为注释)
一、日志文件丢失或损坏
 日志文件的恢复：
 1、非归档模式
 SQL&gt;startup moun...]]></description><category></category></item><item><title><![CDATA[详解drop/delete/truncate]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312438</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312438</guid><author>congni0477</author><pubDate>Thu, 31 Jul 2008 18:01:56 +0800</pubDate><description><![CDATA[老在pub里转，也能找到很多实用的东东。
delete/truncate 只删除数据不删除表，索引的结构。drop 将删除表的结构被依赖的 index/constrain/trigger，依赖于该表的 procedure/fu...]]></description><category></category></item><item><title><![CDATA[查询表的PK,FK,TABLENAME]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312487</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312487</guid><author>congni0477</author><pubDate>Thu, 31 Jul 2008 17:42:43 +0800</pubDate><description><![CDATA[看到很多在群里问如何查找表的主键，外键，其实最主要是的要了解 
 user_constraints的结构。下面可以实现。

 SQL&gt; col 外键拥有者 format a...]]></description><category></category></item><item><title><![CDATA[ORACLE用户常用查询SQL]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312484</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312484</guid><author>congni0477</author><pubDate>Wed, 23 Jul 2008 10:58:14 +0800</pubDate><description><![CDATA[查看当前用户的缺省表空间
　　SQL&gt;select username,default_tablespace from user_users;
　　查看当前用户的角色
　　SQL&gt;select * from us...]]></description><category></category></item><item><title><![CDATA[增加TABLESPACE的大小]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312485</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312485</guid><author>congni0477</author><pubDate>Fri, 18 Jul 2008 13:39:15 +0800</pubDate><description><![CDATA[在真正的生产库中,可能用的少,因为在数在创建数据库时就会规划好.在这里只不过是写出一些方法来实现增加tablespace的大小,对测试库还是有一定帮助的.
方法一:为你要增加的表空间添加一个datafile(数据文件)
OS...]]></description><category></category></item><item><title><![CDATA[TRANCATE/DELETE/DROP 的详细区别(转)]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312486</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312486</guid><author>congni0477</author><pubDate>Thu, 17 Jul 2008 18:14:13 +0800</pubDate><description><![CDATA[对delete,trancate,drop的一个详细的区别.
delete/truncate 只删除数据不删除表，索引的结构。
drop 将删除表的结构被依赖的 index/constrain/trigger，依赖于该表的 ...]]></description><category></category></item><item><title><![CDATA[新手快速掌握ORACLE的启/关方式]]></title><link>https://blog.youkuaiyun.com/congni0477/article/details/100312437</link><guid>https://blog.youkuaiyun.com/congni0477/article/details/100312437</guid><author>congni0477</author><pubDate>Thu, 17 Jul 2008 18:01:58 +0800</pubDate><description><![CDATA[这个总结是主要针对入门的新手,目的是了解oracle数据库的开/关方式 
一、几种启动方式： 


1、startup nomount非安装启动，这种方式启动下可执行：重建控制文件、重建数据库 

启动instanc...]]></description><category></category></item></channel></rss>