ITPub博客

[oracle@kf210 ~]$ cat c.shcd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ init/rm *cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ table/rm *cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/02\ view/rm *cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/04\ procedure/rm *cd /u01...

declare v_text clob; v_owner varchar2(30); v_view_name varchar2(30); v_count number; v_loc number; v_loc_s number; v_len number; v_text_len number; v_count_s number; v_count_t number; cursor c_xv is  select av.owner,av.view_name...

ora-600 [2252]<br /><br />解决方法：更改系统至当前时间，并重启数据库

<p style="color:#333333;font-family:Arial;font-size:14px;line-height:26px;white-space:normal;background-color:#FFFFFF;">NAT模式的具体配置</p><p style="color:#333333;font-family:Arial;font-size:14px;line-height:26px;white-space:normal;background-color:#FFFFFF;">NAT方式：虚拟机可以上外网，可以访...

<div style="color:#666666;font-family:宋体, Arial;font-size:16px;line-height:26px;white-space:normal;background-color:#FFFFFF;"><span style="font-size:small;">环境:</span></div><div style="color:#666666;font-family:宋体, Arial;font-size:16px;line-height:26px;white-space:normal;background-color:#...

alter table tablename<br /><img src="/attachment/201509/17/29802484_1442477881XtEN.png" width="378" height="91" alt="" /><br /><br /><br /><br />eg:<br /><br /><br />alter table J1_DW.DM0_DJ_NSRQC rename PARTITION LIST_2020150401 to LIST_20150401;<br /><br /><br />...

<p class="MsoNormal"><span lang="EN-US">监听1：<br />LISTENER=</span></p><p class="MsoNormal"><span lang="EN-US">&nbsp;(DESCRIPTION=</span></p><p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp;(ADDRESS_LIST=</span></p><p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp...

Example 2–41 Configuring Device and Backup OptionsThis example configures channels of device type DISK and sbt and sets the default device type as sbt. The example also enables backup optimization and configures a recovery windows of two weeks.CONFIGURE CHANNEL...

[root@rac1 soft]# rpm -ivh *.rpm<br />error: oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm: rpmReadSignature failed: sigh blob(328): BAD, read returned 118<br />error: oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm cannot be installed<br />error: oracleasmlib-2.0.4-1.el5.i386.rpm: rpmReadSignature...

<img src="/attachment/201508/28/29802484_1440755135H1Ho.png" width="578" height="394" alt="" /><br />

<p style="margin-top:0px;margin-bottom:0px;clear:both;height:auto;overflow:hidden;color:#555555;font-family:宋体, 'Arial Narrow', arial, serif;font-size:14px;line-height:28px;white-space:normal;background-color:#FFFFFF;">查看SELinux状态：</p><p style="margin-top:0px;margin-bottom:0px;clear:both;...

<span style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;line-height:20px;white-space:normal;background-color:#FFFFFF;">在oracle中chr()数和ascii()是一对反函数。<br /><br /><p style="margin:10px auto;font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;line-height:2...

<div class="tit" style="color:#333333;font-family:Arial;font-size:14px;line-height:26px;white-space:normal;background-color:#FFFFFF;">ORA-12638: 身份证明检索失败 的解决办法</div><table border="0" style="color:#333333;font-family:Arial;font-size:14px;line-height:26px;background-color:#FFFFFF;tabl...

declare v_text clob; v_owner varchar2(30); v_view_name varchar2(30); v_count number; v_loc number; v_loc_s number; v_len number; cursor c_xv is  select xv.owner,xv.view_name from xt_vwqd xv,al...

declare<br />&nbsp;v_text clob;<br />&nbsp;v_owner varchar2(30);<br />&nbsp;v_view_name varchar2(30);<br />&nbsp;v_count number;<br />&nbsp;v_loc number;<br />&nbsp;v_loc_s number;<br />&nbsp;v_len number;<br />-- select av.view_name,av.owner from all_views av where av.owner='J1_DW' and av.v...

declare v_text varchar2(4000); v_line number; v_max_line number; v_owner varchar2(30); v_name varchar2(30); v_type varchar2(12);-- i_owner varchar2(30);-- i_object varchar2(30); cursor c_xo is&nb...

declare<br />&nbsp;v_text varchar2(4000);<br />&nbsp;v_line number;<br />&nbsp;v_min_line number;<br />&nbsp;v_max_line number;<br />-- i_owner varchar2(30);<br />-- i_object varchar2(30);<br />&nbsp;cursor c_as is<br />&nbsp; select line,case when line=1 then 'create or replace '||text&nbsp...

SQL&gt; declare<br />&nbsp; 2 &nbsp; v_text clob;<br />&nbsp; 3 &nbsp; --v_len number;<br />&nbsp; 4 &nbsp;begin<br />&nbsp; 5 &nbsp; SELECT dbms_metadata.get_ddl('VIEW','V_SB_QYSDSNDSSYHQKMXB','J1_DW') INTO V_TEXT from dual;<br />&nbsp; 6 &nbsp; dbms_output.put_line(v_text);<br />&nbsp; 7 &nb...

错误：<br /><br />ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)<br /><br />解决方法：<br /><br />service mysqld start<br />

IE和OEM的BUG<br /><br />换linux自带的Firefox浏览器即可