https://blog.youkuaiyun.com/sysnlzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/sysnl/article/details/11678635https://blog.youkuaiyun.com/sysnl/article/details/11678635sysnlSat, 14 Sep 2013 12:59:24 +0800https://blog.youkuaiyun.com/sysnl/article/details/11406339https://blog.youkuaiyun.com/sysnl/article/details/11406339sysnlSun, 08 Sep 2013 23:32:28 +0800https://blog.youkuaiyun.com/sysnl/article/details/7820227https://blog.youkuaiyun.com/sysnl/article/details/7820227sysnlWed, 01 Aug 2012 21:49:34 +0800https://blog.youkuaiyun.com/sysnl/article/details/7820221https://blog.youkuaiyun.com/sysnl/article/details/7820221sysnlWed, 01 Aug 2012 21:47:53 +0800https://blog.youkuaiyun.com/sysnl/article/details/7296789https://blog.youkuaiyun.com/sysnl/article/details/7296789sysnlSun, 26 Feb 2012 23:52:40 +0800https://blog.youkuaiyun.com/sysnl/article/details/6946615https://blog.youkuaiyun.com/sysnl/article/details/6946615sysnlTue, 08 Nov 2011 09:09:32 +0800https://blog.youkuaiyun.com/sysnl/article/details/6889702https://blog.youkuaiyun.com/sysnl/article/details/6889702sysnlThu, 20 Oct 2011 10:02:55 +0800https://blog.youkuaiyun.com/sysnl/article/details/6840736https://blog.youkuaiyun.com/sysnl/article/details/6840736sysnlSun, 02 Oct 2011 18:30:44 +0800https://blog.youkuaiyun.com/sysnl/article/details/6785059https://blog.youkuaiyun.com/sysnl/article/details/6785059sysnlSat, 17 Sep 2011 16:01:35 +0800https://blog.youkuaiyun.com/sysnl/article/details/6686009https://blog.youkuaiyun.com/sysnl/article/details/6686009sysnlSun, 14 Aug 2011 14:30:35 +0800https://blog.youkuaiyun.com/sysnl/article/details/6668441https://blog.youkuaiyun.com/sysnl/article/details/6668441sysnlMon, 08 Aug 2011 10:28:01 +0800https://blog.youkuaiyun.com/sysnl/article/details/6218668https://blog.youkuaiyun.com/sysnl/article/details/6218668sysnlWed, 02 Mar 2011 17:04:00 +0800a)首先在windows下下载top，下载地址： ftp://ftp.sunfreeware.com/pub/freeware/sparc/10/top-3.6.1-sol10-sparc-local.gz
 
b) 用cuteftp上传到我的服务器上，注意如果上传不成功，并提示目录不可写，这通常是因为当前目录权限设置的原因，而不是因为FTP权限设置原因。
#mkdir /opt/tmp
 
上传后，就可以在上述目录中看到文件top-3.6.1-]]>https://blog.youkuaiyun.com/sysnl/article/details/6173391https://blog.youkuaiyun.com/sysnl/article/details/6173391sysnlSun, 06 Feb 2011 17:54:00 +0800Private Sub datagrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
On Error GoTo ErrCode
     ComboBox1.Visible = False
      If DataGrid1.Col > 0 And DataGri]]>https://blog.youkuaiyun.com/sysnl/article/details/6173387https://blog.youkuaiyun.com/sysnl/article/details/6173387sysnlSun, 06 Feb 2011 17:53:00 +0800SPFile文件是一个二进制格式的文件，尽管可以打开它查看其中的内容，但是任何用户都不应当手工对其内容进行修改，否则实例将无法启动。
    修改SPFile文件需要使用Alter System语句，可以在Set子句中通过Scope选项来设置Alter System语句的影响范围。
    a.Scope=SPFile：修改仅记录在SPFile文件中。只有在下一次启动数据库时修改才会生效，同时适用于动态/静态初始化参数。
    b.Scope=Memory：修改仅]]>https://blog.youkuaiyun.com/sysnl/article/details/6173386https://blog.youkuaiyun.com/sysnl/article/details/6173386sysnlSun, 06 Feb 2011 17:52:00 +0800alter database：修改数据文件
alter database datafile 4 offline;
alter database datafile '/opt/oracle/datafile/users01.dbf' offline;
alter database datafile '/opt/oracle/datafile/users01.dbf' resize 100M;
alter database datafile '/opt/ora]]>https://blog.youkuaiyun.com/sysnl/article/details/6173385https://blog.youkuaiyun.com/sysnl/article/details/6173385sysnlSun, 06 Feb 2011 17:51:00 +0800TOOL----->Export user objects,然后选中要备份的存储过程，右击Save Object Selection( 这一步可以省略，但是如果你有很多的存储过程，而且需要分成不同的模块时，那么下次你再备份时，可以直接]]>https://blog.youkuaiyun.com/sysnl/article/details/6173384https://blog.youkuaiyun.com/sysnl/article/details/6173384sysnlSun, 06 Feb 2011 17:50:00 +0800语法:
DROP TABLESPACE tablespace
[ INCLUDING CONTENTS [ {AND | KEEP} DATAFILES ]
[ CASCADE CONSTRAINTS ]
] ;
直接使用:
drop tablespace 会出现如下错误:
ORA-01116: error in opening database file 89
ORA-01110: data file 89: ']]>https://blog.youkuaiyun.com/sysnl/article/details/6173382https://blog.youkuaiyun.com/sysnl/article/details/6173382sysnlSun, 06 Feb 2011 17:49:00 +0800SQL> altere database datafile 'D:/DATABASE/ORACLE/ORADATA/ORATEST/USER_TEMP.DBF' offline drop;
使用上述命令将数据文件user_temp.dbf从表空间USERS中删除后，在dba_data_files中仍旧能够查询它，见下图。只是其中bytes，blocks，maxbytes是null，status是有效状态。
 


简单的对datafile的off]]>https://blog.youkuaiyun.com/sysnl/article/details/6173379https://blog.youkuaiyun.com/sysnl/article/details/6173379sysnlSun, 06 Feb 2011 17:46:00 +0800DECODE()函数，它将输入数值与函数中的参数列表相比较，根据输入值返回一个对应值。函数的参数列表是由若干数值及其对应结果值组成的若干序偶形式。当然，如果未能与任何一个实参序偶匹配成功，则函数也有默认的返回值。

　　区别于SQL的其它函数，DECODE函数还能识别和操作空值。
　　语法：DECODE(control_value,value1,result1[,value2,result2…][,default_result]);
　　contro]]>https://blog.youkuaiyun.com/sysnl/article/details/6173373https://blog.youkuaiyun.com/sysnl/article/details/6173373sysnlSun, 06 Feb 2011 17:39:00 +0800UX: userdel: ERROR: Inconsistent password files. See pwconv(1M).
bash-2.05# pwconv
bash-2.05# userdel -r ipnm2zznode
UX: userdel: ERROR: Unable to find status about home directory: No such file or dire]]>