- 博客(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
83
转载 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
127
转载 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
93
转载 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
96
转载 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
99
转载 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
161
转载 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
161
转载 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
137
转载 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
57
转载 crontab
#!/bin/ksh一、cron在3个地方查找配置文件1. cronjob file 位置/var/spool/cron/ 这个目录下存放的是每个用户包括root的crontab任务,每个任务以创建者的名字命名,比如tom建的c...
2011-11-30 13:07:21
57
转载 AWR --生成AWR报表
1. generate AWR report, AWR可以支持HTML .TXT格式的报表cd $ORACLE_HOME/rdbms/admin@awrrpt.sql2.生成指定数据库实例的统计报表@$ORACLE_HOME/r...
2011-11-29 13:11:23
184
转载 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
139
转载 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
90
转载 create job class
SQL> SELECT consumer_group FROM dba_rsrc_consumer_groups;CONSUMER_GROUP------------------------------OTHER_GROU...
2011-11-15 10:47:42
120
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人