oracle中无法查询中文条件

初次装好PL/sql,查询
1， select * from basecar
--查询出来的结果中文全部为？
2， select*frombasecarwheretruck_number='京AS888'
--肯定是有数据的，但查不到，只要有中文就查不到
百度的结果是数据库服务器端和客户端字符集不一致导致的。
 
   @H_<a href="/tag/404/" target="_blank" class="keywords">404</a>_43@ 
  </div> 
  <div class="CodeMirror-scroll" style="margin:0px; padding:10px 0px 16px; outline:none; position:relative; overflow:hidden!important"> 
   <div class="CodeMirror-sizer" style="margin:0px 0px 0px 30px; position:relative; border-right:30px solid transparent; min-height:407px; padding-right:0px; padding-bottom:0px"> 
    <div style="margin:0px; position:relative; top:0px"> 
     <div class="CodeMirror-lines" style="margin:0px; padding:4px 0px; min-height:1px"> 
      <div style="margin:0px; position:relative; outline:none"> 
       <div class="CodeMirror-measure" style="margin:0px; position:absolute; width:618px; height:0px; overflow:hidden; visibility:hidden"> 
       </div> 
       <div class="CodeMirror-measure" style="margin:0px; position:absolute; width:618px; height:0px; overflow:hidden; visibility:hidden"> 
       </div> 
       <div style="margin:0px; position:relative; z-index:1"></div> 
       <div class="CodeMirror-code" style="margin:0px; outline:none"> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            1 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px"><span class="cm-variable">Oracle</span>字符集是一个字节数据的解释的符号集合,有大小之分,有相互的包容关系。<span class="cm-variable">ORACLE</span> <a href="/tag/zhichi/" target="_blank" class="keywords">支持</a>国家语言的体系结构允许你使用本地化语言来存储，处理，检索数据。它使<a href="/tag/shujuku/" target="_blank" class="keywords">数据库</a>工具，<a href="/tag/cuowu/" target="_blank" class="keywords">错误</a>消息，排序次序，日期，时间，货币，数字，和日历<a href="/tag/zidong/" target="_blank" class="keywords">自动</a>适应本地化语言和平台。 </span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            2 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px">影响<span class="cm-variable">oracle</span><a href="/tag/shujuku/" target="_blank" class="keywords">数据库</a>字符集最重要的参数是<span class="cm-variable">NLS_LANG</span>参数。 </span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            3 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px"></span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            4 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px">它的格式如下: 　　<span class="cm-variable">NLS_LANG</span> <span class="cm-meta" style="color:rgb(85,85,85)">=</span> <span class="cm-variable">language_territory</span>.<span class="cm-variable">charset</span> </span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            5 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px"></span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            6 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px">它有三个组成部分<span class="cm-bracket" style="color:rgb(153,119)">(</span>语言、地域和字符集<span class="cm-bracket" style="color:rgb(153,119)">)</span>，每个成分控制了<span class="cm-variable">NLS</span>子集的特性。 </span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            7 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px"></span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            8 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px">其中: </span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            9 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px"></span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            10 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px"><span class="cm-variable">Language</span> 指定服务器消息的语言，<span class="cm-variable">territory</span> 指定服务器的日期和数字格式，<span class="cm-variable">charset</span> 指定字符集。如:<span class="cm-variable">AMERICAN</span> <span class="cm-variable">_</span> <span class="cm-variable">AMERICA</span>. <span class="cm-variable">ZHS16GBK</span> </span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            11 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px"></span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            12 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px">从<span class="cm-variable">NLS_LANG</span>的组成我们可以看出，真正影响<a href="/tag/shujuku/" target="_blank" class="keywords">数据库</a>字符集的其实是第三部分。 </span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            13 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px"></span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            14 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px">所以两个<a href="/tag/shujuku/" target="_blank" class="keywords">数据库</a>之间的字符集只要第三部分一样就可以相互导入导出数据，前面影响的只是<a href="/tag/tishi/" target="_blank" class="keywords">提示</a>信息是<a href="/tag/zhongwen/" target="_blank" class="keywords">中文</a>还是英文。 </span></pre> 
        </div> 
        <div style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-wrapper" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            15 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px"></span></pre> 
        </div> 
        <div class="CodeMirror-activeline" style="margin:0px; position:relative"> 
         <div class="CodeMirror-gutter-background CodeMirror-activeline-gutter" style="margin:0px; position:absolute; top:0px; bottom:0px; z-index:4; left:-30px; width:30px"> 
         </div> 
         <div class="CodeMirror-gutter-wrapper CodeMirror-activeline-gutter" style="margin:0px; position:absolute; z-index:4; background:none!important; border:none!important; left:-30px"> 
          <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="margin:0px; padding:0px 3px 0px 5px; min-width:20px; text-align:center; color:rgb(153,153); white-space:nowrap; position:absolute; z-index:4; left:0px; width:21px">
            16 
          </div> 
         </div> 
         <pre class="CodeMirror-line" style=""><span style="padding-right:0.1px">如果检查的结果发现<span class="cm-variable">server</span>端与<span class="cm-variable">client</span>端字符集不一致，请统一<a href="/tag/xiugai/" target="_blank" class="keywords">修改</a>为同<span class="cm-variable">server</span>端相同的字符集。 </span></pre> 
        </div> 
       </div> 
      </div> 
     </div> 
    </div> 
   </div> 
   <div style="margin:0px; position:absolute; height:13px; width:1px; border-bottom:0px solid transparent; top:407px"> 
   </div> 
   <div class="CodeMirror-gutters" style="margin:0px; border-right:1px solid rgb(221,221,221); background-color:rgb(247,247,247); white-space:nowrap; position:absolute; left:0px; top:-5px; min-height:100%; z-index:3; height:437px"> 
    <div class="CodeMirror-gutter CodeMirror-linenumbers" style="margin:0px 0px -30px; white-space:normal; height:inherit; display:inline-block; vertical-align:top; width:29px"> 
    </div> 
   </div> 
  </div> 
 </div> 
