https://blog.youkuaiyun.com/alzonezh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/alzone/article/details/52247845https://blog.youkuaiyun.com/alzone/article/details/52247845alzoneFri, 19 Aug 2016 09:50:07 +0800https://blog.youkuaiyun.com/alzone/article/details/9819939https://blog.youkuaiyun.com/alzone/article/details/9819939alzoneWed, 07 Aug 2013 17:12:31 +0800https://blog.youkuaiyun.com/alzone/article/details/9146921https://blog.youkuaiyun.com/alzone/article/details/9146921alzoneFri, 21 Jun 2013 16:57:38 +0800 conn /as sysdba  SQL>select userenv('language') from dual; SQL> shutdown immediate;  SQL> startup mount  SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;  SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESS]]>https://blog.youkuaiyun.com/alzone/article/details/9004644https://blog.youkuaiyun.com/alzone/article/details/9004644alzoneSat, 01 Jun 2013 17:08:28 +0800https://blog.youkuaiyun.com/alzone/article/details/8530763https://blog.youkuaiyun.com/alzone/article/details/8530763alzoneTue, 22 Jan 2013 17:04:58 +0800 show linesize linesize 1000 使用set命令的语法如下:   SET 系统变量  值]]>https://blog.youkuaiyun.com/alzone/article/details/8442215https://blog.youkuaiyun.com/alzone/article/details/8442215alzoneThu, 27 Dec 2012 10:25:57 +0800https://blog.youkuaiyun.com/alzone/article/details/8263685https://blog.youkuaiyun.com/alzone/article/details/8263685alzoneThu, 06 Dec 2012 10:07:29 +0800https://blog.youkuaiyun.com/alzone/article/details/8258189https://blog.youkuaiyun.com/alzone/article/details/8258189alzoneWed, 05 Dec 2012 00:26:37 +0800https://blog.youkuaiyun.com/alzone/article/details/8258146https://blog.youkuaiyun.com/alzone/article/details/8258146alzoneTue, 04 Dec 2012 23:50:54 +0800https://blog.youkuaiyun.com/alzone/article/details/6694401https://blog.youkuaiyun.com/alzone/article/details/6694401alzoneWed, 17 Aug 2011 12:08:37 +0800 show linesize;               //查看目前的linesize,默认是80 SQL> set linesize 100;           //设置成100或者更宽都可以 2、设置页面显示总行数 SQL> show p]]>https://blog.youkuaiyun.com/alzone/article/details/6624607https://blog.youkuaiyun.com/alzone/article/details/6624607alzoneFri, 22 Jul 2011 01:59:47 +0800https://blog.youkuaiyun.com/alzone/article/details/6624601https://blog.youkuaiyun.com/alzone/article/details/6624601alzoneFri, 22 Jul 2011 01:48:00 +0800https://blog.youkuaiyun.com/alzone/article/details/6393603https://blog.youkuaiyun.com/alzone/article/details/6393603alzoneWed, 04 May 2011 12:02:00 +0800一、闪回数据库 flashback database
1、可以处理的场景：
1）误删用户
2）truncate table
3）多表数据发生混乱
2、闪回数据库条件
1）数据库配置为归档模式
2）配置了闪回恢复区（FRA:flash recovery area）
   SQL>show parameter db_recovery_file;           ------包括路径和使用空间大小
3）配置闪]]>https://blog.youkuaiyun.com/alzone/article/details/6372040https://blog.youkuaiyun.com/alzone/article/details/6372040alzoneFri, 29 Apr 2011 15:01:00 +0800ORACLE数据库中，表，索引，存储过程，函数等都是对象。
schema 的名称与用户名相同，但是与用户不是同一回事，如果用户没有任何对象，则schema就不存在。
一、表
ORACLE表分四类：
普通表     ---  一个表对应一个segment
分区表 Partition Table   虚拟表，没有对应的segment
索引组织表  Index Organized Table  简称 IOT   虚拟表
簇表    ]]>https://blog.youkuaiyun.com/alzone/article/details/6371985https://blog.youkuaiyun.com/alzone/article/details/6371985alzoneFri, 29 Apr 2011 14:41:00 +0800https://blog.youkuaiyun.com/alzone/article/details/6370061https://blog.youkuaiyun.com/alzone/article/details/6370061alzoneThu, 28 Apr 2011 16:48:00 +0800https://blog.youkuaiyun.com/alzone/article/details/6338333https://blog.youkuaiyun.com/alzone/article/details/6338333alzoneThu, 21 Apr 2011 12:41:00 +0800https://blog.youkuaiyun.com/alzone/article/details/6333074https://blog.youkuaiyun.com/alzone/article/details/6333074alzoneTue, 19 Apr 2011 11:28:00 +0800用虚拟机经常碰到这种烦恼，刚开始设定硬盘空间的时候设小了，用了一段时间硬盘空间就不够用了，就像我今天装完了qt sdk后发现我的虚拟机可用空间是0，下面就给出如何增大你的硬盘空间的方法（以下方法的环境均为fedora7，虚拟机版本为6.0.2）：
1.edit你的虚拟机配置，add一个新的硬盘,具体操作为在虚拟机主界面上点击edit virtual machine settings-》add-》hard disk-》next-》create a nes virtual disk一路下去]]>