<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[volcano]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/iteye_6250</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; iteye_6250]]></copyright><item><title><![CDATA[SQL 循环执行及间隔多长时间后执行]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82647496</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82647496</guid><author>iteye_6250</author><pubDate>Thu, 18 Feb 2016 14:09:44 +0800</pubDate><description><![CDATA[
xxx
 
 
---------------------------------------------------


create table T_CONTINUE_WORK_TEST
(
  TEST_YEAR  NUMBER(4),
  TEST_MONTH NUMBER(2)
);

select * from t_continue_work_test;
...]]></description><category></category></item><item><title><![CDATA[Oracle job用法小结]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82645044</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82645044</guid><author>iteye_6250</author><pubDate>Tue, 15 Dec 2015 11:52:29 +0800</pubDate><description><![CDATA[
1.查询job信息select * from dba_jobs
相关视图dba_jobs describes all jobs in the database.user_jobs describes all jobs owned by the current userall_jobsdba_jobs_running 包含正在运行job相关信息
2.操作job命令
停止某个jobSQL&amp;gt...]]></description><category></category></item><item><title><![CDATA[Oracle 归档日志模式切换及手工归档]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82644700</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82644700</guid><author>iteye_6250</author><pubDate>Tue, 08 Dec 2015 16:06:11 +0800</pubDate><description><![CDATA[
 
 
1.非归档到归档模式
 
--查看数据库是否处于归档模式ARCHIVE LOG LISTDatabase log mode              No Archive Mode --非归档模式Automatic archival             Disabled     --未启动自动归档
--查看数据库是否处于归档模式SELECT log_mode FROM v...]]></description><category></category></item><item><title><![CDATA[Oracle RMAN 清除归档日志]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82644690</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82644690</guid><author>iteye_6250</author><pubDate>Tue, 08 Dec 2015 13:07:42 +0800</pubDate><description><![CDATA[
 
 
清除归档日志的方式
 
 
1、手动删除
 
使用rm 或者find方式来删除，通过该方式删除之后，在RMAN下可以通过 crosscheck archivelog all 校验归档是否失效，如下面的操作:oracle@y16:/opt/oracle/product/10.2/db_1/bin&amp;gt; ./rmanRMAN&amp;gt; connect target /
rm...]]></description><category></category></item><item><title><![CDATA[linux的一个find命令配合rm删除某天前的文件]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82644689</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82644689</guid><author>iteye_6250</author><pubDate>Tue, 08 Dec 2015 12:57:11 +0800</pubDate><description><![CDATA[
 
 
语句写法：find 对应目录 -mtime +天数 -name &quot;文件名&quot; -exec rm -rf {} \;例1：将/usr/local/backups目录下所有10天前带&quot;.&quot;的文件删除
 
find /usr/local/backups -mtime +10 -name &quot;*.*&quot; -exec rm -rf {} \;
find：linux的查找命令，用户查找指定条件...]]></description><category></category></item><item><title><![CDATA[默认路径存储归档文件最多2G]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82644557</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82644557</guid><author>iteye_6250</author><pubDate>Sat, 05 Dec 2015 19:29:41 +0800</pubDate><description><![CDATA[
 
 
Oracle 开启归档之后，由于归档默认路径存储归档文件最多2G，当归档爆满时，远程连接就会报错
修改归档文件大小ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8g;
 
不能登录为 systemORA-00257: archiver error. Connect internal only, until freed.
 
1：rm...]]></description><category></category></item><item><title><![CDATA[数据库启动错误，以及日志错误]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82642649</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82642649</guid><author>iteye_6250</author><pubDate>Wed, 28 Oct 2015 15:57:07 +0800</pubDate><description><![CDATA[
 
 
 ORA-01513: invalid current time returned by operating system
无效的操作系统返回当前时间
 
ORA-16038: log 3 sequence# 403 cannot be archivedORA-19809: limit exceeded for recovery filesORA-00312: online ...]]></description><category></category></item><item><title><![CDATA[触发器 REFERENCING OLD AS OLD]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82637116</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82637116</guid><author>iteye_6250</author><pubDate>Tue, 07 Jul 2015 20:34:43 +0800</pubDate><description><![CDATA[
 
REFERENCING OLD AS OLD NEW AS NEW FOR EACH Row
 
CREATE OR REPLACE TRIGGER TRI_DELETE_INFO
  AFTER DELETE ON T_INFO_2012
  REFERENCING OLD AS OLD NEW AS NEW
  FOR EACH ROW
DECLARE
  V_SQLE...]]></description><category></category></item><item><title><![CDATA[ 无法正常启动数据库]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82637070</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82637070</guid><author>iteye_6250</author><pubDate>Tue, 07 Jul 2015 10:04:30 +0800</pubDate><description><![CDATA[
 
 
 无法正常启动数据库，先用mount 状态启动，清除非归档日志。
alter database clear unarchived logfile group 3;
 
 
SQL&amp;gt; conn / as sysdba
Connected to an idle instance.
SQL&amp;gt; startup
ORACLE instance started.

...]]></description><category></category></item><item><title><![CDATA[Oracle修改表空间大小]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82635474</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82635474</guid><author>iteye_6250</author><pubDate>Tue, 02 Jun 2015 10:30:36 +0800</pubDate><description><![CDATA[
Oracle表空间限制，导致无法继续导入数据的原因。
如果在建立数据库时没有设置，Oracle 默认的表空间大小为400M，当数据库中数据量达到这个值，再向数据库中导入数据就会报错。解决方法是扩展表空间。可以选择将表容量扩大，比如扩展到5G，或者当表空间不够时每次自动增加一定的容量,如每次自增200M。
 
下面列出详细过程：
1、通过sql plus 命令登录数据库在命令行下输入sq...]]></description><category></category></item><item><title><![CDATA[如何启用Oracle10g闪回数据库]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82613697</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82613697</guid><author>iteye_6250</author><pubDate>Wed, 28 Jan 2015 15:55:13 +0800</pubDate><description><![CDATA[
配置闪回数据库可按以下步骤配置闪回数据库：（确保数据库处于ARCHIVELOG 模式。）1. 配置快速恢复区。2. 使用初始化参数DB_FLASHBACK_RETENTION_TARGET 设置保留目标。可指定一个上限（以分钟为单位），指示数据库能够闪回到多长时间以前。本示例使用了 2880 分钟，相当于两天。此参数只是一个目标，并不提供任何保证。闪回时间间隔取决于快速恢复区中保留的闪回数据量的...]]></description><category></category></item><item><title><![CDATA[Oracle如何创建跨用户视图]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82613408</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82613408</guid><author>iteye_6250</author><pubDate>Fri, 23 Jan 2015 10:51:32 +0800</pubDate><description><![CDATA[
      Oracle同一个实例下有两个用户A和B。       A用户下有个aaa表，B用户想创建一个视图查询A用户的aaa。怎么做？简单的执行grant dba to B就OK了么？错！       执行grant dba to B后，B用户可以select A用户下的表，但是当B用户试图创建一个视图查询A用户下的表时，会失败，被提示“权限不足！”。       那么该怎么做呢？     ...]]></description><category></category></item><item><title><![CDATA[恢复备份文件后，无法正常启动数据库]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82613389</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82613389</guid><author>iteye_6250</author><pubDate>Thu, 22 Jan 2015 23:21:34 +0800</pubDate><description><![CDATA[
 
控制文件损坏，需从备份文件中恢复，
但将备份文件恢复后，启动数据库是报错，如下：
ORA-00205: error in identifying control file, check alert log for more info
 
SQL&amp;gt; startup
ORACLE instance started.

Total System Global Area  6...]]></description><category></category></item><item><title><![CDATA[ORACLE 实用函数总结]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82613246</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82613246</guid><author>iteye_6250</author><pubDate>Wed, 21 Jan 2015 13:08:18 +0800</pubDate><description><![CDATA[
1、NULLIF(expr1,expr2)逻辑等价于：CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END；如果两个表达式相等，NULLIF 返回NULL；如果两个表达式不相等，NULLIF 返回第一个 expr1 的值。
2、NVL(expr1,expr2)逻辑等价于IF expr1 is null THEN expr2 ELSE expr1 EN...]]></description><category></category></item><item><title><![CDATA[多年的 SQL 优化经验]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82613230</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82613230</guid><author>iteye_6250</author><pubDate>Wed, 21 Jan 2015 11:17:56 +0800</pubDate><description><![CDATA[
（1） 选择最有效率的表名顺序(只在基于规则的优化器中有效)：ORACLE 的解析器按照从右到左的顺序处理FROM子句中的表名，FROM子句中写在最后的表(基础表 driving table)将被最先处理，在FROM子句中包含多个表的情况下,你必须选择记录条数最少的表作为基础表。如果有3个以上的表连接查询, 那就需要选择交叉表(intersection table)作为基础表, 交叉表是指那个...]]></description><category></category></item><item><title><![CDATA[Linux SUSE 鏡像下載地址]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82613123</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82613123</guid><author>iteye_6250</author><pubDate>Mon, 19 Jan 2015 20:13:30 +0800</pubDate><description><![CDATA[http://mirrors.tuna.tsinghua.edu.cn/opensuse/distribution/13.2/iso/openSUSE-13.2-DVD-x86_64.iso]]></description><category></category></item><item><title><![CDATA[Oracle的Flashback用法汇总]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82612386</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82612386</guid><author>iteye_6250</author><pubDate>Wed, 07 Jan 2015 19:37:13 +0800</pubDate><description><![CDATA[
/*
11g的flashbackup 分好几种，分别用途不一样。
A.flashback database 闪回数据库，简单理解就是把数据库闪回到某个以前的时间点，
能恢复到的最早的SCN， 取决与Flashback Log中记录的最早SCN
B.flashback drop 回收数据库表，用于表误drop后恢复。类似Windows的回收站。
C.flashback query 闪回表...]]></description><category></category></item><item><title><![CDATA[Linux下复制粘贴快捷键]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82612355</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82612355</guid><author>iteye_6250</author><pubDate>Wed, 07 Jan 2015 15:16:59 +0800</pubDate><description><![CDATA[
 
 
 
1. 在终端下：
          复制命令：Ctrl + Shift + C  组合键.
          粘贴命令：Ctrl + Shift + V  组合键.
 2. 在控制台下：
          复制命令：Ctrl + Insert  组合键　　 或　　用鼠标选中，即是复制。
          粘贴命令：Shift + Insert  组合键　　或...]]></description><category></category></item><item><title><![CDATA[oracle 实现插入自增列]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82612001</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82612001</guid><author>iteye_6250</author><pubDate>Wed, 31 Dec 2014 21:35:15 +0800</pubDate><description><![CDATA[
原文：http://lcf19890121.iteye.com/blog/2171349
 
oracle不同于sqlserver以及mysql,它不能直接设置某个字段进行自增，只能通过创建sequence的方式来实现自增列。   下面就来介绍下oracle实现插入自增列的方法    首先，我们需要创建一个sequence。   
create sequence temp_seq incr...]]></description><category></category></item><item><title><![CDATA[oracle用户创建及权限设置]]></title><link>https://blog.youkuaiyun.com/iteye_6250/article/details/82611967</link><guid>https://blog.youkuaiyun.com/iteye_6250/article/details/82611967</guid><author>iteye_6250</author><pubDate>Wed, 31 Dec 2014 10:37:57 +0800</pubDate><description><![CDATA[
 
该为原原创：，转载注明：http://www.pm-road.com/index.php/2014/12/12/285/
权限：
create session
create table
unlimited tablespace
connect
resource
dba
例：
#sqlplus /nolog
SQL&amp;gt; conn / as sysdba;
SQL&amp;g...]]></description><category></category></item></channel></rss>