</div> 
<div style="margin:0px">
  <a href="/tag/chaxun/" target="_blank" class="keywords">查询</a>服务器端的字符集 
</div> 
<div style="margin:0px"> 
 <div style="margin:0px"> 
  <span style="font-size:0.833rem; color:rgb(0,128)"></span>userenv<span style="color:rgb(0,128)">(<span style="color:rgb(0,255)">'language'</span>)</span>from<span style="color:rgb(0,128)"></span>dual<span style="color:rgb(0,128)">;</span></span> 
 </div> 
 <span style="font-size:0.833rem; color:rgb(0,128); font-size:0.833rem">select</span><span style="font-size:0.833rem"></span>*<span style="font-size:0.833rem; color:rgb(0,128)">from</span></span>v$nls_parameters<span style="color:rgb(0,128)"></span>parameter<span style="color:rgb(0,255)">'NLS_CHARACTERSET'</span>;</span></span> 
 <br> 
</div> 
<div style="margin:0px"> 
 <span style="font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:0.875rem"></span> 
 <div style="margin:0px">
   最重要的就是就是这个 
  <span style="font-family:Helvetica,"Hiragino Sans GB",微软雅黑,"Microsoft YaHei UI",SimSun,SimHei,arial,sans-serif; font-size:1rem">ZHS16GBK</span> 
 </div> 
 <div style="margin:0px"> 
  <span style="font-family:Helvetica,sans-serif; font-size:1rem"><br> </span> 
 </div> 
 <div style="margin:0px"> 
  <span style="font-family:Helvetica,sans-serif; font-size:1rem">客户端的字符集，我在<a href="/tag/zhuce/" target="_blank" class="keywords">注册</a>表（HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraClient11g_home1）中也没找到NLS_LANG,就当它与服务器端不一样吧。</span> 
 </div> 
 <div style="margin:0px"> 
  <span style="font-family:Helvetica,sans-serif; font-size:1rem"></span> 
  <div style="margin:0px">
    问题<a href="/tag/jiejuefangfa/" target="_blank" class="keywords">解决方法</a>： 
  </div> 
  <div style="margin:0px">
    1，设置环境变量， 
   <span style="color:rgb(51,51,51)">NLS_LANG=AMERICAN_AMERICA.ZHS16GBK</span> 
  </div> 
 </div> 
 <div style="margin:0px">
   2，重启PL/<a href="/tag/sql/" target="_blank" class="keywords">sql</a>，上面两个@R_<a href="/tag/301/" target="_blank" class="keywords">301</a>_194@就正常了。 
 </div> 
 <div style="margin:0px"> 
  <br> 
 </div> 
 <div style="margin:0px">
   但是还有其他问题... 
 </div> 
 <div style="margin:0px">
   项目需要， 
  <strong>在windows服务中<a href="/tag/diaoyong/" target="_blank" class="keywords">调用</a>@R_<a href="/tag/301/" target="_blank" class="keywords">301</a>_194@，<a href="/tag/chaxun/" target="_blank" class="keywords">查询</a>条件有<a href="/tag/zhongwen/" target="_blank" class="keywords">中文</a>，查不到数据，直接执行exe应用程序却可以查到数据，<span style="font-weight:normal; font-size:1rem; font-family:Helvetica,sans-serif; color:rgb(51,51)">想不明白为什么...</span></strong> 
 </div> 
 <div style="margin:0px"> 
  <br> 
 </div> 
 <div style="margin:0px"> 
  <strong><span style="font-weight:normal; font-size:1rem; font-family:Helvetica,51)">不明白也要继续，在<a href="/tag/zhuce/" target="_blank" class="keywords">注册</a>表中创建字符串值</span><span style="color:rgb(51,51); font-family:Helvetica,sans-serif; font-size:1rem"></span><span style="color:rgb(51,sans-serif; font-size:1rem"><span style="font-weight:normal; font-size:1rem">N</span></span><span style="color:rgb(51,sans-serif; font-size:1rem; font-weight:normal">LS_LANG=AMERICAN_AMERICA.ZHS16GBK</span></strong> 
 </div> 
