<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[milia_mxj]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/milia</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; milia]]></copyright><item><title><![CDATA[connection和session的关系]]></title><link>https://blog.youkuaiyun.com/milia/article/details/4868604</link><guid>https://blog.youkuaiyun.com/milia/article/details/4868604</guid><author>milia</author><pubDate>Wed, 25 Nov 2009 09:54:00 +0800</pubDate><description><![CDATA[1.官方解释： 1.1 connection:    A connection is a physical path from a client to an Oracle instance. A connection is established either over a network or over an IPC mechanism. A connection is typica]]></description><category></category></item><item><title><![CDATA[RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due   ]]></title><link>https://blog.youkuaiyun.com/milia/article/details/4583713</link><guid>https://blog.youkuaiyun.com/milia/article/details/4583713</guid><author>milia</author><pubDate>Wed, 23 Sep 2009 12:59:00 +0800</pubDate><description><![CDATA[今天在运行 delete obsolete报错了RMAN> delete obsolete;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1using channel ORA_DISK_1using channel ORA_DISK_2Deleti]]></description><category></category></item><item><title><![CDATA[从9i导出10g内容报 EXP-00003错误]]></title><link>https://blog.youkuaiyun.com/milia/article/details/3925490</link><guid>https://blog.youkuaiyun.com/milia/article/details/3925490</guid><author>milia</author><pubDate>Mon, 23 Feb 2009 09:08:00 +0800</pubDate><description><![CDATA[  上周五 从9i客户端 导 10g数据库 内容时 出了 EXP-00003 未找到XXX段定义的错误网上搜了一把，发现是和Oracle的一个小Bug相关。（解决方法记录在此，用于学习） 可以修改导出的一个视图 来解决在目标数据库使用sys用户，查看exu9tne 定义CREATE OR REPLACE VIEW exu9tne (tsno, fileno, block]]></description><category></category></item><item><title><![CDATA[ORACLE 10G HTML DB 2.0 安装配置]]></title><link>https://blog.youkuaiyun.com/milia/article/details/3858396</link><guid>https://blog.youkuaiyun.com/milia/article/details/3858396</guid><author>milia</author><pubDate>Mon, 02 Feb 2009 14:29:00 +0800</pubDate><description><![CDATA[ 1.首先安装数据库10g2.到http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html下载Oracle Database 10g Companion CD Release 2 (10.2.0.1.0)和Oracle Application Express (fo]]></description><category></category></item><item><title><![CDATA[rman恢复好数据库 exp时 出错 EXP-00056 ORA-01403]]></title><link>https://blog.youkuaiyun.com/milia/article/details/3522187</link><guid>https://blog.youkuaiyun.com/milia/article/details/3522187</guid><author>milia</author><pubDate>Mon, 15 Dec 2008 16:17:00 +0800</pubDate><description><![CDATA[在前一章中 数据库恢复好后 进行exp时 报错如下[oracle@testsmb admin]$ exp SJTICKET/fortest@SJTICKET rows=y indexes=y CONSTRAINTS=Y compress=n buffer=4096 feedback=100000 file=/opt/oracle/mxj_test.dmp log=/opt/oracle/mxj_t]]></description><category></category></item><item><title><![CDATA[用rman备份64位的备份集 恢复32位数据库过程]]></title><link>https://blog.youkuaiyun.com/milia/article/details/3520458</link><guid>https://blog.youkuaiyun.com/milia/article/details/3520458</guid><author>milia</author><pubDate>Mon, 15 Dec 2008 12:52:00 +0800</pubDate><description><![CDATA[1.	拷贝文件到linux系统 AfterSVC_SJTICKET_20081211_88  AfterSVC_SJTICKET_20081211_91  AfterSVC_SJTICKET_20081211_94  rmanback_2008_12_11_11_32.logAfterSVC_SJTICKET_20081211_89  AfterSVC_SJTICKET_20081211_92  ]]></description><category></category></item><item><title><![CDATA[linux 光驱加载错误问题:can't find /mnt/cdrom in /etc/fstable or /etc/mtab]]></title><link>https://blog.youkuaiyun.com/milia/article/details/3244869</link><guid>https://blog.youkuaiyun.com/milia/article/details/3244869</guid><author>milia</author><pubDate>Fri, 07 Nov 2008 10:09:00 +0800</pubDate><description><![CDATA[linux 光驱加载错误问题:mount: can`t find /mnt/cdrom in /etc/fstable or /etc/mtab解决方法: 1、首先查看#cat /etc/fstab   查看到类似下面的一行；   /dev/hdc /media/cdrecorder auto users,exec,noauto,managed 0 0   通过这个，我们能知道hdc 就是cdro]]></description><category></category></item><item><title><![CDATA[conn / as sysdba 报错ORA-01012: not logged on ]]></title><link>https://blog.youkuaiyun.com/milia/article/details/3191477</link><guid>https://blog.youkuaiyun.com/milia/article/details/3191477</guid><author>milia</author><pubDate>Fri, 31 Oct 2008 09:46:00 +0800</pubDate><description><![CDATA[今天听同事说，数据库连不上去了，客户端连上去报 ora- 12560：TNS错误登录服务器后，发现conn / as sysdba也报错，为ORA-01012: not logged on ，查了alert.log日志也没发现什么就试着用其他用户登了下，报的错误不同了ORA-01089: immediate shutdown in progress - no operation]]></description><category></category></item><item><title><![CDATA[standby 添加 temp文件]]></title><link>https://blog.youkuaiyun.com/milia/article/details/3185769</link><guid>https://blog.youkuaiyun.com/milia/article/details/3185769</guid><author>milia</author><pubDate>Thu, 30 Oct 2008 15:59:00 +0800</pubDate><description><![CDATA[做完standby后，忘记添加temp文件了，补上：SQL> select d.tablespace_name  from dba_tablespaces d where d.contents=TEMPORARY;TABLESPACE_NAME------------------------------TEMPSQL> select name from v$tempfile;n]]></description><category></category></item><item><title><![CDATA[standby database 中的登录触发器 导致 ORA-00604 ORA-16000]]></title><link>https://blog.youkuaiyun.com/milia/article/details/3184942</link><guid>https://blog.youkuaiyun.com/milia/article/details/3184942</guid><author>milia</author><pubDate>Thu, 30 Oct 2008 14:46:00 +0800</pubDate><description><![CDATA[前段事件公司dba说登录 standby库 用非dba 身份进入时 报出ORA-00604 ORA-16000错误，经过核查，发现是登录触发器的原因，现将该错复现如下： 在primary库中存在登录触发器 如下：conn milia/xxxx create table session_history ( USERNAME   varchar2(20), SID    number,]]></description><category></category></item><item><title><![CDATA[nvarchar2 到 varchar2的转换]]></title><link>https://blog.youkuaiyun.com/milia/article/details/3108940</link><guid>https://blog.youkuaiyun.com/milia/article/details/3108940</guid><author>milia</author><pubDate>Mon, 20 Oct 2008 10:11:00 +0800</pubDate><description><![CDATA[最近做的项目中，所有的字符的类型都是nvarchar2类型，发现在进行多层调用时会出现问题报Error: PL/SQL: ORA-12714: invalid national character set specifiedLine: 90Text: ,max(e.ticketno) over(partition by e.passengerid) ticketno解决办法把nva]]></description><category></category></item><item><title><![CDATA[oracle中求积]]></title><link>https://blog.youkuaiyun.com/milia/article/details/2900313</link><guid>https://blog.youkuaiyun.com/milia/article/details/2900313</guid><author>milia</author><pubDate>Mon, 08 Sep 2008 16:22:00 +0800</pubDate><description><![CDATA[以前一直好奇，oracle中提供sum函数，为什么没有multiply函数呢？原来可以这样写的：select  sum(id)"和",power(10,sum(log(10,t.id )))"乘积"  from   (select 1 id from dualunion select 2 id from dualunion select 3 id from dualunion select 7]]></description><category></category></item><item><title><![CDATA[dblink ORA-22992的解决办法]]></title><link>https://blog.youkuaiyun.com/milia/article/details/2867337</link><guid>https://blog.youkuaiyun.com/milia/article/details/2867337</guid><author>milia</author><pubDate>Tue, 02 Sep 2008 16:01:00 +0800</pubDate><description><![CDATA[今天在做dblink查数据的时候报错：ORA-22992: cannot use LOB locators selected from remote tables因为该表中存在blob类型的列解决办法：create  table tsalesorder as select SIGNATURELABELIMAGE from tsalesorder@ESCALADE19 或者c]]></description><category></category></item><item><title><![CDATA[备份归档日志报错 ORA-19625 的解决办法 ]]></title><link>https://blog.youkuaiyun.com/milia/article/details/2812788</link><guid>https://blog.youkuaiyun.com/milia/article/details/2812788</guid><author>milia</author><pubDate>Fri, 22 Aug 2008 11:08:00 +0800</pubDate><description><![CDATA[今天在备份归档日志的时候，出错了，发现是由于备份的目录改变了RMAN> backup archivelog all delete input; --备份默认目录下所有归档日志，并且删除这个目录下所有归档日志Starting backup at 21-AUG-08current log archivedusing channel ORA_DISK_1RMAN-00571: =========]]></description><category></category></item><item><title><![CDATA[ORACLE备份策略之二（精华）]]></title><link>https://blog.youkuaiyun.com/milia/article/details/2804563</link><guid>https://blog.youkuaiyun.com/milia/article/details/2804563</guid><author>milia</author><pubDate>Thu, 21 Aug 2008 08:47:00 +0800</pubDate><description><![CDATA[ 第五章. 定制恰当的备份策略5.1 定制正确的策略正确的备份策略不仅能保证数据库服务器的24*7的高性能的运行，还能保证备份与恢复的快速性与可靠性。我们将以RMAN的多级增量备份作为一个备份策略的例子来讨论。采用多级备份就是为了减少每天备份所需要的时间，而又保证系统有良好的恢复性。恢复时间与备份时间要有一个权衡。比如只要进行一个数据库的全备份，然后就只备份归档也可以保证能把数据库恢复]]></description><category></category></item><item><title><![CDATA[ORACLE备份策略之一（精华）]]></title><link>https://blog.youkuaiyun.com/milia/article/details/2804552</link><guid>https://blog.youkuaiyun.com/milia/article/details/2804552</guid><author>milia</author><pubDate>Thu, 21 Aug 2008 08:42:00 +0800</pubDate><description><![CDATA[第一章. 概要1、了解什么是备份2、了解备份的重要性3、理解数据库的两种运行方式4、理解不同的备份方式及其区别5、了解正确的备份策略及其好处第二章. 了解备份的重要性可以说，从计算机系统出世的那天起，就有了备份这个概念，计算机以其强大的速度处理能力，取代了很多人为的工作，但是，往往很多时候，它又是那么弱不禁风，主板上的芯片、主板电路、内存、电源等任何一项不能正常工作，都]]></description><category></category></item><item><title><![CDATA[ora-01846:周中的日无效]]></title><link>https://blog.youkuaiyun.com/milia/article/details/2781856</link><guid>https://blog.youkuaiyun.com/milia/article/details/2781856</guid><author>milia</author><pubDate>Thu, 07 Aug 2008 13:19:00 +0800</pubDate><description><![CDATA[在一个中文环境的客户端中使用SELECT NEXT_DAY(sysdate,TUESDAY) "NEXT DAY"     FROM DUAL;会报 ora-01846:周中的日无效1.修改sql语句SELECT NEXT_DAY(sysdate,星期二) "NEXT DAY"     FROM DUAL; 2.如果不想修改sql语句运行的话,可以使用alter s]]></description><category></category></item><item><title><![CDATA[修改statspack 生成报告脚本]]></title><link>https://blog.youkuaiyun.com/milia/article/details/2776943</link><guid>https://blog.youkuaiyun.com/milia/article/details/2776943</guid><author>milia</author><pubDate>Wed, 06 Aug 2008 15:22:00 +0800</pubDate><description><![CDATA[statspack报告生成：statspack报告生成关系的 spreport.sql 调用sprepins.sql                                             sprepins.sql 调用sprepcon.sql修改sprepins.sql脚本： 需要修改两处1。promptpromptprompt Specify t]]></description><category></category></item><item><title><![CDATA[将字符串转换成表的形式]]></title><link>https://blog.youkuaiyun.com/milia/article/details/2768531</link><guid>https://blog.youkuaiyun.com/milia/article/details/2768531</guid><author>milia</author><pubDate>Tue, 05 Aug 2008 08:27:00 +0800</pubDate><description><![CDATA[     今天看了朋友的blog上转载了一篇将字符串转换成内存表的形式的文章，学习了一下，内容如下：      create or replace type type_varc is table of varchar2(1000); CREATE OR REPLACE FUNCTION f_str2tab(p_str IN VARCHAR2 --传入的字符串,格式为1,2,3,4,5)]]></description><category></category></item><item><title><![CDATA[Oracle数据库的介绍(部分)]]></title><link>https://blog.youkuaiyun.com/milia/article/details/2279511</link><guid>https://blog.youkuaiyun.com/milia/article/details/2279511</guid><author>milia</author><pubDate>Thu, 10 Apr 2008 20:15:00 +0800</pubDate><description><![CDATA[1 Oracle数据库的介绍这章内容提供了Oracle数据库服务器的概述。这个主题包括：l         Oracle 数据库体系机构l         Oracle 数据库特征l         Oracle 数据库应用开发Oracle 数据库体系机构Oracle数据库被视为一个单元，是数据的集合。数据的目的是为了存储和获得相关的信息。数据库服务器是解决信息管理问题的关]]></description><category></category></item></channel></rss>