ITPub博客

http://www.opensight.cn这里的一切内容都移过去了！[@more@]

欢迎大家访问我的新BLOGhttp://www.opensight.cn这里的所有内容都移过去了！一个oracle9i，没有启用undotbs，但是启用了rbs，因为rbs数据文件被误删除，造成无法进行任何ddl/dml操作，解决步骤如下：注释init.ora中rollback_segments = (rbs01,...)添加rollback_segments=(system); _corrupted_rollback_segments=(rbs01,...)重启db，删除rbd表空间，新建undotbs表空间注释init.ora中所有有关rollback_segments的部分，添加UNDO_MANAGEMENT=auto； UNDO_TABLESPACE=undotbs重启db[@more@]

1.ALTER MATERIALIZED VIEW viewname REFRESH FAST2.BEGINDBMS_MVIEW.REFRESH (list => 'viewname',Method =>'C',refresh_after_errors => True);END;第二种比较有效！[@more@]

发现把oracle用户放在dba组里也不行了，放在oinstall组里解决问题。[@more@]

如果Automatic archival是Enabled，PROTECTION_LEVEL就是MAXIMUM PERFORMANCE；如果是Disable，PROTECTION_LEVEL就是UNPROTECTED[@more@]

This message is strictly informational. The "user requested cancel of current operation on rowid AAAAAAAAAx" error is just evidence of excessive rollback activity on the source database. This is when a user issues a ctrl c during execution of a script or someone's session was killed before a commit was issued. This is not a fatal error.[@more@]

SET verify OFF 取消参数传入时对sql的校验set pagesize 0 取消返回记录之间的空行[@more@]

update table1 set f1=(select b.f1 from table2 b,table1 a where a.id=b.id), f2=(select b.f2 from table2 b,table1 a where a.id=b.id), f3=(select b.f3 from table2 b,table1 a where a.id=b.id)；[@more@]

select a.sid,spid,status,substr(a.program,1,40) prog,a.terminal,osuser,value,d.SQL_TEXTfrom v$session a,v$process b,v$sesstat c,v$sqltext dwhere c.statistic#=12 and c.sid=a.sid and a.paddr=b.addrand a.sql_address =d.address order by value desc;value的单位是1/100秒[@more@]

select nvl2(translate('81726ad76','1234567890',''),'is characters','is number') from dual;返回 'is characters'select nvl2(translate('8172217976','1234567890',''),'is characters','is number') from dual;返回 'is number'这两句SQL里在c2的最前面有个反斜杠，c3就是一个反斜杠，ITPUB的BLOG输不进反斜杠。[@more@]解释：TRANSLATE(c1,c2,c3)　将c1中与c2相同的字符以c3代替example:SQL> select TRANSLATE('fumble','uf','ar') test from dual;TEST------rambleSQL> select translate('8172217976','1234567890','') fro

issue:bash-3.2# sqlplus xxxx/xxxxSQL*Plus: Release 10.2.0.2.0 - Production on Wed Apr 2 02:30:05 2003Copyright (c) 1982, 2005, Oracle. All Rights Reserved.ERROR:ORA-01034: ORACLE not availableORA-27121: unable to determine size of shared memory segmentSVR4 Error: 13: Permission denied[@more@]This is caused by Oracle installer not setting setuidon $ORACLE_HOME/bin/oracle.Fix:# cd $ORACLE_HOME/bin# chmod 6751 oracle

克隆ORACLE之后用SYSDBA登陆出现1031错误，原因是新建的ORACLE用户没有放在DBA组里。[@more@]

轉載自全聯 SNLNCAM - CAM通常是用數碼攝像機從電影院盜錄。即所謂的「電影版」，有時可以使用小三角架在電影院進行盜錄，但大多數時候不可能，除非管理員是你家親戚或者你把管理員都幹掉了，出於這種原因攝像機會經常抖動。並且由 於聲音是從攝像機自帶的話筒錄製，所以經常會錄到觀眾的笑聲等聲音，尤其是喜劇片。因為這些因素，圖像和聲音質量通常都很差。但很幸邚膩頉]有在熱血看到過這種版本。[@more@]TELESYNC (TS) - TS比CAM優越的地方是，在偷錄的時候使用了外置的音源（一般是影院座椅上為聽力不好的人而設的耳機孔），但是這並不

查找N天前的文件find directory -mtime +N查找N天前的文件并删除它们find directory -mtime +N -exec rm {} ;[@more@]

1. Create a table to store DDL informationcreate table ddl$trace(login_user varchar2(50),ddl_time date,ip_address varchar2(50),audsid varchar2(50),schema_user varchar2(20),schema_object varchar2(50),ddl_sql varchar2(500));[@more@]2. Create a trigger which will be triggered while DDL executedCREATE OR REPLACE TRIGGER tr_trace_ddl after DDL ON DATABASE declare sql_text ora_name_list_t; state_sql ddl$trace.ddl_sql%TYPE; BEGIN FOR i IN 1..ora_sql_txt(sql_text) LOOP state_sql := state_sql||sql_text(i

＃date '+%Y%m%d' | awk '{ print $1 }'20061019＃date '+%Y%m%d' | awk '{ print $1-1 }'20061018...........................................bash-2.03# more main.sh#!/bin/shdt=`date '+%Y%m%d' | awk '{ print $1-1 }'`mv billing_detail.xls billing_detail_${dt}.xls[@more@]

GRANT CREATE MATERIALIZED VIEW TO xxxxx[@more@]

select add_months(sysdate,12) from dual;[@more@]select add_months(sysdate,12的整数倍) from dual;

把脚本COPY出来，删掉最后的"/;"，再执行就可以了。[@more@]

SQL> create pfile='initsid.ora' from spfile;[@more@]