</div> 
<div style="margin:0px"> 
 <span style="font-family:Helvetica,sans-serif"><span style="font-size:0.875rem; line-height:22.4px"></span></span> 
 <div style="margin:0px">
   然后服务@R_<a href="/tag/301/" target="_blank" class="keywords">301</a>_194@就正常了。 
 </div> 
 <div style="margin:0px"> 
  <br> 
 </div> 
 <div style="margin:0px">
   所以，简单、一步到位的做法就是在<a href="/tag/zhuce/" target="_blank" class="keywords">注册</a>表中<a href="/tag/xiugai/" target="_blank" class="keywords">修改</a>。 
 </div> 
 <div style="margin:0px"> 
  <br> 
 </div> 
 <div style="margin:0px">
   参考： 
 </div> 
 <div style="margin:0px"> 
  <a target="_blank" href="http://www.jb51.cc/article/p-blufludc-bcb.html">http://www.jb51.cc/article/p-blufludc-bcb.html</a> 
 </div>  
</div></div>
      <div class="topcard-tags"></div>
      
                 <ul class="list-group">
        <li class="list-group-item"><a href="/oracle/207750.html" title="oracle11g 修改字符集 修改为ZHS16GBK">上一篇：oracle11g 修改字符集 修改为ZHS16</a><a href="/oracle/207748.html" title="oracle11g数据库中的json工具" class="text-muted pull-right">下一篇：oracle11g数据库中的json工具</a>
    
    </li>
    </ul>
              </div>
            </div>
          </div>
          <!-- row end -->
          
          <div class="row row-sm">
            <div class="col-sm-12 col-md-12 col-lg-12">
              <div class="card">
<ins class="adsbygoogle"
     style="display:block"
     data-ad-format="autorelaxed"
     data-ad-client="ca-pub-4605373693034661"
     data-ad-slot="9144498553"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script></div>
            </div>
          </div>

          <div class="row row-sm">
            <div class="col-sm-12 col-md-12 col-lg-12">
              <div class="card">
                  
    <div class="title"><h1>猜你在找的Oracle相关文章</h1></div>
