09 2016 档案

sid超过8个字符处理步骤
摘要：服务端配置如下： [oracle@p3 admin]$ cat listener.ora # listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/ 阅读全文

posted @ 2016-09-20 19:50 Oracle-fans 阅读(439) 评论(0) 推荐(0)

oracle-行转列
摘要：--范例1 select 10 deptno_case10, (select distinct case deptno when 10 then listagg(empno, ',') within group(order by ename) else null end deptno from em 阅读全文

posted @ 2016-09-13 17:21 Oracle-fans 阅读(441) 评论(0) 推荐(0)

11g 创建asm磁盘组
摘要：[root@Oracle11g ~]# fdisk -l Disk /dev/sda: 21.4 GB, 21474836480 bytes255 heads, 63 sectors/track, 2610 cylindersUnits = cylinders of 16065 * 512 = 82 阅读全文

posted @ 2016-09-13 15:14 Oracle-fans 阅读(1057) 评论(0) 推荐(0)