- 博客(14)
- 收藏
- 关注
转载 shell - grep
1. grep RAM.*LHO.*.xml file_nameuse .* to express any character2. plusCNT=`insting $FILE_NAME IFFM`CNT=`expr 12 - ...
2012-03-12 17:53:15 75
转载 table blocks
1. check the blocks from dba_tablesSQL> create table test(id number, 2 name varchar2(50));Table createdSQL&g...
2012-01-05 14:58:13 118
转载 execute immediate
declare v_sql varchar2(500);v_table_name varchar2(50):='test';v_max_date date;v_partition_max varchar2(20)beginv_s...
2012-01-05 11:02:14 87
转载 xcopy dos command
Copies files and directory trees.XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W] ...
2011-12-08 17:31:24 90
转载 ls command
ls [-a] [-A] [-b] [-c] [-C] [-d] [-f] [-F] [-g] [-i] [-l] [-L] [-m] [-o] [-p] [-q] [-r] [-R] [-s] [-t] [-u] [-x] [...
2011-12-06 17:46:01 95
转载 del folder, subfolder and content of the folder by dos command
1. delete the folder DELTREE D:Work1DGEDA_D'DELTREE' is not recognized as an internal or external command,operable...
2011-12-06 14:29:24 156
转载 ORA-02298 error
ORA-02298: cannot validate (A.TE_ID ) - parent keys not foundsolution:select xxxxx from child_table a where not ex...
2011-12-01 14:08:32 147
转载 chmod chown owner
1. change 属组# change //tmp/src owner to john, 属组buildchown -R john:build /tmp/src2. change 文件权限chmod 777 /tmp/srcr...
2011-11-30 14:47:06 132
转载 tar
1. tar foldertar cpf /u05/workarea/helen/tomcat_config.tar /**/app/tomcat/tomcat/2. tar file3. tar file recurringt...
2011-11-30 14:10:54 51
转载 crontab
#!/bin/ksh一、cron在3个地方查找配置文件1. cronjob file 位置/var/spool/cron/ 这个目录下存放的是每个用户包括root的crontab任务,每个任务以创建者的名字命名,比如tom建的c...
2011-11-30 13:07:21 51
转载 AWR --生成AWR报表
1. generate AWR report, AWR可以支持HTML .TXT格式的报表cd $ORACLE_HOME/rdbms/[email protected].生成指定数据库实例的统计报表@$ORACLE_HOME/r...
2011-11-29 13:11:23 180
转载 ssh-keygen -t rsa
C:Documents and Settingstomcat>mkdir .sshC:Documents and Settingstomcat>ssh-keygen -t rsaGenerating public/p...
2011-11-16 18:11:07 131
转载 DBMS_SCHEDULER privilege
1. SCHEDULER_ADMINThe SCHEDULER_ADMIN role gives a user the ability to control every aspect of the scheduler, as w...
2011-11-15 18:03:43 83
转载 create job class
SQL> SELECT consumer_group FROM dba_rsrc_consumer_groups;CONSUMER_GROUP------------------------------OTHER_GROU...
2011-11-15 10:47:42 116
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人