<div class="list_con">
                                    <a href="/oracle/997581.html" title="[Oracle]记一次由sequence引发的enq sv-contention等待事件"><img class="lazy" src="/images/np.jpg" data-original="/res/2021/02-21/08/83eea2de8590bb93072edf187a215b40.png" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">[Oracle]记一次由sequence引发的enq sv-contention等待事件</div>
                                <div class="summary">数据库版本：11.2.0.4 RAC(1)问题现象从EM里面可以看到，在23号早上8：45~8：55时，数据库...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div class="list_con">
                                    <a href="/oracle/997580.html" title="oracle统计信息的锁定与解锁"><img class="lazy" src="/images/np.jpg" data-original="/res/2021/02-21/08/ef5db76731daed49299924f0ae8cae0f.png" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">oracle统计信息的锁定与解锁</div>
                                <div class="summary">（一）问题背景最近在对一个大约200万行数据的表查看执行计划时，发现存在异常，理论上应该...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div class="list_con">
                                    <a href="/oracle/997579.html" title="【转】RMAN删除过期备份或非过期备份"><div class="title">【转】RMAN删除过期备份或非过期备份</div>
                                <div class="summary">（一）删除备份--DELETE命令用于删除RMAN备份记录及相应的物理文件。当使用RMAN执行备份操...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div class="list_con">
                                    <a href="/oracle/997578.html" title="数据恢复顾问（DRA）"><img class="lazy" src="/images/np.jpg" data-original="/res/2021/02-21/08/f789e1eee803ce0283ebcee1f48e7cc9.png" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">数据恢复顾问（DRA）</div>
                                <div class="summary">（1）DRA介绍 数据恢复顾问（Data Recovery Advise）是一个诊断和修复数据库的工具，DRA能...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div class="list_con">
                                    <a href="/oracle/997577.html" title="RMAN备份与恢复（一）--认识RMAN"><div class="title">RMAN备份与恢复（一）--认识RMAN</div>
                                <div class="summary">RMAN（Recovery Manager）是Oracle恢复管理器的简称，是集数据库备份（backup）、修复（re...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div style="border-bottom: 1px solid #f4f4f4;margin-top:20px;">
<ins class="adsbygoogle"
     style="display:block"
     data-ad-format="fluid"
     data-ad-layout-key="-fr-2o+fp-dx-wx"
     data-ad-client="ca-pub-4605373693034661"
     data-ad-slot="4561116489"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div><div class="list_con">
                                    <a href="/oracle/997575.html" title="RMAN备份与恢复（二）--RMAN常用操作学习"><div class="title">RMAN备份与恢复（二）--RMAN常用操作学习</div>
                                <div class="summary">（1）连接目标数据库 在RMAN中可以建立与目标数据库或恢复目录数据库的连接。与目标数据库...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div class="list_con">
                                    <a href="/oracle/997574.html" title="ORA-00245问题总结"><div class="title">ORA-00245问题总结</div>
                                <div class="summary">（1）问题描述 在进行数据库归档备份时（备份归档日志文件和控制文件），有时成功，有时失...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div class="list_con">
                                    <a href="/oracle/997573.html" title="使用RMAN对数据文件进行恢复"><div class="title">使用RMAN对数据文件进行恢复</div>
                                <div class="summary">（1）备份数据库 在使用RMAN进行数据库恢复之前，先用RMAN进行全库备份 （2）删除数据文件...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div class="list_con">
                                    <a href="/oracle/997572.html" title="Oracle使用fy_recover_data恢复truncate删除的数据"><div class="title">Oracle使用fy_recover_data恢复truncate删除的数据</div>
                                <div class="summary">(一)truncate操作概述在生产中，truncate是使用较多的命令，在使用不当的情况下，往往会造...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div class="list_con">
                                    <a href="/oracle/997571.html" title="备份与恢复（四）--RMAN使用恢复目录catalog来保存档案资料库"><div class="title">备份与恢复（四）--RMAN使用恢复目录catalog来保存档案资料库</div>
                                <div class="summary">（一）恢复目录概述RMAN档案资料库用于存储数据库备份、修复以及恢复所需的信息。这些信息...</div>
                                <time class="summary">作者：前端之家 时间：2021-02-21</time>
                                </a>
                            </div>
