ITPub博客

[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浏览器即可

To take a datafile offline when the database is in NOARCHIVELOG mode, use the ALTER DATABASE statement with both the DATAFILE and OFFLINE FOR DROP clauses. ■ The OFFLINE keyword causes the database to mark the datafile OFFLINE, whether or not it is corrupted, so that you can open ...

create or replace procedure p_getusertabdata(i_user in varchar2)is-- fhandle utl_file.file_type;-- v_line varchar2(4000); v_user varchar2(30); v_table varchar2(30); v_oner varchar2(30); v_line varchar2(4000); cursor cur_tab is  select xt.owner,xt.table_name fro...

点击(此处)折叠或打开create or replace procedure p_di_tab_synislvc_di_tab_sql varchar2(4000);cursor cur_di_tab isselect \'create or replace synonym \'||table_name||\' for \'||owner||\'.\'||table_name synonym_sql...

create or replace procedure p_gettabdata(i_owner in varchar2,i_table in varchar2)isv_insrt varchar2(4000);v_column_row varchar2(4000);v_mx_col_id number;v_owner varchar2(30);v_table varchar2(30);cursor cur_f is select atc.COLUMN_NAME,atc.DATA_TYPE,atc.CHAR_LENGTH,atc.COLUMN_ID,atc.num_n...

set pagesize 0set linesize 4000set feedback offcol text for a4000spool I:\J1_G3_ZBQ.sqlselect   case when ds.line=1 and rownum=1 then 'create or replace '||text       when ds.line=1 and ds.type='PROCEDURE' and rownum<>1 then '/'||chr(10)||'create or replace '||te...

create or replace procedure p_getusertabsql(   avc_user    varchar2)is  lvc_user      varchar2(30);  lvc_table     varchar2(30);  li_count      number(10);  lvc_bbbz      varchar2(200);  lv...

create or replace procedure p_gettabsql(   avc_user    varchar2,   avc_table   varchar2)is  lvc_user      varchar2(30);  lvc_table     varchar2(30);  fhandle utl_file.file_type;  li_count       ...

一、建立表时候，注意PCTFREE参数的作用      PCTFREE：为一个块保留的空间百分比，表示数据块在什么情况下可以被insert，默认是10，表示当数据块的可用空间低于10%后，就不可以被insert了，只能被用于update；即：当使用一个block时，在达到pctfree之前，该block是一直可以被插入的，这个...