https://blog.youkuaiyun.com/libingquan008zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/libingquan008/article/details/40711133https://blog.youkuaiyun.com/libingquan008/article/details/40711133libingquan008Sun, 02 Nov 2014 16:34:24 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40710811https://blog.youkuaiyun.com/libingquan008/article/details/40710811libingquan008Sun, 02 Nov 2014 16:13:34 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40710757https://blog.youkuaiyun.com/libingquan008/article/details/40710757libingquan008Sun, 02 Nov 2014 16:10:38 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40682283https://blog.youkuaiyun.com/libingquan008/article/details/40682283libingquan008Sat, 01 Nov 2014 17:15:43 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40656691https://blog.youkuaiyun.com/libingquan008/article/details/40656691libingquan008Fri, 31 Oct 2014 16:30:10 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40424863https://blog.youkuaiyun.com/libingquan008/article/details/40424863libingquan008Fri, 24 Oct 2014 12:19:17 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40424361https://blog.youkuaiyun.com/libingquan008/article/details/40424361libingquan008Fri, 24 Oct 2014 11:01:06 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40423295https://blog.youkuaiyun.com/libingquan008/article/details/40423295libingquan008Fri, 24 Oct 2014 10:13:20 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40422879https://blog.youkuaiyun.com/libingquan008/article/details/40422879libingquan008Fri, 24 Oct 2014 09:54:12 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40394551https://blog.youkuaiyun.com/libingquan008/article/details/40394551libingquan008Thu, 23 Oct 2014 11:52:01 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40393341https://blog.youkuaiyun.com/libingquan008/article/details/40393341libingquan008Thu, 23 Oct 2014 10:55:34 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40392809https://blog.youkuaiyun.com/libingquan008/article/details/40392809libingquan008Thu, 23 Oct 2014 10:41:50 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40392569https://blog.youkuaiyun.com/libingquan008/article/details/40392569libingquan008Thu, 23 Oct 2014 10:23:08 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40392451https://blog.youkuaiyun.com/libingquan008/article/details/40392451libingquan008Thu, 23 Oct 2014 10:19:38 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40392061https://blog.youkuaiyun.com/libingquan008/article/details/40392061libingquan008Thu, 23 Oct 2014 09:56:34 +0800https://blog.youkuaiyun.com/libingquan008/article/details/40391691https://blog.youkuaiyun.com/libingquan008/article/details/40391691libingquan008Thu, 23 Oct 2014 09:42:10 +0800https://blog.youkuaiyun.com/libingquan008/article/details/6021441https://blog.youkuaiyun.com/libingquan008/article/details/6021441libingquan008Fri, 19 Nov 2010 14:08:00 +0800使用alter database 移动数据文件时，在执行完alter database rename to 命令之后，再试图打开数据库:alter database open。报错：
ORA-01113:文件7需要介质恢复
ORA-01110:数据文件7：’E:ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/TEST01.DBF’。
这是由于数据库认为这个数据文件遭到破坏了，需]]>https://blog.youkuaiyun.com/libingquan008/article/details/6021437https://blog.youkuaiyun.com/libingquan008/article/details/6021437libingquan008Fri, 19 Nov 2010 14:07:00 +0800建立表空间
CREATE TABLESPACE data01
DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M
UNIFORM SIZE 128k;             #指定区尺寸为128k,如不指定，区尺寸默认为64k
删除表空间
DROP TABLESPACE data01 INCLUDING CONTENTS AND DATAFILES;
修改表空间大小
alte]]>https://blog.youkuaiyun.com/libingquan008/article/details/6019344https://blog.youkuaiyun.com/libingquan008/article/details/6019344libingquan008Thu, 18 Nov 2010 16:15:00 +0800chr()函数将ASCII码转换为字符：字符 –》 ASCII码；
ascii()函数将字符转换为ASCII码：ASCII码 –》 字符；
在oracle中chr()函数和ascii()是一对反函数。
chr()函数示例：SQL> select chr(65) from dual;
 
CHR(65)
-------
A
accii()函数示例：SQL> select ascii('A') from dual;https://blog.youkuaiyun.com/libingquan008/article/details/5987558https://blog.youkuaiyun.com/libingquan008/article/details/5987558libingquan008Thu, 04 Nov 2010 15:49:00 +0800分析表
analyze table tablename compute statistics for all indexes;
analyze table tablename compute statistics for all indexed columns;
analyze table tablename compute statistics for table;

监控事例的等待

select event,s]]>