<div style="border-bottom: 1px solid #f4f4f4;margin-top:20px;">
<ins class="adsbygoogle"
     style="display:block"
     data-ad-format="fluid"
     data-ad-layout-key="-fr-2o+fp-dx-wx"
     data-ad-client="ca-pub-4605373693034661"
     data-ad-slot="4561116489"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div></div>
            </div>
          </div>
        </div>
        <!-- left end-->
        
        <!-- right -->
        <div class="col-sm-12 col-md-12 col-lg-3">
          <!-- row -->
          <div class="row row-sm">
            <div class="col-sm-12 col-md-12 col-lg-12">
              <div class="card">
                <label class="main-content-label ">编程分类</label>
                <div class="cate mt-20"><a href="/mysql/" title="MySQL">MySQL</a><a href="/mssql/" title="MsSQL">MsSQL</a><a href="/oracle/" title="Oracle">Oracle</a><a href="/sqlite/" title="Sqlite">Sqlite</a><a href="/postgresql/" title="Postgre SQL">Postgre SQL</a><a href="/mariadb/" title="Mariadb">Mariadb</a><a href="/mongodb/" title="MongoDB">MongoDB</a><a href="/nosql/" title="NoSQL">NoSQL</a><a href="/hbase/" title="HBase">HBase</a><a href="/jdbc/" title="JDBC">JDBC</a><div class="clearfix"></div>
                </div>
              </div>
            </div>
          </div>
          <!-- row end -->
         <!-- row -->
          <div class="row row-sm">
            <div class="col-sm-12 col-md-12 col-lg-12">
              <div class="card"> 
<!-- f2er-rightads -->
<ins class="adsbygoogle"
     style="display:block"
     data-ad-client="ca-pub-4605373693034661"
     data-ad-slot="7756441254"
     data-ad-format="auto"
     data-full-width-responsive="true"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script>
              </div>
            </div>
          </div>
          <!-- row end -->
          
          <!-- row -->
          <div class="row row-sm">
            <div class="col-sm-12 col-md-12 col-lg-12">
              <div class="card">
                <label class="main-content-label ">最新文章</label>
                <ul class="n-list"><li><a href="/oracle/997581.html" title="[Oracle]记一次由sequence引发的enq sv-contention等待事件" target="_blank">• [Oracle]记一次由sequence</a></li>
