- 博客(11)
- 资源 (2)
- 收藏
- 关注
原创 oracle 之ADR(AUTOMATIC DIAGNOSTIC REPOSITORY)
oracle 之ADR(AUTOMATIC DIAGNOSTIC REPOSITORY)oracle@oracle:~> adrci -helpSyntax: adrci [-help] [script=script_filename] [exec = "one_command [;one_command;...]"]Options Descripti
2013-05-28 22:03:17 2208
原创 数据库启动scn cnt
数据库启动scn cnt 1)nomalDATA FILE #1: (name #10) /opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw_.dbfcreation size=0 block size=8192 status=0xe head=10 tail=10 dup=1 tablespace 0, inde
2013-05-27 21:57:05 967
原创 簇表、序列、同义词
SYS@orcl#create cluster stu_ach(sid number) 2 pctused 40 3 pctfree 10 4 size 200 5 storage 6 ( 7 initial 128K 8 next 128k 9 minextents 2 10 maxextents 20 11 ) 12 tablesp
2013-05-19 10:09:34 1205
原创 oracle 分区表,分区索引
oracle 分区表,分区索引1、分区表一)范围分区SCOTT@orcl#select tablespace_name from dba_tablespaces;TABLESPACE_NAME------------------------------SYSTEMSYSAUXUNDOTBS1TEMPUSERSUNDOTBS2VPN_HUADANTEST1TEMP
2013-05-18 18:49:09 1776
原创 oracle 索引、索引组织表、临时表、外部表
oracle 索引和索引表 一)索引语法:create unique|bitmap index .on .(|asc |desc,asc |desc,...)tablespacestoreagelogging | nologgingcompute statisticesnocompress | compressnosort | reverseparition | g
2013-05-16 22:21:04 1971
原创 oracle11g从11.2.0.3.0升级到11.2.0.3.6操作步骤(二)
oracle 11g 从11.2.0.3.0升级到11.2.0.3.6操作步骤操作步骤如下SQL> SHOW ERRORS;No errors.SQL> @?/rdbms/admin/prvtawr.plbSQL> /* -------------------------------------------------------------------------> *
2013-05-15 14:01:14 1587
原创 oracle 11g 从11.2.0.3.0升级到11.2.0.3.6操作步骤(一)
oracle 11g 从11.2.0.3.0升级到11.2.0.3.6操作步骤操作步骤如下:oracle@oracle-R2:/opt/oracle/datasoft/16056266> opatch applyOracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporatio
2013-05-15 11:39:35 15894
原创 oracle 11G 11.2.0.3.0 升级到11.2.0.3.6遇到的错误。
错误日志:[May 15, 2013 9:16:19 PM] OPatch invoked as follows: 'apply -invPtrLoc /opt/oracle/datasoft/oraInst.loc '[May 15, 2013 9:16:19 PM] OUI-67077: Oracle Home
2013-05-15 10:56:43 1996
原创 oracle 包创建
oracle 包的创建一)创建基本包--headcreate or replace package pac_emp is procedure add_employee(eno number, name varchar2,salary number ,dno number); end pac_emp;—bodycreate or replace package body p
2013-05-14 20:30:19 934
原创 oracle loap函数用法
先看测试情况: SCOTT@orcl#select level,lpad(' ',2*level-1)||ename as ename from emp 2 start with ename='KING' 3 connect by prior empno=mgr 4 order by level; LEVEL ENAME---------- -------
2013-05-11 20:16:39 1925
原创 oracle之触发器
oracle触发器 create table tri_tab(id int not null,oper_type varchar2(20),oper_time date, cha_EMPNO
2013-05-01 15:36:49 756
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人