ITPub博客

1. grep RAM.*LHO.*.xml file_nameuse .* to express any character2. plusCNT=`insting $FILE_NAME IFFM`CNT=`expr 12 - $CNT `[@more@]s

1. check the blocks from dba_tablesSQL> create table test(id number, 2 name varchar2(50));Table createdSQL> select table_name,blocks,empty_blocks,num_rows from user_tables where table_name ='TEST';TABLE_NAME BLOCKS EMPTY_BLOCKS NUM_ROWS------------------------------ ---------- ------------ ----------TEST SQL> insert into test values(1,'test');1 row insertedSQL> commit;Commit completeSQL> select table_na

declare v_sql varchar2(500);v_table_name varchar2(50):='test';v_max_date date;v_partition_max varchar2(20)beginv_sql :='select min(to_date(log_date,''dd-Mon-yyyy'')) from '||v_table_name||'_HIST_EXT';execute immediate (v_sql) into v_max_date;v_partition_date := trunc(v_max_date -i);v_partition_name := upper('P') ||to_char(v_max_date - 1, 'yyyy_mm_dd');v_sql := 'alter table ' || v_table_name || ' split partition ' ||v_partition_max ;v_sql := v_sql || ' at ( TO_DATE(''' || to_char(v_partition_dat