<li><a href="/oracle/997580.html" title="oracle统计信息的锁定与解锁" target="_blank">• oracle统计信息的锁定与解</a></li>
<li><a href="/oracle/997579.html" title="【转】RMAN删除过期备份或非过期备份" target="_blank">• 【转】RMAN删除过期备份或</a></li>
<li><a href="/oracle/997578.html" title="数据恢复顾问（DRA）" target="_blank">• 数据恢复顾问（DRA）</a></li>
<li><a href="/oracle/997577.html" title="RMAN备份与恢复（一）--认识RMAN" target="_blank">• RMAN备份与恢复（一）--认</a></li>
<li><a href="/oracle/997576.html" title="RMAN备份与恢复（三）--RMAN备份相关概念" target="_blank">• RMAN备份与恢复（三）--RM</a></li>
<li><a href="/oracle/997575.html" title="RMAN备份与恢复（二）--RMAN常用操作学习" target="_blank">• RMAN备份与恢复（二）--RM</a></li>
<li><a href="/oracle/997574.html" title="ORA-00245问题总结" target="_blank">• ORA-00245问题总结</a></li>
<li><a href="/oracle/997573.html" title="使用RMAN对数据文件进行恢复" target="_blank">• 使用RMAN对数据文件进行恢</a></li>
<li><a href="/oracle/997572.html" title="Oracle使用fy_recover_data恢复truncate删除的数据" target="_blank">• Oracle使用fy_recover_dat</a></li>
</ul>
              </div>
            </div>
          </div>
          <!-- row end -->


          <!-- row -->
          <div class="row row-sm">
            <div class="col-sm-12 col-md-12 col-lg-12">
              <div class="card">
                <label class="main-content-label ">热门标签
                  <span class="pull-right tx-12">
                    <a href="/all" target="_blank">更多 ►</a></span>
                </label>
                <div class="topcard-tags"><a href="/tag/undorizhi/" title="undo日志" target="_blank">undo日志</a><a href="/tag/persistentconnection/" title="persistent-connection" target="_blank">persistent-c</a><a href="/tag/mysqlerror1005/" title="mysql-error-1005" target="_blank">mysql-error-</a><a href="/tag/postalcode/" title="postal-code" target="_blank">postal-code</a><a href="/tag/sqlmatchall/" title="sql-match-all" target="_blank">sql-match-al</a><a href="/tag/mysql56/" title="mysql-5.6" target="_blank">mysql-5.6</a><a href="/tag/mysql80/" title="mysql-8.0" target="_blank">mysql-8.0</a><a href="/tag/databasetrigger/" title="database-trigger" target="_blank">database-tri</a><a href="/tag/anzhuanglujing/" title="安装路径" target="_blank">安装路径</a><a href="/tag/xitongcuowu/" title="系统错误" target="_blank">系统错误</a><a href="/tag/datadir/" title="data_dir" target="_blank">data_dir</a><a href="/tag/diushiwenjian/" title="丢失文件" target="_blank">丢失文件</a><a href="/tag/zhucongtongbu/" title="主从同步" target="_blank">主从同步</a><a href="/tag/sqlmode/" title="sql_mode" target="_blank">sql_mode</a><a href="/tag/shujukumulu/" title="数据库目录" target="_blank">数据库目录</a><a href="/tag/nimingyonghu/" title="匿名用户" target="_blank">匿名用户</a><a href="/tag/charactersetserver/" title="character_set_server" target="_blank">character_se</a><a href="/tag/IDguiling/" title="ID归零" target="_blank">ID归零</a><a href="/tag/shujukuweizhi/" title="数据库位置" target="_blank">数据库位置</a><a href="/tag/chaxunbiao/" title="查询表" target="_blank">查询表</a><a href="/tag/zhongfuziduan/" title="重复字段" target="_blank">重复字段</a><a href="/tag/chaxunziduan/" title="查询字段" target="_blank">查询字段</a><a href="/tag/jieduanrizhi/" title="截断日志" target="_blank">截断日志</a><a href="/tag/SUSPECT/" title="SUSPECT" target="_blank">SUSPECT</a><a href="/tag/7391/" title="7391" target="_blank">7391</a><a href="/tag/RemoteServer/" title="Remote Server" target="_blank">Remote Serve</a><a href="/tag/LinkedServer/" title="Linked Server" target="_blank">Linked Serve</a><a href="/tag/xuanxuewenti/" title="玄学问题" target="_blank">玄学问题</a><a href="/tag/denglubushang/" title="登录不上" target="_blank">登录不上</a><a href="/tag/kaiqiyuanchengfangwen/" title="开启远程访问" target="_blank">开启远程访问</a></div>
              </div>
            </div>
          </div>
          <!-- row end -->
          
          
         <!-- row -->
          <div class="row row-sm">
            <div class="col-sm-12 col-md-12 col-lg-12">
              <div class="card"> 
<!-- f2er-rightads -->
<ins class="adsbygoogle"
     style="display:block"
     data-ad-client="ca-pub-4605373693034661"
     data-ad-slot="7756441254"
     data-ad-format="auto"
     data-full-width-responsive="true"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script>
              </div>
            </div>
          </div>
          <!-- row end -->
          
          </div>
        <!-- right end -->
        </div>
    </div>

     <footer id="footer">
    <div class="container">
        <div class="row hidden-xs">
             <dl class="col-sm-6 site-link">
                <dt>最近更新</dt><dd><a href="/win11/1005328.html" title="小米手机重装系统价格多少?专业维修服务详解" target="_blank">· 小米手机重装系统价格多少?专业维修服务详解</a><span class="text-muted pull-right">02-05</span></dd>
