Tue, 07 Jul 2009 17:31:00 GMT止境的专栏http://blog.csdn.net/Chrisjian/http://blog.csdn.net/Chrisjian/archive/2009/07/07/4328853.aspxhttp://blog.csdn.net/Chrisjian/comments/4328853.aspx0http://blog.csdn.net/Chrisjian/comments/commentRss/4328853.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4328853在这里，不谈那些大的方面，比如了解整个IT环境整体情况，假设你已经知道了这些，接下来需要面对的就是这些一个个活生生的database了。这里总结了一些一般的思路来面对一个全先的database，从而快速了解你面对的环境概要。 <br />　　这也不是教科，只是一些心得和体会，对于这种问题，每个人的认识的角度是不一样的。欢迎大家继续补充完善。<br />1、先要了解当前的Oracle 数据库的版本和平台和相关信息<br />　　这个很重要，忙乎了半天还知道你的数据库是哪个版本，跑在什么系统上，那岂不是很悲哀，所以我个人认为这是第一步需要了解的。下面的这些脚本可以帮助你获取你需要的相关信息。<br /><br />　　select * from v$version; <br />　　select * from dba_registry_database; <br />　　select dbid, name, open_mode, database_role, platform_name from v$instance; <br />　　select dbms_utility.port_<img src ="http://blog.csdn.net/Chrisjian/aggbug/4328853.aspx" width = "1" height = "1" /><img src="http://www1.feedsky.com/t1/242015993/Chrisjian/csdn.net/s.gif?r=http://blog.csdn.net/Chrisjian/archive/2009/07/07/4328853.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242015993/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242015993/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 08 Jul 2009 01:31:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2009/07/07/4328853.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2009/07/07/4328853.aspx三少http://blog.csdn.net/Chrisjian/archive/2009/07/07/4328853.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242015993/1140990http://blog.csdn.net/Chrisjian/archive/2009/04/16/4083651.aspxhttp://blog.csdn.net/Chrisjian/comments/4083651.aspx0http://blog.csdn.net/Chrisjian/comments/commentRss/4083651.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4083651在SQL Server的存储过程中, 可以非常方便地使用临时表#TempTable, 你可以随意地将数据插入到临时表, 可以将临时表的记录作为存储过程的结果集. #TempTable用过后, 它就干干净净地消失了, 包括表的structure.而Oracle的临时表是global temporary table, 这表明它的定义是persistent, 只是内容是临时的.那么在Oracle中如何才能做到像SQL Server一样的临时表呢? Oracle为我们提供了PL/SQL Table表变量, 其实就是索引表.<img src ="http://blog.csdn.net/Chrisjian/aggbug/4083651.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242015994/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242015994/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 16 Apr 2009 20:22:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2009/04/16/4083651.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2009/04/16/4083651.aspx三少http://blog.csdn.net/Chrisjian/archive/2009/04/16/4083651.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242015994/1140990http://blog.csdn.net/Chrisjian/archive/2009/04/16/4083338.aspxhttp://blog.csdn.net/Chrisjian/comments/4083338.aspx0http://blog.csdn.net/Chrisjian/comments/commentRss/4083338.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4083338plsql编程 一 集合<img src ="http://blog.csdn.net/Chrisjian/aggbug/4083338.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242015995/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242015995/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 16 Apr 2009 18:37:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2009/04/16/4083338.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2009/04/16/4083338.aspx三少http://blog.csdn.net/Chrisjian/archive/2009/04/16/4083338.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242015995/1140990http://blog.csdn.net/Chrisjian/archive/2009/04/16/4083285.aspxhttp://blog.csdn.net/Chrisjian/comments/4083285.aspx0http://blog.csdn.net/Chrisjian/comments/commentRss/4083285.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4083285PLSQL开发，触发器<img src ="http://blog.csdn.net/Chrisjian/aggbug/4083285.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242015996/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242015996/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 16 Apr 2009 18:22:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2009/04/16/4083285.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2009/04/16/4083285.aspx三少http://blog.csdn.net/Chrisjian/archive/2009/04/16/4083285.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242015996/1140990http://blog.csdn.net/Chrisjian/archive/2008/09/25/2978507.aspxhttp://blog.csdn.net/Chrisjian/comments/2978507.aspx0http://blog.csdn.net/Chrisjian/comments/commentRss/2978507.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=29785071 首先下载Subversion Windows版本的服务器软件，<br />  下载地址如下：<br />  http://aukulin.blog.iusesvn.com/html/71/t-1771.html<br />  如svn-1.4.5-setup.exe，然后执行安装，<br />  安装目录如：C:\program file\subversion，<br />  然后这是一下系统的环境变量Path，<br />  将Subversion的bin路径加入到系统的path中。<br /><br />2 创建Subersion库：<br />  首先建立一个目录存放Subversion的库，<br />  在该库中存放所以的Subversion项目，如D:\repository\subversion<br /><br />3 创建一个新的Subversion项目。<br />  只需执行： svnadmin<img src ="http://blog.csdn.net/Chrisjian/aggbug/2978507.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242015997/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242015997/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 25 Sep 2008 22:41:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2008/09/25/2978507.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2008/09/25/2978507.aspx三少http://blog.csdn.net/Chrisjian/archive/2008/09/25/2978507.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242015997/1140990http://blog.csdn.net/Chrisjian/archive/2008/01/30/2073761.aspxhttp://blog.csdn.net/Chrisjian/comments/2073761.aspx0http://blog.csdn.net/Chrisjian/comments/commentRss/2073761.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2073761合并redhat企业4版比较好弄点，前天在论坛下的5CD的企业5版，怎么合并在启动的时候都是光盘校验失败。刚没事干翻baidu，搞出来一篇老外的帖子，我看这不错，给我自己做的DVD加了校验就通过了。<img src ="http://blog.csdn.net/Chrisjian/aggbug/2073761.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242015998/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242015998/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 31 Jan 2008 01:50:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2008/01/30/2073761.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2008/01/30/2073761.aspx三少http://blog.csdn.net/Chrisjian/archive/2008/01/30/2073761.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242015998/1140990http://blog.csdn.net/Chrisjian/archive/2007/03/23/1538806.aspxhttp://blog.csdn.net/Chrisjian/comments/1538806.aspx0http://blog.csdn.net/Chrisjian/comments/commentRss/1538806.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1538806数据仓库原理<img src ="http://blog.csdn.net/Chrisjian/aggbug/1538806.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242015999/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242015999/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 23 Mar 2007 23:32:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2007/03/23/1538806.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2007/03/23/1538806.aspx三少http://blog.csdn.net/Chrisjian/archive/2007/03/23/1538806.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242015999/1140990http://blog.csdn.net/Chrisjian/archive/2007/03/23/1538801.aspxhttp://blog.csdn.net/Chrisjian/comments/1538801.aspx1http://blog.csdn.net/Chrisjian/comments/commentRss/1538801.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1538801数据仓库ETL流程规范<img src ="http://blog.csdn.net/Chrisjian/aggbug/1538801.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242016000/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242016000/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 23 Mar 2007 23:28:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2007/03/23/1538801.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2007/03/23/1538801.aspx三少http://blog.csdn.net/Chrisjian/archive/2007/03/23/1538801.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242016000/1140990http://blog.csdn.net/Chrisjian/archive/2007/02/20/1512087.aspxhttp://blog.csdn.net/Chrisjian/comments/1512087.aspx0http://blog.csdn.net/Chrisjian/comments/commentRss/1512087.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1512087Memory Notification<img src ="http://blog.csdn.net/Chrisjian/aggbug/1512087.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242016001/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242016001/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 21 Feb 2007 03:34:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2007/02/20/1512087.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2007/02/20/1512087.aspx三少http://blog.csdn.net/Chrisjian/archive/2007/02/20/1512087.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242016001/1140990http://blog.csdn.net/Chrisjian/archive/2006/12/31/1471404.aspxhttp://blog.csdn.net/Chrisjian/comments/1471404.aspx0http://blog.csdn.net/Chrisjian/comments/commentRss/1471404.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1471404IV) 性能相关内容 <img src ="http://blog.csdn.net/Chrisjian/aggbug/1471404.aspx" width = "1" height = "1" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/Chrisjian/242016002/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/Chrisjian/242016002/art01.gif" onerror="this.style.display='none'" /></a></p>Mon, 01 Jan 2007 01:32:00 +0800三少http://blog.csdn.net/Chrisjian/archive/2006/12/31/1471404.aspx#Feedbackhttp://blog.csdn.net/Chrisjian/archive/2006/12/31/1471404.aspx三少http://blog.csdn.net/Chrisjian/archive/2006/12/31/1471404.aspxhttp://blog.csdn.net/Chrisjian/feed.aspxcsdn.net/Chrisjian/~1141002/242016002/1140990