09 2013 档案

摘要：上午有同事让我帮他删除数据，因为他用DELETE删除时很慢，就把删除语句发给我了：DELETE FROM cjcl.cj_cj_tbjd where bgq = '201309MM'我一看，这条语句所删除的内容正是某个分区的数据： SELECT COUNT(0) FROM cjcl.cj_cj_tbjd where bgq = '201308MM'; --RWID_601_BGQ_2013... 阅读全文

摘要：expdp cjcl/cjclpassword directory=dumpdir schemas=cjcl,zhyy,aqdb cluster=n dumpfile=zhtfzd-%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%-%U.dmp parallel=5 logfile=log-%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.logforfil... 阅读全文

摘要：SELECT COUNT(0) FROM cjcl.cj_cj_tbjd where bgq = '201308MM'; --RWID_601_BGQ_201309MMSELECT COUNT(0) FROM cjcl.cj_cj_tbjd SUBPARTITION (RWID_601_BGQ_201308MM)ALTER TABLE cjcl.cj_cj_tbjd TRUNCAT... 阅读全文

摘要：Extend 扩展元素的个数，且在使用下标时，只能到1到这个整个个数的范围：CREATE or replace type list_of_name is table of varchar2(1000);declarehappyfamily list_of_name:=list_of_name();--必须在使用的时候初始化，此处初始化为一个空元素,此处若不初始化，必须在体部初始化children ... 阅读全文

摘要：例：declaretype list_of_names is table of scott.emp.ename%type index by binary_integer;s_name list_of_names;l_row binary_integer;begins_name(11):='a1';s_name(2):='a2';s_name(3):='a3';s_name(4):='a4';s_n... 阅读全文

摘要：例一create table testerr(id number(10),name varchar2(10));insert into testerr values(1,'test');insert into testerr values(2,'test');insert into testerr values(3,'test1');--no_data_found和too_many_rows是经常... 阅读全文

摘要：通过数据字典v$backup_set_details可以查询RMAN的备份信息查看每天的备份总大小： SELECT to_char(start_time,'yyyy-mm-dd') 日期,round(SUM( CASE SUBSTR(output_bytes_display,LENGTH(output_bytes_display),1) WHEN 'G' THEN sub... 阅读全文