[转载]ORA-00942 表或视图不存在 问题的解决

最新推荐文章于 2024-01-31 15:51:18 发布
最新推荐文章于 2024-01-31 15:51:18 发布
阅读量3.7k 收藏
点赞数
  
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  
 <html xmlns="http://www.w3.org/1999/xhtml">
  
 <head>
  
 <script type="text/javascript" src="http://c.csdnimg.cn/pubfooter/js/tracking.js" charset="utf-8"></script>
  
 <script type="text/javascript">
 var protocol = window.location.protocol;
 document.write('<script type="text/javascript" src="' + protocol + '//csdnimg.cn/pubfooter/js/repoAddr2.js?v=' + Math.random() + '"></' + 'script>');
 </script>
  
  
 <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
  
 <title>[转载]ORA-00942 表或视图不存在 问题的解决 - evilcry2012的专栏
 - 博客频道 - CSDN.NET</title>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <meta name="description" content="[转载]ORA-00942&#160;表或视图不存在&#160;问题的解决&#160;(2012-07-09 14:46:18)转载▼标签：&#160;转载分类：&#160;Oracle原文地址：表或视图不存在&#160;问题的解决 style=text-decoration:none; color:rgb(55,133,80)&gt;ORA-00942&#160;表或视图不存在&#160;问" />
 <script src="http://static.blog.csdn.net/scripts/jquery.js" type="text/javascript"></script>
 <script type="text/javascript" src="http://static.blog.csdn.net/scripts/jquery-version.js"></script>
 <script type="text/javascript" src="http://static.blog.csdn.net/scripts/ad.js?v=1.1"></script>
 <!--new top-->
 <link rel="stylesheet" href="http://c.csdnimg.cn/public/common/toolbar/css/index.css"> <!--new top-->
  
 <!-- ad begin -->
 <script language="javascript" type="text/javascript" src="http://ads.csdn.net/js/tracking.js"></script>
 <!-- ad end-->
  
 <link rel="Stylesheet" type="text/css" href="http://static.blog.csdn.net/skin/default/css/style.css?v=1.1" />
 <link id="RSSLink" title="RSS" type="application/rss+xml" rel="alternate" href="/evilcry2012/rss/list" />
 <link rel="shortcut icon" href="http://c.csdnimg.cn/public/favicon.ico" />
 <link type="text/css" rel="stylesheet" href="http://static.blog.csdn.net/scripts/SyntaxHighlighter/styles/default.css" />
  
  
  
 <script>
 var _hmt = _hmt || [];
 (function () {
 var hm = document.createElement("script");
 hm.src = "//hm.baidu.com/hm.js?6bcd52f51e9b3dce32bec4a3997715ac";
 var s = document.getElementsByTagName("script")[0];
 s.parentNode.insertBefore(hm, s);
 })();
 </script>
  
 </head>
 <body>
  
  
 <!-- 广告位开始 -->
 <ins data-revive-zoneid="149" data-revive-id="8c38e720de1c90a6f6ff52f3f89c4d57"></ins>
 <!-- 广告位结束 -->
  
  
  
 <!--new top-->
 <script id="toolbar-tpl-scriptId" fixed="true" prod="blog" skin="black" src="http://c.csdnimg.cn/public/common/toolbar/js/html.js" type="text/javascript"></script>
 <!--new top-->
 <div id="container">
 <div id="header">
 <div class="header">
 <div id="blog_title">
 <h2>
 <a href="http://blog.csdn.net/evilcry2012">evilcry2012的专栏</a></h2>
 <h3></h3>
 <div class="clear">
 </div>
 </div>
 <div class="clear">
 </div>
  
  
 </div>
 </div>
 <div id="navigator">
 <div class="navigator_bg">
 </div>
 <div class="navigator">
 <ul>
 <li id="btnContents"><a href="http://blog.csdn.net/evilcry2012?viewmode=contents"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_mulu'])">
 <img src="http://static.blog.csdn.net/images/ico_list.gif">目录视图</span></a></li>
 <li id="btnView"><a href="http://blog.csdn.net/evilcry2012?viewmode=list"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_zhaiyao'])">
 <img src="http://static.blog.csdn.net/images/ico_summary.gif">摘要视图</span></a></li>
 <li id="btnRss"><a href="http://blog.csdn.net/evilcry2012/rss/list"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_RSS'])">
 <img src="http://static.blog.csdn.net/images/ico_rss.gif">订阅</span></a></li>
  
  
 </ul>
 </div>
 </div>
 <script type="text/javascript">
 var username = "evilcry2012";
 var _blogger = username;
 var blog_address = "http://blog.csdn.net/evilcry2012";
 var static_host = "http://static.blog.csdn.net";
 var currentUserName = "cyj_20170320";
 </script>
  
 <div id="body">
 <div id="main">
 <div class="main">
 <div class="ad_class">
 <div class="notice tracking-ad" data-mod='popu_3' >
  
  
 <a href="http://blog.csdn.net/blogdevteam/article/details/63692002">
 <font color=red> CSDN日报20170319——《人工智能风口， Python 程序员的狂欢与企业主的哀嚎》</font></a>
  
 &nbsp;&nbsp;&nbsp;&nbsp
  
 <a href="http://blog.csdn.net/turingbooks/article/details/58072986">
 <font color=blue>程序员2月书讯
 </font></a>
 &nbsp;&nbsp;&nbsp;&nbsp
  
 <a href="http://blog.csdn.net/blogdevteam/article/details/60961185">
 <font color=red>博客一键搬家活动开始啦
 </font></a>
  
 </div> </div>
  
  
  
  
  
 <link href="http://static.blog.csdn.net/css/comment1.css" type="text/css" rel="stylesheet" />
 <link href="http://static.blog.csdn.net/css/style1.css" type="text/css" rel="stylesheet" />
 <script language='JavaScript' type='text/javascript' src='http://download.csdn.net/js/jquery.cookie.js'></script>
 <script type="text/javascript" src="http://c.csdnimg.cn/rabbit/search-service/main.js"></script>
 <link rel="stylesheet" href="http://static.blog.csdn.net/public/res-min/markdown_views.css?v=1.0" />
 <link rel="stylesheet" href="http://static.blog.csdn.net/css/category.css?v=1.0" />
 <script type="text/javascript" src="http://static.blog.csdn.net/public/res/bower-libs/MathJax/MathJax.js?config=TeX-AMS_HTML"></script>
 <script type="text/javascript" src="http://static.blog.csdn.net/scripts/web-storage-cache.min.js"></script>
 <script type="text/javascript" src="http://static.blog.csdn.net/scripts/replace.min.js"></script>
  
  
  
  
 <script type="text/ecmascript">
 window.quickReplyflag = true;
  
 var isBole = false;
  
  
 var fasrc="http://my.csdn.net/my/favorite/miniadd?t=%5b%e8%bd%ac%e8%bd%bd%5dORA-00942+%e8%a1%a8%e6%88%96%e8%a7%86%e5%9b%be%e4%b8%8d%e5%ad%98%e5%9c%a8+%e9%97%ae%e9%a2%98%e7%9a%84%e8%a7%a3%e5%86%b3&u=http://blog.csdn.net/evilcry2012/article/details/51487298"
  
 </script>
 <div id="article_details" class="details">
 <div class="article_title">
 <span class="ico ico_type_Repost"></span>
  
  
 <h1>
 <span class="link_title"><a href="/evilcry2012/article/details/51487298">
 [转载]ORA-00942 表或视图不存在 问题的解决
 </a></span>
 </h1>
 </div>
  
  
  
 <div class="article_manage clearfix">
 <div class="article_r">
 <span class="link_postdate">2016-05-24 08:33</span>
 <span class="link_view" title="阅读次数">960人阅读</span>
 <span class="link_comments" title="评论次数"> <a href="#comments" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_pinglun'])">评论</a>(0)</span>
 <span class="link_collect tracking-ad" data-mod="popu_171"> <a href="javascript:void(0);" onclick="javascript:collectArticle('%5b%e8%bd%ac%e8%bd%bd%5dORA-00942+%e8%a1%a8%e6%88%96%e8%a7%86%e5%9b%be%e4%b8%8d%e5%ad%98%e5%9c%a8+%e9%97%ae%e9%a2%98%e7%9a%84%e8%a7%a3%e5%86%b3','51487298');return false;" title="收藏">收藏</a></span>
 <span class="link_report"> <a href="#report" onclick="javascript:report(51487298,2);return false;" title="举报">举报</a></span>
  
 </div>
 </div>
 <div class="embody" style="display:none" id="embody">
 <span class="embody_t">本文章已收录于：</span>
 <div class="embody_c" id="lib" value="{&quot;err&quot;:0,&quot;msg&quot;:&quot;ok&quot;,&quot;data&quot;:[]}"></div>
 </div>
 <style type="text/css">
 .embody{
 padding:10px 10px 10px;
 margin:0 -20px;
 border-bottom:solid 1px #ededed;
 }
 .embody_b{
 margin:0 ;
 padding:10px 0;
 }
 .embody .embody_t,.embody .embody_c{
 display: inline-block;
 margin-right:10px;
 }
 .embody_t{
 font-size: 12px;
 color:#999;
 }
 .embody_c{
 font-size: 12px;
 }
 .embody_c img,.embody_c em{
 display: inline-block;
 vertical-align: middle;
 }
 .embody_c img{
 width:30px;
 height:30px;
 }
 .embody_c em{
 margin: 0 20px 0 10px;
 color:#333;
 font-style: normal;
 }
 </style>
 <script type="text/javascript">
 $(function () {
 try
 {
 var lib = eval("("+$("#lib").attr("value")+")");
 var html = "";
 if (lib.err == 0) {
 $.each(lib.data, function (i) {
 var obj = lib.data[i];
 //html += '<img src="' + obj.logo + '"/>' + obj.name + "&nbsp;&nbsp;";
 html += ' <a href="' + obj.url + '" target="_blank">';
 html += ' <img src="' + obj.logo + '">';
 html += ' <em><b>' + obj.name + '</b></em>';
 html += ' </a>';
 });
 if (html != "") {
 setTimeout(function () {
 $("#lib").html(html);
 $("#embody").show();
 }, 100);
 }
 }
 } catch (err)
 { }
  
 });
 </script>
 <div class="category clearfix">
 <div class="category_l">
 <img src="http://static.blog.csdn.net/images/category_icon.jpg">
 <span>分类：</span>
 </div>
 <div class="category_r">
 <label onclick="GetCategoryArticles('3126221','evilcry2012','top','51487298');">
 <span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_fenlei']);">Oracle<em>（170）</em></span>
 <img class="arrow-down" src="http://static.blog.csdn.net/images/arrow_triangle _down.jpg" style="display:inline;">
 <img class="arrow-up" src="http://static.blog.csdn.net/images/arrow_triangle_up.jpg" style="display:none;">
 <div class="subItem">
 <div class="subItem_t"><a href="http://blog.csdn.net/evilcry2012/article/category/3126221" target="_blank">作者同类文章</a><i class="J_close">X</i></div>
 <ul class="subItem_l" id="top_3126221">
 </ul>
 </div>
 </label>
 </div>
 </div>
 <script type="text/javascript" src="http://static.blog.csdn.net/scripts/category.js"></script>
  
  
  
  
  
  
  
 <div id="article_content" class="article_content">
  
 <div class="articalTitle" style="clear:both; line-height:20px; padding-bottom:10px; color:rgb(73,73,73); font-family:Verdana,宋体,sans-serif; font-size:12px">
 <h2 id="t_625e1bbd01016jio" class="titName SG_txta" style="margin:0px; padding:0px; border:0px; list-style:none; color:rgb(55,133,80); font-size:18px; font-family:微软雅黑,黑体; font-weight:300; display:inline">
 [转载]ORA-00942&nbsp;表或视图不存在&nbsp;问题的解决</h2>
 &nbsp;<span class="time SG_txtc" style="color:rgb(135,135,135); white-space:nowrap; font-family:Arial; font-size:10px; margin-left:5px; margin-right:13px">(2012-07-09 14:46:18)</span>
 <div class="turnBoxzz" style="float:right"><a target="_blank" class="SG_aBtn SG_aBtn_ico SG_turn" style="padding:0px 0px 0px 3px; overflow:hidden; white-space:nowrap; display:inline-block; margin-right:6px; position:relative; letter-spacing:5px; width:86px; zoom:1; font-size:12px!important"><cite style="font-style:normal; line-height:23px; padding:0px 20px 0px 32px; height:23px; min-width:1px; overflow-x:visible; width:34px; display:inline-block!important; font-size:12px!important"><img class="SG_icon SG_icon111" src="http://simg.sinajs.cn/blog7style/images/common/sg_trans.gif" width="15" height="15" align="absmiddle" alt="" style="margin:0px; padding:0px; border:0px; list-style:none; position:absolute; left:11px; top:4px">转载<span class="arrow" style="font-size:7px; position:absolute; right:5px; top:2px">▼</span></cite></a></div>
 </div>
 <div class="articalTag" id="sina_keyword_ad_area" style="width:690px; clear:both; word-break:break-all; line-height:20px; color:rgb(73,73,73); font-family:Verdana,宋体,sans-serif; font-size:12px">
 <table style="margin:0px; padding:0px">
 <tbody>
 <tr>
 <td class="blog_tag" style="margin:0px; padding:0px 10px 0px 0px; font-family:宋体; vertical-align:top">
 <span class="SG_txtb" style="color:rgb(135,135,135)">标签：</span>&nbsp;
 <h3 style="margin:0px 5px 0px 0px; padding:0px; border:0px; list-style:none; display:inline; font-size:12px; font-weight:normal">
 <a target="_blank" href="http://search.sina.com.cn/?c=blog&amp;q=%D7%AA%D4%D8&amp;by=tag" target="_blank" style="text-decoration:none; color:rgb(55,133,80); white-space:nowrap">转载</a></h3>
 </td>
 <td class="blog_class" style="margin:0px; padding:0px; font-family:宋体; vertical-align:top; width:220px; white-space:nowrap">
 <span class="SG_txtb" style="color:rgb(135,135,135)">分类：</span>&nbsp;<a target="_blank" target="_blank" href="http://blog.sina.com.cn/s/articlelist_1650334653_2_1.html" style="text-decoration:none; color:rgb(55,133,80)">Oracle</a></td>
 </tr>
 </tbody>
 </table>
 </div>
 <div id="sina_keyword_ad_area2" class="articalContent " style="width:690px; clear:both; padding-top:18px; font-size:14px; padding-bottom:30px; overflow:hidden; font-family:simsun; word-wrap:normal; word-break:normal; line-height:21px; color:rgb(73,73,73)">
 <div class="blogzz_abstract borderc" style="border-top-width:1px; border-style:dotted none none; border-top-color:rgb(204,204,204); padding-top:15px; margin:20px 0px">
 <div class="blogzz_ainfo" style="margin-bottom:12px"><span style="word-wrap:normal; word-break:normal; margin-right:25px"><strong>原文地址：</strong><a target="_blank" target="_blank" href="http://blog.sina.com.cn/s/blog_4563cd990100lobx.html" title="ORA-00942&nbsp;&lt;wbr&gt;表或视图不存在&nbsp;&lt;wbr&gt;问题的解决" style="text-decoration:none; color:rgb(55,133,80)">ORA-00942&nbsp;<wbr>表或视图不存在&nbsp;<wbr>问题的解决</a></span><span style="word-wrap:normal; word-break:normal"><strong>作者：</strong><a target="_blank" href="http://blog.sina.com.cn/u/1164168601" title="Hero" target="_blank" style="text-decoration:none; color:rgb(55,133,80)">Hero</a></span></div>
 <div class="blogzz_acon">查杀系统死锁的sql,最近想改造成存储过程,如下:
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">CREATE</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">OR</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">REPLACE</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">PROCEDURE</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">HERO_KILLLOCKSESSION</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 &nbsp;<wbr></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">(OUT_COUNT</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">OUT</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">NUMBER</span><span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">,
 OUT_CUR</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">OUT</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">ZHUOCAIDEV.FUXJPACKAGE.FUXJRESULTSET)</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">IS</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">&nbsp;<wbr></span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">BEGIN</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">&nbsp;<wbr></span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">SELECT</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">COUNT</span><span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">(*)</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">INTO</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">OUT_COUNT</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">FROM</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">V$LOCKED_OBJECT
 L, DBA_OBJECTS B, V$SESSION X, V$PROCESS C</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">WHERE</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">B.OBJECT_ID
 = L.OBJECT_ID</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">AND</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">L.SESSION_ID
 = X.SID</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">AND</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">C.ADDR
 = X.PADDR;</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">&nbsp;<wbr></span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">OPEN</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">OUT_CUR</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">FOR</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">SELECT</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">B.OWNER,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span>&nbsp;B.OBJECT_NAME,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span>&nbsp;L.SESSION_ID,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span>&nbsp;X.SERIAL#,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span>&nbsp;X.USERNAME,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span>&nbsp;X.LOGON_TIME,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span>&nbsp;<span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span>L.LOCKED_MODE,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:blue; font-family:'Courier new'; background:silver">'alter
 system kill session '''</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">|| X.SID ||</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:blue; font-family:'Courier new'; background:silver">','</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">||
 X.SERIAL# ||</span><span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:blue; font-family:'Courier new'; background:silver">''''</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">KILLSQL,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span>&nbsp;C.SPID</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">AS</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">OS_PROCESS_ID,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span>&nbsp;C.PID,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:blue; font-family:'Courier new'; background:silver">'ps
 -ef | grep '</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">|| C.SPID</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">AS</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">CHECK_OS_PROCESS_COMMAND,</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:blue; font-family:'Courier new'; background:silver">'kill
 -9 '</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">|| C.SPID</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">AS</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">KILL_OS_PROCESS_COMMAND</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">FROM</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">V$LOCKED_OBJECT
 L, DBA_OBJECTS B, V$SESSION X, V$PROCESS C</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">WHERE</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">B.OBJECT_ID
 = L.OBJECT_ID</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">AND</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">L.SESSION_ID
 = X.SID</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">AND</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">C.ADDR
 = X.PADDR</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="word-wrap:normal; word-break:normal">&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr>&nbsp;<wbr></span></span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">ORDER</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">BY</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">X.LOGON_TIME</span>&nbsp;<span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">ASC</span><span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">;</span></p>
 <p align="left" style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">&nbsp;<wbr></span></p>
 <p style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:teal; font-family:'Courier new'; background:silver">END</span><span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">;</span></p>
 <p style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">在系统sys模式下可以正常运行,在zhuocaidev下面报&nbsp;<span style="color:#990000; word-wrap:normal; word-break:normal">ORA-00942
 表或视图不存在</span></span></p>
 <p style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver"><span style="font-family:Arial; color:#000000; word-wrap:normal; word-break:normal; background-color:rgb(255,255,255)">但在正常的SQL中是能够对V$LOCKED_OBJECT
 , DBA_OBJECTS , V$SESSION , V$PROCESS 进行访问的。猜测估计是权限问题,联想到运行statspack报告的perfstat用户没有此问题，查看下statspack的创建脚本，发现需要单独使用下面语句进行赋权：</span></span></p>
 <p style="margin-top:0px; margin-bottom:5px; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 &nbsp;<wbr></p>
 <p style="margin-top:0px; margin-bottom:5px; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 &nbsp;<wbr></p>
 <p style="margin-top:0px; margin-bottom:5px; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span style="word-wrap:normal; word-break:normal; color:rgb(51,102,255)">grant select on V_$SESSION to scott;</span></p>
 <p style="margin-top:0px; margin-bottom:5px; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 以sys用户登录,执行如下授权语句:</p>
 <p style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">grant select on SYS.V_$LOCKED_OBJECT TO zhuocaidev;<br>
 grant select on&nbsp;<wbr>&nbsp;SYS.DBA_OBJECTS TO zhuocaidev;<br>
 grant select on SYS.V_$SESSION&nbsp;<wbr>&nbsp;TO zhuocaidev;<br>
 grant select on SYS.V_$PROCESS TO zhuocaidev;</span></p>
 <p style="margin:0cm 0cm 0pt; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal">
 <span lang="EN-US" style="word-wrap:normal; word-break:normal; line-height:22px; font-size:11pt; color:navy; font-family:'Courier new'; background:silver">在以zhuocaidev登录,可以正常创建存储过程.</span></p>
 </div>
 </div>
 </div>
  
 </div>
  
  
  
  
 <!-- Baidu Button BEGIN -->
  
  
  
  
 <div class="bdsharebuttonbox tracking-ad" style="float: right;" data-mod="popu_172">
 <a href="#" class="bds_more" data-cmd="more" style="background-position:0 0 !important; background-image: url(http://bdimg.share.baidu.com/static/api/img/share/icons_0_16.png?v=d754dcc0.png) !important"></a>
 <a href="#" class="bds_qzone" data-cmd="qzone" title="分享到QQ空间" style="background-position:0 -52px !important"></a>
 <a href="#" class="bds_tsina" data-cmd="tsina" title="分享到新浪微博"style="background-position:0 -104px !important"></a>
 <a href="#" class="bds_tqq" data-cmd="tqq" title="分享到腾讯微博"style="background-position:0 -260px !important"></a>
 <a href="#" class="bds_renren" data-cmd="renren" title="分享到人人网"style="background-position:0 -208px !important"></a>
 <a href="#" class="bds_weixin" data-cmd="weixin" title="分享到微信"style="background-position:0 -1612px !important" ></a>
 </div>
 <script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'http://bdimg.share.baidu.com/static/api/js/share.js?v=89860593.js?cdnversion=' + ~(-new Date() / 36e5)];</script>
 <!-- Baidu Button END -->
  
 <link rel="stylesheet" href="http://static.blog.csdn.net/css/blog_detail.css" />
  
  
 <!--172.16.140.12-->
  
 <!-- Baidu Button BEGIN -->
 <script type="text/javascript" id="bdshare_js" data="type=tools&amp;uid=1536434" ></script>
 <script type="text/javascript" id="bdshell_js"></script>
 <script type="text/javascript">
 document.getElementById("bdshell_js").src = "http://bdimg.share.baidu.com/static/js/shell_v2.js?cdnversion=" + Math.ceil(new Date()/3600000)
 </script>
 <!-- Baidu Button END -->
  
  
  
  
 <div id="digg" ArticleId="51487298" >
 <dl id="btnDigg" class="digg digg_enable" onclick="btndigga();">
  
 <dt>顶</dt>
 <dd>0</dd>
 </dl>
  
  
 <dl id="btnBury" class="digg digg_enable" onclick="btnburya();">
  
 <dt>踩</dt>
 <dd>0</dd>
 </dl>
  
 </div>
 <div class="tracking-ad" data-mod="popu_222"><a href="javascript:void(0);" >&nbsp;</a> </div>
 <div class="tracking-ad" data-mod="popu_223"> <a href="javascript:void(0);" >&nbsp;</a></div>
 <script type="text/javascript">
 function btndigga() {
 $(".tracking-ad[data-mod='popu_222'] a").click();
 }
 function btnburya() {
 $(".tracking-ad[data-mod='popu_223'] a").click();
 }
 </script>
  
 <ul class="article_next_prev">
 <li class="prev_article"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_shangyipian']);location.href='/evilcry2012/article/details/51483460';">上一篇</span><a href="/evilcry2012/article/details/51483460" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_shangyipian'])">ava.lang.Class.getDeclaredMethod()方法</a></li>
 <li class="next_article"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_xiayipian']);location.href='/evilcry2012/article/details/51492397';">下一篇</span><a href="/evilcry2012/article/details/51492397" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_xiayipian'])">java clone（）</a></li>
 </ul>
  
 <div style="clear:both; height:10px;"></div>
  
  
 <div class="similar_article" style="display:none">
 <h4>我的同类文章</h4>
 <div class="similar_c"style="margin:20px 0px 0px 0px">
 <div class="similar_c_t">
 <label class="similar_cur">
 <span style="cursor:pointer" onclick="GetCategoryArticles('3126221','evilcry2012','foot','51487298');">Oracle<em>（170）</em></span>
 </label>
 </div>
  
 <div class="similar_wrap tracking-ad" data-mod="popu_141" style="max-height:195px;">
 <a href="http://blog.csdn.net" style="display:none">http://blog.csdn.net</a>
 <ul class="similar_list fl">
 </ul>
  
 <ul class="similar_list fr">
 </ul>
 </div>
 </div>
 </div>
 <script type="text/javascript">
 $(function () {
 GetCategoryArticles('3126221', 'evilcry2012','foot','51487298');
 });
 </script>
  
 </div>
  
 <div>
 <ins data-revive-zoneid="205" data-revive-id="8c38e720de1c90a6f6ff52f3f89c4d57"></ins>
 </div>
  
 <div id="suggest"></div>
 <script language="javascript" type='text/javascript'>
 $(function(){
 $.get("/evilcry2012/svc/GetSuggestContent/51487298",function(data){
 $("#suggest").html(data);
 });
 });
 </script>
  
  
 <style>
 .blog-ass-articl dd {
 color: #369;
 width: 99%; /*修改行*/
 float: left;
 overflow: hidden;
 font: normal normal 12px/23px "SimSun";
 height: 23px;
 margin: 0;
 padding: 0 0 0 10px;
 margin-right: 30px;
 background: url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;
 }
 </style>
  
 <link rel="stylesheet" href="http://static.blog.csdn.net/css/replace.css"/>
 <div id="relate" data-mod="popu_218" class="tracking-ad">
 <div class="relate_t">
 <h3><span>参考知识库</span></h3>
 </div>
 <div class="relate_c">
 </div>
 </div>
  
  
 <dl class="blog-ass-articl" id="res-relatived" >
 <div class="embody embody_b" id="libkeyparent" style="display:none">
 <span class="embody_t">更多资料请参考：</span>
 <div class="embody_c" id="libkey"></div>
 </div>
  
  
 <dt><span>猜你在找</span></dt>
  
  
  
  
  
 <div id="adCollege" style="width: 42%;float: left;">
 <script src="http://csdnimg.cn/jobreco/job_reco.js" type="text/javascript"></script>
 <script type="text/javascript">
 csdn.position.showEdu({
 sourceType: "blog",
 searchType: "detail",
 searchKey: "51487298",
 username: "cyj_20170320",
 recordcount: "5",
 containerId: "adCollege" //容器DIV的id。
 });
  
 setEduLoc();
  
 function setEduLoc() {
 var edus = $("#adCollege div dd a");
 if (edus.length == 0) {
 setTimeout(function () {
 setEduLoc();
 }, 500);
 }
 else {
 var eduLoc = "?ref=blog&loc=0";
 $.each(edus, function (index,item) {
 var href = $(this).attr("href") + eduLoc;
 $(this).attr("href", href);
 });
 }
 }
  
 </script>
 </div>
  
  
 <div id="res" data-mod="popu_36" class="tracking-ad" style="width: 42%;float: left;margin-right: 30px;"></div>
  
 </dl>
  
  
 <script type="text/javascript">
 $(function () {
 setTimeout(function () {
 var searchtitletags = '[转载]ORA-00942 表或视图不存在 问题的解决' + ',' + $("#tags").html();
 searchService({
 index: 'blog',
 query: searchtitletags,
 from: 5,
 size: 5,
 appendTo: '#res',
 url: 'recommend',
 his: 2,
 client: "blog_cf_enhance",
 tmpl: '<dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="#{ url }" title="#{ title }" strategy="#{ strategy }">#{ title }</a></dd>'
 });
 }, 500);
 });
  
 </script>
  
  
 <div id="ad_cen">
 <ins data-revive-zoneid="71" data-revive-id="8c38e720de1c90a6f6ff52f3f89c4d57"></ins> </div>
  
 <!-- 广告位开始 -->
 <ins data-revive-zoneid="72" data-revive-id="8c38e720de1c90a6f6ff52f3f89c4d57"></ins>
 <!-- 广告位结束 -->
  
 <div class="comment_class">
 <div id="comment_title" class="panel_head">
 <span class="see_comment">查看评论</span><a name="comments"></a></div>
 <div id="comment_list">
 </div>
 <div id="comment_bar">
 </div>
 <div id="comment_form">
 </div>
 <div class="announce">
 * 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场<a name="reply"></a><a name="quote"></a></div>
 </div>
  
 <script type="text/javascript">
 var fileName = '51487298';
 var commentscount = 0;
 var islock = false
 </script>
 <script type="text/javascript" src="http://static.blog.csdn.net/scripts/comment.js"></script>
 <div id="ad_bot">
 </div>
 <div id="report_dialog">
 </div>
  
 <div id="d-top" style="bottom:60px;">
  
 <a id="quick-reply" class="btn btn-top q-reply" title="快速回复" style="display:none;">
 <img src="http://static.blog.csdn.net/images/blog-icon-reply.png" alt="快速回复">
 </a>
 <a id="d-top-a" class="btn btn-top backtop" style="display: none;" title="返回顶部" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_huidaodingbu'])" style="">
 <img src="http://static.blog.csdn.net/images/top.png" alt="TOP">
 </a>
 </div>
 <script type="text/javascript">
 $(function ()
 {
 $("#ad_frm_0").height("90px");
  
 setTimeout(function(){
 $("#ad_frm_2").height("200px");
 },1000);
 });
  
 </script>
 <style type="text/css">
 .tag_list
 {
 background: none repeat scroll 0 0 #FFFFFF;
 border: 1px solid #D7CBC1;
 color: #000000;
 font-size: 12px;
 line-height: 20px;
 list-style: none outside none;
 margin: 10px 2% 0 1%;
 padding: 1px;
 }
 .tag_list h5
 {
 background: none repeat scroll 0 0 #E0DBD3;
 color: #47381C;
 font-size: 12px;
 height: 24px;
 line-height: 24px;
 padding: 0 5px;
 margin: 0;
 }
 .tag_list h5 a
 {
 color: #47381C;
 }
 .classify
 {
 margin: 10px 0;
 padding: 4px 12px 8px;
 }
 .classify a
 {
 margin-right: 20px;
 white-space: nowrap;
 }
 </style>
  
  
 <div class="tag_list" style="display:none"></div>
 <script language="javascript" type='text/javascript'>
 $(function(){
 setTimeout(function(){
 $.get("/evilcry2012/svc/GetTagContent",function(data){
 $(".tag_list").html(data).show();
 });
 });
 },500);
 </script>
  
  
 <div id="pop_win" style="display:none ;position: absolute; z-index: 10000; border: 1px solid rgb(220, 220, 220); top: 222.5px; left: 630px; opacity: 1; background: none 0px 0px repeat scroll rgb(255, 255, 255);">
  
 </div>
 <div id="popup_mask"></div>
 <style>
 #popup_mask
 {
 position: absolute;
 width: 100%;
 height: 100%;
 background: #000;
 z-index: 9999;
 left: 0px;
 top: 0px;
 opacity: 0.3;
 filter: alpha(opacity=30);
 display: none;
 }
  
 </style>
  
  
  
  
 <script type="text/javascript">
 $(function(){
 setTimeout(function(){
 $(".comment_body:contains('回复')").each(function(index,item){
 var u=$(this).text().split('：')[0].toString().replace("回复","")
 var thisComment=$(this);
 if(u)
 {
 $.getJSON("https://passport.csdn.net/get/nick?callback=?", {users: u}, function(a) {
 if(a!=null&&a.data!=null&&a.data.length>0)
 {
 nick=a.data[0].n;
 if(u!=nick)
 {
 thisComment.text(thisComment.text().replace(u,nick));
 }
 }
 });
 }
 });
  
 },200);
  
 setTimeout(function(){
 $(".math").each(function(index,value){$(this).find("span").last().css("color","#fff"); })
 },5000);
  
 setTimeout(function(){
 $(".math").each(function(index,value){$(this).find("span").last().css("color","#fff"); })
 },10000);
  
 setTimeout(function(){
 $(".math").each(function(index,value){$(this).find("span").last().css("color","#fff"); })
 },15000);
  
 setTimeout(function(){
 $("a img[src='http://js.tongji.linezing.com/stats.gif']").parent().css({"position":"absolute","left":"50%"});
 },300);
 });
  
 function loginbox(){
 var $logpop=$("#pop_win");
 $logpop.html('<iframe src="https://passport.csdn.net/account/loginbox?service=http://static.blog.csdn.net/callback.htm" frameborder="0" height="600" width="400" scrolling="no"></iframe>');
  
 $('#popup_mask').css({
 opacity: 0.5,
 width: $( document ).width() + 'px',
 height: $( document ).height() + 'px'
 });
 $('#popup_mask').css("display","block");
  
 $logpop.css( {
 top: ($( window ).height() - $logpop.height())/ 2 + $( window
 ).scrollTop() + 'px',
 left:($( window ).width() - $logpop.width())/ 2
 } );
  
 setTimeout( function () {
 $logpop.show();
 $logpop.css( {
 opacity: 1
 } );
 }, 200 );
  
 $('#popup_mask').unbind("click");
 $('#popup_mask').bind("click", function(){
 $('#popup_mask').hide();
 var $clopop = $("#pop_win");
 $("#common_ask_div_sc").css("display","none");
 $clopop.css( {
 opacity: 0
 } );
 setTimeout( function () {
 $clopop.hide();
 }, 350 );
 return false;
 });
 }
  
 </script>
 <script language="javascript" type="text/javascript" src="http://ads.csdn.net/js/async_new.js"></script>
  
  
  
  
 <div class="clear">
 </div>
 </div>
  
 </div>
  
 <div id="side">
  
 <div class="side">
 <div id="panel_Profile" class="panel">
 <ul class="panel_head"><span>个人资料</span></ul>
 <ul class="panel_body profile">
 <div id="blog_userface">
 <a href="http://my.csdn.net/evilcry2012" target="_blank">
 <img src="http://avatar.csdn.net/3/A/C/1_evilcry2012.jpg" title="访问我的空间" style="max-width:90%"/>
 </a>
 <br />
 <span><a href="http://my.csdn.net/evilcry2012" class="user_name" target="_blank">evilcry2012</a></span>
 </div>
 <div class="interact">
  
 <a href="javascript:void(0);" class="attent" id="span_add_follow" title="[加关注]"></a>
  
 <a href="javascript:void(0);" class="letter" title="[发私信]" onclick="window.open('http://msg.csdn.net/letters/model?receiver=evilcry2012','_blank','height=350,width=700');_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_sixin'])"></a>
 </div>
 <div id="blog_medal">
 <div id="bms_box">
 </div>
 </div>
 <ul id="blog_rank">
 <li>访问：<span>525657次</span></li>
 <li>积分：<span>9101</span> </li>
 <li >等级： <span style="position:relative;display:inline-block;z-index:1" >
 <img src="http://c.csdnimg.cn/jifen/images/xunzhang/jianzhang/blog6.png" alt="" style="vertical-align: middle;" id="leveImg">
 <div id="smallTittle" style=" position: absolute; left: -24px; top: 25px; text-align: center; width: 101px; height: 32px; background-color: #fff; line-height: 32px; border: 2px #DDDDDD solid; box-shadow: 0px 2px 2px rgba (0,0,0,0.1); display: none; z-index: 999;">
 <div style="left: 42%; top: -8px; position: absolute; width: 0; height: 0; border-left: 10px solid transparent; border-right: 10px solid transparent; border-bottom: 8px solid #EAEAEA;"></div>
 积分：9101 </div>
 </span> </li>
 <li>排名：<span>第1675名</span></li>
 </ul>
 <ul id="blog_statistics">
 <li>原创：<span>35篇</span></li>
 <li>转载：<span>2263篇</span></li>
 <li>译文：<span>0篇</span></li>
 <li>评论：<span>19条</span></li>
 </ul>
 </ul>
 </div>
  
  
 <div class="panel" id="panel_Search">
 <ul class="panel_head"><span>文章搜索</span></ul>
 <ul class="panel_body">
 <form id="frmSearch" action="http://so.csdn.net/search" class="form_search" target="_blank">
 <span><input id="inputSearch" type="text" class="blogsearch" title="请输入关键字" /></span>
 <input id="btnSubmit" type="button" value="搜索" title="search in blog" />
 <input type="hidden" name="q" id="inputQ" />
 <input type="hidden" name="t" value="blog" />
 <a id="btnSearchBlog" target="_blank"></a>
 </form>
 </ul>
 </div>
  
 <script type="text/javascript">
 $(function () {
 $("#btnSubmit").click(function () {
 search();
 });
  
 $("#frmSearch").submit(function () {
 search();
 return false;
 });
  
 function search()
 {
 var url = "http://so.csdn.net/so/search/s.do?q=" + encodeURIComponent($("#inputSearch").val()) + "&u=" + username + "&t=blog";
 window.location.href = url;
 }
 });
 </script><div id="panel_Category" class="panel">
 <ul class="panel_head"><span>文章分类</span></ul>
 <ul class="panel_body">
 <li>
 <a href="/evilcry2012/article/category/1794579" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">JAVA</a><span>(573)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/3126221" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Oracle</a><span>(171)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/3129453" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">jQuery</a><span>(21)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/3147169" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">前端</a><span>(21)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/3278519" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">WEB</a><span>(5)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5420483" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">weblogic</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5582275" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">RESTful</a><span>(4)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5584133" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">JSF</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5618645" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">mySql</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5677565" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">SSH</a><span>(85)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5691765" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">HTML</a><span>(11)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5703725" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">AngularJS</a><span>(0)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5910981" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">ExtJs</a><span>(247)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5910983" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Mybatis</a><span>(12)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5912965" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Eclipse</a><span>(80)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5923473" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">JUnit</a><span>(0)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5929187" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Windows</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5932481" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Maven</a><span>(12)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/5964943" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java web</a><span>(81)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6058133" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">javascript</a><span>(139)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6090576" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">XML</a><span>(2)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6090577" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">web servicies</a><span>(5)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6097661" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">IE及浏览器兼容性问题</a><span>(6)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6098637" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">业务知识</a><span>(17)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6100052" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Sea.js</a><span>(4)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6118792" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">DWR</a><span>(5)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6127771" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">CSS</a><span>(6)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6145988" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">SVN</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6147081" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Ibatis</a><span>(17)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6173649" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Excel</a><span>(7)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6195011" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">代码优化</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6195014" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">学习网站</a><span>(2)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6208040" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java 集合</a><span>(2)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6247819" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Spring MVC</a><span>(15)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6252131" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">tomcat</a><span>(16)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6262519" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">JAVA IO</a><span>(11)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6278325" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Linux</a><span>(23)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6297326" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Struts</a><span>(14)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6320399" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Exception</a><span>(10)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6322986" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Spring</a><span>(34)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6331369" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">开源工具类</a><span>(14)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6346039" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java实现发短信</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6370500" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">JAVA 继承</a><span>(5)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6382119" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">JAVA集合类MAP与LIST</a><span>(22)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6383964" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">字符编码</a><span>(0)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6386649" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">编程技巧</a><span>(2)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6421536" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Web Service</a><span>(6)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6425603" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java实现定时器</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6452206" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">AJAX</a><span>(4)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6462406" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">JAVA 多线程</a><span>(9)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6482699" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java语法常规报错</a><span>(2)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6482752" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java语法常规问题</a><span>(10)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6483289" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">chrome调试技巧</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6487596" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">MyEclipse</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6498155" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">正则表达式</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6503382" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">tomcat源码分析</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6507331" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">Git</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6524889" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">JAVA泛型</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6525578" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">SQL优化</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6525585" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">SQL写法研究</a><span>(2)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6526046" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java API</a><span>(13)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6526587" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java 名词概念</a><span>(6)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6550590" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">开发感悟</a><span>(7)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6558803" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">开源Jar包</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6634148" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">运维工具</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6667675" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java提高篇</a><span>(10)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6667976" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">java基础</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6675237" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">日志log4j</a><span>(3)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/category/6686643" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_wenzhangfenlei']); ">axis</a><span>(1)</span>
 </li>
 </ul>
 </div><div id="panel_Archive" class="panel">
 <ul class="panel_head"><span>文章存档</span></ul>
 <ul class="panel_body">
 <div id="archive_list">
 <!--归档统计-->
 <li><a href="/evilcry2012/article/month/2017/03">2017年03月</a><span>(10)</span></li><li><a href="/evilcry2012/article/month/2017/01">2017年01月</a><span>(48)</span></li><li><a href="/evilcry2012/article/month/2016/12">2016年12月</a><span>(41)</span></li><li><a href="/evilcry2012/article/month/2016/11">2016年11月</a><span>(103)</span></li><li><a href="/evilcry2012/article/month/2016/10">2016年10月</a><span>(73)</span></li><li><a href="/evilcry2012/article/month/2016/09">2016年09月</a><span>(87)</span></li><li><a href="/evilcry2012/article/month/2016/08">2016年08月</a><span>(79)</span></li><li><a href="/evilcry2012/article/month/2016/07">2016年07月</a><span>(93)</span></li><li><a href="/evilcry2012/article/month/2016/06">2016年06月</a><span>(37)</span></li><li><a href="/evilcry2012/article/month/2016/05">2016年05月</a><span>(67)</span></li><li><a href="/evilcry2012/article/month/2016/04">2016年04月</a><span>(155)</span></li><li><a href="/evilcry2012/article/month/2016/03">2016年03月</a><span>(187)</span></li><li><a href="/evilcry2012/article/month/2016/02">2016年02月</a><span>(83)</span></li><li><a href="/evilcry2012/article/month/2016/01">2016年01月</a><span>(72)</span></li><li><a href="/evilcry2012/article/month/2015/12">2015年12月</a><span>(61)</span></li><li><a href="/evilcry2012/article/month/2015/11">2015年11月</a><span>(111)</span></li><li><a href="/evilcry2012/article/month/2015/10">2015年10月</a><span>(81)</span></li><li><a href="/evilcry2012/article/month/2015/09">2015年09月</a><span>(17)</span></li><li><a href="/evilcry2012/article/month/2015/08">2015年08月</a><span>(87)</span></li><li><a href="/evilcry2012/article/month/2015/07">2015年07月</a><span>(166)</span></li><li><a href="/evilcry2012/article/month/2015/06">2015年06月</a><span>(85)</span></li><li><a href="/evilcry2012/article/month/2015/05">2015年05月</a><span>(108)</span></li><li><a href="/evilcry2012/article/month/2015/04">2015年04月</a><span>(139)</span></li><li><a href="/evilcry2012/article/month/2015/03">2015年03月</a><span>(117)</span></li><li><a href="/evilcry2012/article/month/2015/02">2015年02月</a><span>(63)</span></li><li><a href="/evilcry2012/article/month/2015/01">2015年01月</a><span>(63)</span></li><li><a href="/evilcry2012/article/month/2014/12">2014年12月</a><span>(22)</span></li><li><a href="/evilcry2012/article/month/2014/11">2014年11月</a><span>(58)</span></li><li><a href="/evilcry2012/article/month/2014/10">2014年10月</a><span>(21)</span></li><li><a href="/evilcry2012/article/month/2013/12">2013年12月</a><span>(1)</span></li>
 </div>
 </ul>
 </div>
 <div id="hotarticls" class="panel">
 <ul class="panel_head">
 <span>
 阅读排行 </span>
 </ul>
  
 <ul class="panel_body itemlist">
 <li>
 <a href="/evilcry2012/article/details/44117775" title="java工程师面试题大全-100%公司笔试题你都能碰到几个">java工程师面试题大全-100%公司笔试题你都能碰到几个</a><span>(4974)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/44620753" title="java接口的修饰符可以为？">java接口的修饰符可以为？</a><span>(4869)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/51878826" title="Server Tomcat v7.0 Server at localhost failed to start.怎么处理">Server Tomcat v7.0 Server at localhost failed to start.怎么处理</a><span>(3940)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/41731697" title="java.lang.ClassNotFoundException: org.springframework.web.context.ContextLoaderL">java.lang.ClassNotFoundException: org.springframework.web.context.ContextLoaderL</a><span>(2934)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/49778363" title="如何处理java相关网络协议占内存的问题啊？为何时间越长，内存占用越大？">如何处理java相关网络协议占内存的问题啊？为何时间越长，内存占用越大？</a><span>(2871)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/51126175" title="JAVA中HashMap如何删除元素">JAVA中HashMap如何删除元素</a><span>(2787)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/51720999" title="严重: The web application [] appears to have started a thread named [Thread-">严重: The web application [] appears to have started a thread named [Thread-</a><span>(2592)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/52698492" title="java里怎么向一个空数组添加元素">java里怎么向一个空数组添加元素</a><span>(2592)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/51144098" title="判断一个list集合是否为空，用isEmpty 还是 null的问题？？？">判断一个list集合是否为空，用isEmpty 还是 null的问题？？？</a><span>(2520)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/50404012" title="Java中Set巧用，去掉重复数据">Java中Set巧用，去掉重复数据</a><span>(2416)</span>
 </li>
 </ul>
 </div>
 <div id="hotarticls2" class="panel">
 <ul class="panel_head"><span>评论排行</span></ul>
 <ul class="panel_body itemlist">
 <li>
 <a href="/evilcry2012/article/details/51720455" title="将Web项目War包部署到Tomcat服务器基本步骤">将Web项目War包部署到Tomcat服务器基本步骤</a><span>(5)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/47780037" title="mysql数据类型介绍(含text,longtext,mediumtext说明)">mysql数据类型介绍(含text,longtext,mediumtext说明)</a><span>(2)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/52535623" title="Eclipse启动Tomcat时45秒超时解决方法">Eclipse启动Tomcat时45秒超时解决方法</a><span>(2)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/45395359" title="java.io.InvalidClassException:local class incompatible: stream classdesc serialV">java.io.InvalidClassException:local class incompatible: stream classdesc serialV</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/45368963" title="错误：仅当显示请求注释处理时才接受类名称">错误：仅当显示请求注释处理时才接受类名称</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/43524025" title="严重: Servlet.service() for servlet [default] in context with path [/aaa] threw exception">严重: Servlet.service() for servlet [default] in context with path [/aaa] threw exception</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/46003837" title="Apache Maven 3.x">Apache Maven 3.x</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/45076799" title="关于ArrayList的初始容量以及扩容的效率问题">关于ArrayList的初始容量以及扩容的效率问题</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/44117491" title="精选30道Java笔试题解答">精选30道Java笔试题解答</a><span>(1)</span>
 </li>
 <li>
 <a href="/evilcry2012/article/details/47447459" title="jQuery 效果 - fadeIn() 方法">jQuery 效果 - fadeIn() 方法</a><span>(1)</span>
 </li>
 </ul>
 </div>
 <div id="homepageArticles" class="panel tracking-ad" data-mod="popu_4">
 <ul class="panel_head"><span>推荐文章</span></ul>
 <ul class="panel_body" id="ad_commend">
 <ul>
 <li><a href="http://blog.csdn.net/cyq1162/article/details/62041884" target="_blank">* 一个想法照进现实-《IT连》创业项目：三天的风投对接活动内幕分享</a></li>
 <li><a href="http://blog.csdn.net/baron_leizhang/article/details/59532530" target="_blank">* 神兵利器Dagger2</a></li>
 <li><a href="http://blog.csdn.net/wireless_com/article/details/61912260"
 target="_blank">* 从CAP 到编程语言的猜想</a></li>
 <li><a href="http://blog.csdn.net/shenjie12345678/article/details/62039363"target="_blank">* iWatch开发：WatchOS 消息推送教程</a></li>
 <li><a href="http://blog.csdn.net/jiangwei0910410003/article/details/53000565"
 target="_blank">* iOS狂暴之路---iOS中应用的数据存储方式解析</a></li>
  
  
 </ul></ul>
 </div>
  
  
 <div id="newcomments" class="panel">
 <ul class="panel_head"><span>最新评论</span></ul>
 <ul class="panel_body itemlist">
 <li>
  
 <a href="/evilcry2012/article/details/52698492#comments">java里怎么向一个空数组添加元素</a>
 <p style="margin:0px;"><a href="/u011626283" class="user_name">u011626283</a>:
 学习了。
 </p>
 </li>
 <li>
  
 <a href="/evilcry2012/article/details/51720455#comments">将Web项目War包部署到Tomcat服务器基本步骤</a>
 <p style="margin:0px;"><a href="/evilcry2012" class="user_name">evilcry2012</a>:
 @qq_23415971:没有,你可以网上搜下
 </p>
 </li>
 <li>
  
 <a href="/evilcry2012/article/details/51720455#comments">将Web项目War包部署到Tomcat服务器基本步骤</a>
 <p style="margin:0px;"><a href="/qq_23415971" class="user_name">qq_23415971</a>:
 连接字符串有没有示例代码啊
 </p>
 </li>
 <li>
  
 <a href="/evilcry2012/article/details/45368963#comments">错误：仅当显示请求注释处理时才接受类名称</a>
 <p style="margin:0px;"><a href="/zjy15203167987" class="user_name">zjy15203167987</a>:
 我依旧不太明白....
 </p>
 </li>
 <li>
  
 <a href="/evilcry2012/article/details/52535623#comments">Eclipse启动Tomcat时45秒超时解决方法</a>
 <p style="margin:0px;"><a href="/evilcry2012" class="user_name">evilcry2012</a>:
 @FrankChen_:你意思是项目没有部署在本机，而是部署在另一个IP的服务器上时要做这个设置？
 </p>
 </li>
 <li>
  
 <a href="/evilcry2012/article/details/52535623#comments">Eclipse启动Tomcat时45秒超时解决方法</a>
 <p style="margin:0px;"><a href="/FrankChen_" class="user_name">FrankChen_</a>:
 如果是在公司 且 公司开了代理,请在window&gt;preference&gt;general&gt;networ...
 </p>
 </li>
 <li>
  
 <a href="/evilcry2012/article/details/52535623#comments">将Web项目War包部署到Tomcat服务器基本步骤</a>
 <p style="margin:0px;"><a href="/evilcry2012" class="user_name">evilcry2012</a>:
 不需要 你war包放到tomcat下启动 所有的jar都有呀
 </p>
 </li>
 <li>
  
 <a href="/evilcry2012/article/details/52535623#comments">将Web项目War包部署到Tomcat服务器基本步骤</a>
 <p style="margin:0px;"><a href="/sinat_34380592" class="user_name">sinat_34380592</a>:
 项目打包成的war包里面包含jar包吗？部署到tomcat服务器时，其下的lib目录里面需要另外手动...
 </p>
 </li>
 <li>
  
 <a href="/evilcry2012/article/details/52535623#comments">将Web项目War包部署到Tomcat服务器基本步骤</a>
 <p style="margin:0px;"><a href="/sinat_34380592" class="user_name">sinat_34380592</a>:
 项目打包成的war包里面包含jar包吗？部署到tomcat服务器时，其下的lib目录里面需要另外手动...
 </p>
 </li>
 <li>
  
 <a href="/evilcry2012/article/details/45076799#comments">关于ArrayList的初始容量以及扩容的效率问题</a>
 <p style="margin:0px;"><a href="/thf913134326" class="user_name">thf913134326</a>:
 为什么要扩容原有的1.5倍加1呢
 </p>
 </li>
 </ul>
 </div>
 </div>
 <div class="clear">
 </div>
  
  
 <!-- 广告位开始 -->
 <ins data-revive-zoneid="190" data-revive-id="8c38e720de1c90a6f6ff52f3f89c4d57"></ins>
 <!-- 广告位结束 -->
  
 </div>
  
 <div class="clear">
 </div>
 </div>
  
  
  
 <script type="text/javascript" src="http://c.csdnimg.cn/rabbit/cnick/cnick.js"></script>
 <script type="text/javascript" src="http://static.blog.csdn.net/scripts/newblog.min.js"></script>
  
  
 <script type="text/javascript" src="http://medal.blog.csdn.net/showblogmedal.ashx?blogid=1080676"></script>
 <script type="text/javascript" src="http://static.blog.csdn.net/scripts/JavaScript1.js"></script>
  
 <script type="text/javascript">document.write("<img src=http://counter.csdn.net/pv.aspx?id=24 border=0 width=0 height=0>");</script>
 <script type="text/javascript" src="http://www.csdn.net/ui/scripts/Csdn/counter.js"></script>
 <script type="text/javascript" src="http://ad.csdn.net/scripts/ad-blog.js"></script>
 <script type="text/javascript">
 $(function () {
 function __get_code_toolbar(snippet_id) {
 return $("<span class='tracking-ad' data-mod='popu_167'><a href='https://code.csdn.net/snippets/"
 + snippet_id
 + "' target='_blank' title='在CODE上查看代码片' style='text-indent:0;'><img src='https://code.csdn.net/assets/CODE_ico.png' width=12 height=12 alt='在CODE上查看代码片' style='position:relative;top:1px;left:2px;'/></a></span>"
 + "<span class='tracking-ad' data-mod='popu_170'><a href='https://code.csdn.net/snippets/"
 + snippet_id
 + "/fork' target='_blank' title='派生到我的代码片' style='text-indent:0;'><img src='https://code.csdn.net/assets/ico_fork.svg' width=12 height=12 alt='派生到我的代码片' style='position:relative;top:2px;left:2px;'/></a></span>");
 }
  
 $("[code_snippet_id]").each(function () {
 __s_id = $(this).attr("code_snippet_id");
 if (__s_id != null && __s_id != "" && __s_id != 0 && parseInt(__s_id) > 70020) {
 __code_tool = __get_code_toolbar(__s_id);
 $(this).prev().find(".tools").append(__code_tool);
 }
 });
  
 $(".bar").show();
 });
 </script>
  
  
  
  
  
 </div>
 <!--new top-->
  
 <script id="csdn-toolbar-id" btnId="header_notice_num" wrapId="note1" count="5" subCount="5" type="text/javascript" src="http://c.csdnimg.cn/public/common/toolbar/js/toolbar.js"></script> <!--new top-->
  
 <link href="http://c.csdnimg.cn/comm_ask/css/ask_float_block.css" type="text/css" rel="stylesheet" />
 <script language='JavaScript' type='text/javascript' src='http://c.csdnimg.cn/comm_ask/js/libs/wmd.js'></script>
 <script language='JavaScript' type='text/javascript' src='http://c.csdnimg.cn/comm_ask/js/libs/showdown.js'></script>
 <script language='JavaScript' type='text/javascript' src='http://c.csdnimg.cn/comm_ask/js/libs/prettify.js'></script>
 <script language='JavaScript' type='text/javascript' src='http://c.csdnimg.cn/comm_ask/js/apps/ask_float_block.js'></script>
  
  
  
  
 <div id="a52b5334d" style="width: 1px; height: 1px; display: none;">
 <script id="adJs52b5334"></script>
 <script>document.getElementById("adJs52b5334").src = "http://ads.csdn.net/js/opt/52b5334.js?t=" + Math.random();</script>
 </div>
  
 <link rel="stylesheet" href="http://static.blog.csdn.net/css/blog_code.css" />
 <script type="text/javascript" src="http://static.blog.csdn.net/scripts/saveToCode.js"></script>
 <script type="text/javascript" src="//csdnimg.cn/rabbit/tracking-ad/main.js?75eacd8"></script>
  
 <link rel="stylesheet" href="http://static.blog.csdn.net/css/fa.css" />
  
 <div class="pop_CA_cover" style="display:none"></div>
 <div class="pop pop_CA" style="display:none">
 <div class="CA_header">
 收藏助手
 <span class="cancel_icon" id="fapancle" onclick="$('.pop_CA').hide();$('.pop_CA_cover').hide();"></span>
 </div>
 <iframe src="" id="fa" frameborder="0" width="100%" height="360" scrolling="no" />
 </div>
 </body>
 </html>
 
cyj_20170320
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
ORA-01654处理表空间不足问题.pdf
06-12
使用过程Oracle 表空间不足时，详细处理办法
ora-00942表或视图不存在,解决办法
weixin_42584758的博客
02-15 5799
ORA-00942 错误提示表明当前查询的表或视图不存在。解决此问题的方法如下： 确保表或视图存在：请检查您的查询是否正确引用了实际存在的表或视图名称。如果表或视图不存在，请确保已正确创建或者确认表或视图名是否拼写正确。 检查权限：请检查当前用户是否有访问该表或视图的权限。如果当前用户没有访问权限，则需要授权或者使用有权限的用户执行查询。 检查表空间：请检查表或视图是否位于正确的表空间中。如...
前端 SPA 单页应用数据统计解决方案 (ReactJS / VueJS)
weixin_33877092的博客
11-07 203
前端 SPA 单页应用数据统计解决方案 (ReactJS / VueJS) 一、百度统计的代码： UV PV 统计方式可能存在问题 在 SPA 的前端项目中 数据统计，往往就是一个比较麻烦的事情，React 和 Vue 也是一样。 在 发现问题之前，我们得来思考下 百度统计的 统计原理 是什么？ 1-1: 百度统计代码 var _hmt ...
ORA-00942: 表或视图不存在，Oracle数据库整合Mybatis框架报错，已解决
最新发布
weixin_52824955的博客
01-31 666
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在 ### The error may exist in com/glxy/springboot/mapper/UserMapper.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting
【Oracle数据库查询报错】ORA-00942: 表或视图不存在
gszz_的博客
11-13 5344
ORA-00942: 表或视图不存在
latex各个模块范例模板以及各种使用技巧
miracleoa的博客
12-16 7013
文章目录一、导包二、各块函数的作用（1）文章标题（2）目录（3）开始结束文档块（4）三线表格（5）公式（6）因为所以（7）代码三、参考博客四、范例 一、导包 \documentclass{article} \usepackage{geometry} \geometry{a4paper} %\usepackage[UTF8, heading = false, scheme = plain]{cte...
Android EventLog
一个小菜鸟的成长之路的专栏
11-06 7817
一、概述 EventLog是Android中重要的log，能够用来分析系统的各种状况，比如activity的生命周期，电池状态等 在终端输入 logcat -b events 能够打印出evetnlog。同时在MTKLog的mobilelog文件夹下面也能看到evetnlog。 tags格式的定义位于文件system/etc/event-log-tags 同时，阅读详细信息可以查看源码中的...
9i exp遇见EXP-00008 ORA-00942 EXP-00024错误的解决
11-19
ORACLE9i exp遇见EXP-00008 ORA-00942 EXP-00024错误的解决方法，详细描述了问题处理的过程和步骤，共享在此，希望能有所帮助
Orcle的package中访问其它Schema的表报错ORA-00942解决方法
09-10
package要访问其它Schema的表，但编译报错ORA-00942，经过搜索了一下找到了解决方法下面与大家分享下
ora-01720 授权选项对于'xxxx'不存在的解决方法
01-04
ora-01720 授权选项对于'xxxx'不存在的解决方法，希望有帮助。
ora-00119和ora-00132问题的解决方法
12-15
oracle11g安装后，本地无法...发现ora-00119【ora-00119 invalid specification for system parameter】 ora-00132【syntax error or unresolved network name ‘LISTENER_ORCL’】： 现在看来，完全可以理解就是001
oracle错误00942,oracle-ORA-00942错误
weixin_30449853的博客
04-14 890
表或视图不存在原因：1.表或视图真的不存在 2.用户没有访问该表的权限。ORA-01078: 处理系统参数失败ORA-01438: value larger than specified precision allows for this columnORA-01441: cannot decrease column length because some value is too bigORA-...
00942 oracle_Oracle物化视图创建报ORA-00942错误解决
weixin_42412524的博客
03-05 865
在Oracle 10g的数据库中，将一个物化视图做了一个简单的条件子句修改，删除后重建，但是，就建不成功，报ORA-00942表或视图不存在错误。这个问题很奇怪，我首先想这会是一个bug吗？找了oracle的metalink，还真有类似bug记载，但给出的解决方法不合适。于是去自己分析解决，然后发现一个坑接着一个坑啊。好吧，我先介绍物化视图的创建语句，如下所示：CREATE MATERIALIZE...
oracle ora-16003,oracle exp ORA-31600和ORA-00942问题的解决
weixin_39809168的博客
04-10 239
oracle expORA-31600和ORA-00942问题的解决在不同版本的Oracle之间Exp导出时，出现ORA-00942错误．连接到: Oracle9i Enterprise Edition Release9.2.0.7.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Re...
oracle跨表空间报错ORA00942,Oracle_ORA一些错误整理
weixin_42349272的博客
04-03 704
1、ORA-12560: TNS: 协议适配器错误场景：在cmd窗口输入：sqlplus "/as sysdba"想打开数据库时报的错；原因：没有启动Oracle服务器；解决：WIN+R，跳出运行窗口，输入"services.msc"，打开服务窗口；找到OracleServiceORACLE服务，查看是否为启动，右键启动即可。2、ORA-12541:TNS:no listener场景：用pl/sq...
ORACLE drop user时遇到的ORA-00604和ORA-00942错误排查
还不算晕的专栏
06-19 1510
1.问题现象 在SYS用户下删除一个普通用户时抛出ORA-00604和ORA-00942错误。具体的报错信息即问题现象如下所示。 AAAAA> drop user nbms cascade; drop user nbms cascade * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-0...
升级Oracle 19c经验: TTS时ORA-39083和ORA-00942案例
huoyan98的博客
06-23 1083
转载自https://www.anbob.com/archives/5857.html 上周在使用TTS传输表空间从11.2.0.4到19C， 在最后impdp metadata的环节提示ora-942 结果提示有大量索引没有创建成功，但是查看报错的表实际是存在的， 后来发现这是一个收权问题导致的。后分析这种场景是发生在如一开始给了一个用户如create ANY table/index的系统权限或者dba 角色或是on object上的权限，后来创建了跨SCHEMA的index（indexes and t
ORA-00942问题处理
cuishan5183的博客
05-18 674
开发的同事反馈，创建了表，且在PL/SQL Developer中可以看到该表，但是执行查询操作却报“ORA-00942: table or view does not exist”错误。结果发现原因是创建表的脚本中表名使用双引号...
ORA-00942: table or view does not exist 错误，生产环境的多原因分析以及查找问题思路
热门推荐
weixin_42121675的博客
09-28 2万+
ORA-00942: table or view does not exist 错误 table or view does not exist问题，已经困扰两天之久了，一直没有思路，虽然代码多次调整，但是还是会出现这样的问题，现有解决思路提供一下，方便大家参考学习。 根据网上搜集的各种问题和答案，我来总结一下。 1、在开发初期的时候，由于powerdesigner进行数据库的设计工作，在转换...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值