<!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 表或视图不存在 问题的解决 (2012-07-09 14:46:18)转载▼标签: 转载分类: Oracle原文地址:表或视图不存在 问题的解决 style=text-decoration:none; color:rgb(55,133,80)>ORA-00942 表或视图不存在 问" /> | |
<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> | |
  | |
<a href="http://blog.csdn.net/turingbooks/article/details/58072986"> | |
<font color=blue>程序员2月书讯 | |
</font></a> | |
  | |
<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="{"err":0,"msg":"ok","data":[]}"></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 + " "; | |
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 表或视图不存在 问题的解决</h2> | |
<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> | |
<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&q=%D7%AA%D4%D8&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> <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 <wbr>表或视图不存在 <wbr>问题的解决" style="text-decoration:none; color:rgb(55,133,80)">ORA-00942 <wbr>表或视图不存在 <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> <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> <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> <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> <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"> | |
<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> <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> <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> <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> <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> <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"> <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"> <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"> <wbr></span></span> <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> <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"> <wbr> <wbr> <wbr></span></span> <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> <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"> <wbr> <wbr> <wbr></span></span> <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> <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"> <wbr> <wbr></span></span> <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> <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"> <wbr> <wbr> <wbr> <wbr></span></span> <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> <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"> <wbr> <wbr> <wbr> <wbr></span></span> <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> <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"> <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"> <wbr></span></span> <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> <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> <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"> <wbr> <wbr> <wbr></span></span> <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> <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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span> 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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span> 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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span> 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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span> 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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span> 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"> <wbr> <wbr> <wbr> <wbr> <wbr></span> <span style="word-wrap:normal; word-break:normal"> <wbr> <wbr> <wbr> <wbr> <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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span></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">'alter | |
system kill session '''</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">|| X.SID ||</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> <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> <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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span> C.SPID</span> <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> <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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span> 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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span></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">'ps | |
-ef | grep '</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">|| C.SPID</span> <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> <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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span></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">'kill | |
-9 '</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">|| C.SPID</span> <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> <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"> <wbr> <wbr> <wbr> <wbr> <wbr></span></span> <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> <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"> <wbr> <wbr> <wbr> <wbr></span></span> <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> <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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span></span> <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> <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"> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr></span></span> <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> <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"> <wbr> <wbr> <wbr> <wbr></span></span> <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> <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> <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> <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"> <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下面报 <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"> | |
<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"> | |
<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 <wbr> SYS.DBA_OBJECTS TO zhuocaidev;<br> | |
grant select on SYS.V_$SESSION <wbr> 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&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);" > </a> </div> | |
<div class="tracking-ad" data-mod="popu_223"> <a href="javascript:void(0);" > </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>preference>general>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> | |
[转载]ORA-00942 表或视图不存在 问题的解决
最新推荐文章于 2024-04-25 17:18:00 发布