<dd><a href="/win11/1005327.html" title="手把手教你重装电脑系统,让你的电脑焕然一新!" target="_blank">· 手把手教你重装电脑系统,让你的电脑焕然一新!</a><span class="text-muted pull-right">02-05</span></dd>
<dd><a href="/win11/1005326.html" title="教你一步步重装XP系统,让你的电脑重获新生" target="_blank">· 教你一步步重装XP系统,让你的电脑重获新生</a><span class="text-muted pull-right">02-05</span></dd>
<dd><a href="/win11/1005325.html" title="从备份到上网:一步步教你重装电脑系统" target="_blank">· 从备份到上网:一步步教你重装电脑系统</a><span class="text-muted pull-right">02-05</span></dd>
<dd><a href="/win11/1005324.html" title="Sony笔记本电脑一键重装系统详细图文教程" target="_blank">· Sony笔记本电脑一键重装系统详细图文教程</a><span class="text-muted pull-right">02-05</span></dd>
<dd><a href="/win11/1005323.html" title="Lenovo笔记本重装系统超详细教程，小白也能轻松上手" target="_blank">· Lenovo笔记本重装系统超详细教程，小白也能轻松...</a><span class="text-muted pull-right">02-05</span></dd>
<dd><a href="/win11/1005322.html" title="联想笔记本一键重装Win10系统详细教程" target="_blank">· 联想笔记本一键重装Win10系统详细教程</a><span class="text-muted pull-right">02-05</span></dd>
<dd><a href="/win11/1005321.html" title="电脑系统故障无需愁,专业维修店帮你重装旧貌换新颜" target="_blank">· 电脑系统故障无需愁,专业维修店帮你重装旧貌换新...</a><span class="text-muted pull-right">02-05</span></dd>
<dd><a href="/win11/1005320.html" title="联想笔记本一键重装Win10系统图文教程，小白也能轻松搞定！" target="_blank">· 联想笔记本一键重装Win10系统图文教程，小白也能...</a><span class="text-muted pull-right">02-05</span></dd>
<dd><a href="/win11/1005319.html" title="笔记本重装系统图文教程：从光盘启动一步到位" target="_blank">· 笔记本重装系统图文教程：从光盘启动一步到位</a><span class="text-muted pull-right">02-05</span></dd>
</dl>
            
           <dl class="col-sm-4 site-link">
                <dt>好站推荐</dt><dd> <a href="https://www.runoob.com" title="菜鸟教程(www.runoob.com)提供了编程的基础技术教程, 介绍了HTML、CSS、Javascript、Python，Java，Ruby，C，PHP , MySQL等各种编程语言的基础知识。 同时本站中也提供了大量的在线实例，通过实例，您可以更好的学习编程。" target="_blank">菜鸟教程</a></dd><dd> <a href="https://www.jb51.cc" title="编程之家(www.jb51.cc)是成立于2017年面向全球中文开发者的技术内容分享平台。提供编程导航、编程问答、编程博文、编程百科、编程教程、编程工具、编程实例等开发者最需要的编程技术内容与开发工具支持，与你一起学习编程，相信编程改变未来！" target="_blank">编程之家</a></dd><dd> <a href="" title="前端之家 f2er.com 前端开发人员所需学习知识手册。" target="_blank">前端之家</a></dd></dl>

            <dl class="col-sm-2 site-link">
                <dt>商务合作</dt>
                <dd><a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=76874919&site=qq&menu=yes">联系我们</a></dd>
            </dl>

        </div>
        <div class="copyright">
            Copyright © 2019 前端之家. 当前版本 V7.0.16<br>
            <span class="ml5">前端之家 版权所有 
            <a href="https://beian.miit.gov.cn/"  target="_blank"  rel="nofollow">闽ICP备13020303号-10</a></span>
        </div>
    </div>
</footer>
<script type="text/javascript" src="/js/base.js"></script>
</body>
</html>