<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cldnu44288的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cldnu44288</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cldnu44288]]></copyright><item><title><![CDATA[关闭闪回即disable flashback的操作步骤]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296985</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296985</guid><author>cldnu44288</author><pubDate>Fri, 11 May 2012 16:29:41 +0800</pubDate><description><![CDATA[1.现有的环境：SQL&gt; select flashback_on from v$database;
FLASHBACK_ON------------------YESSQL&gt; show parameter reco...]]></description><category></category></item><item><title><![CDATA[用gc创建standby时出现错误Remote Operation Error-Internal error occured的解决]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100297003</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100297003</guid><author>cldnu44288</author><pubDate>Wed, 25 Apr 2012 11:32:29 +0800</pubDate><description><![CDATA[用gc创建standby时出现错误Remote Operation Error-Internal error occured的解决
原来是在prod库上的gc代理没有启动，在ksdb上cd $ORACLE_HOMEcd ...]]></description><category></category></item><item><title><![CDATA[oracle设置字符集支持维吾尔语的心得]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296977</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296977</guid><author>cldnu44288</author><pubDate>Wed, 25 Apr 2012 11:28:48 +0800</pubDate><description><![CDATA[1.数字库字符集选择utf8(非al32utf8)2.在客户端也设置字符集：AMERICAN_AMERICA.UTF8 (这是在注册表中设置的) 3.toad不可以使用，只能够用PL/SQL DEVELOPER工具...]]></description><category></category></item><item><title><![CDATA[设置linux重启后oracle自动启动的步骤]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296975</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296975</guid><author>cldnu44288</author><pubDate>Wed, 25 Apr 2012 11:22:24 +0800</pubDate><description><![CDATA[我的过程如下：
1.用root在/etc/rc.d/rc.local(是个文件)中添加下面黄色的内容[root@ksdb rc.d]# more rc.local;#!/bin/sh## This script. will b...]]></description><category></category></item><item><title><![CDATA[RAC下捕捉锁会话语句]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296983</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296983</guid><author>cldnu44288</author><pubDate>Tue, 24 Apr 2012 09:30:29 +0800</pubDate><description><![CDATA[一.这是大家常用的。查询等待会话的脚本
rac下查锁==================================col sess for a25SELECT DECODE(request, 0, 'Holder:...]]></description><category></category></item><item><title><![CDATA[使用trigger实现两个表的数据同步]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296984</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296984</guid><author>cldnu44288</author><pubDate>Fri, 20 Apr 2012 12:17:54 +0800</pubDate><description><![CDATA[用户：hrcreate table t1(n1 number,b1 varchar2(32 byte));create table t2(n2 number,b2 varchar2(32 byte));
目标：在表t1中插入数...]]></description><category></category></item><item><title><![CDATA[10.2.0.1.0版本的gc安装失败后，需要做的步骤]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296980</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296980</guid><author>cldnu44288</author><pubDate>Fri, 20 Apr 2012 11:41:14 +0800</pubDate><description><![CDATA[以前的步骤不太完整和正确，现在把我的实验共享出来。
GC重装的步骤：
一.在资料库删除下面信息
1drop user sysman
2.drop user mgmt_view
3. select 'drop publi...]]></description><category></category></item><item><title><![CDATA[一条sql语句]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100297055</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100297055</guid><author>cldnu44288</author><pubDate>Fri, 20 Apr 2012 11:20:54 +0800</pubDate><description><![CDATA[网友问我的：请教；我有这样一组数据a 1 2 3 a 4 5 6b 1 2 3b 4 5 6写一条SQL查出a组第三列最大的b组第三列最大的 
我的实验如下：
SQL&gt; create table tab1222(a v...]]></description><category></category></item><item><title><![CDATA[关于外键的理解和实验步骤]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296981</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296981</guid><author>cldnu44288</author><pubDate>Thu, 19 Apr 2012 11:22:19 +0800</pubDate><description><![CDATA[我的实验过程1.创建两个表create table zb(n number not null primary key,b varchar2(10),c date default sysdate);create table wb(...]]></description><category></category></item><item><title><![CDATA[gc安装失败后的重装]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296974</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296974</guid><author>cldnu44288</author><pubDate>Thu, 03 Nov 2011 09:38:47 +0800</pubDate><description><![CDATA[运行runInstaller(安装时的运行文件）然后点击已安装的软件中选择oms10g及omsagentdeinstaller这些。用root rm -rf inInventory的目录rm -rf oms10g目录rm -rf...]]></description><category></category></item><item><title><![CDATA[oracle的system 所有对象drop后的恢复]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100297051</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100297051</guid><author>cldnu44288</author><pubDate>Tue, 01 Nov 2011 15:04:21 +0800</pubDate><description><![CDATA[环境：oracle 10.2.0.5.0
数据库非归档
未有rman及逻辑备份
system所有的对象丢失
但数据库可以正常运行，shutdown后也能正常打开
偿试：
sql&gt;@?/rdbms/admin/...]]></description><category></category></item><item><title><![CDATA[用数据泵expdp导出用户的ddl的方法]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296978</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296978</guid><author>cldnu44288</author><pubDate>Fri, 14 Oct 2011 16:31:04 +0800</pubDate><description><![CDATA[按用户导出
就是加个参数：content=metadata_only即可
如：
expdp system/密码 directory=back_dir dumpfile=onlyddl.dmp schemas=scott...]]></description><category></category></item><item><title><![CDATA[安装grid control 10.2.0.1.0及补丁的心得]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296973</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296973</guid><author>cldnu44288</author><pubDate>Mon, 22 Aug 2011 12:29:37 +0800</pubDate><description><![CDATA[我的环境：
操作系统:linux redhat 4.7
oracle资料库：10.2.0.1.0
安装grid control 10.2.0.1.0的时候总是报oms配置不成功
需要打补丁：8430622 
补...]]></description><category></category></item><item><title><![CDATA[关于表的链化分析处理]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100297040</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100297040</guid><author>cldnu44288</author><pubDate>Fri, 19 Aug 2011 13:40:44 +0800</pubDate><description><![CDATA[分析哪个表就用哪个用户做：下面的操作.就用该用户:1.先创建个表: chained_rows表
SQL&gt; @?/rdbms/admin/utlchain
Table created.
脚本的定义：$ ll utlch...]]></description><category></category></item><item><title><![CDATA[数据泵导入时出错：ORA-01502]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100297015</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100297015</guid><author>cldnu44288</author><pubDate>Fri, 19 Aug 2011 13:29:23 +0800</pubDate><description><![CDATA[impdp system/password DIRECTORY= DUMPFILE=.dmp schemas= PARALLEL=8
Import: Release 10.2.0.1.0 - 64bit Production...]]></description><category></category></item><item><title><![CDATA[ORA-39213: Metadata processing is not available]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100297009</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100297009</guid><author>cldnu44288</author><pubDate>Fri, 19 Aug 2011 13:25:06 +0800</pubDate><description><![CDATA[[oracle@LYDB scripts]$ ./expdp.sh
Export: Release 10.2.0.1.0 - 64bit Production on Monday, 28 June, 2010 10:54:37...]]></description><category></category></item><item><title><![CDATA[ORA-12545]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100297043</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100297043</guid><author>cldnu44288</author><pubDate>Fri, 19 Aug 2011 13:15:16 +0800</pubDate><description><![CDATA[问题：通过客户端连接rac中的实例时，有时候连接一个节点会出错，出现ORA-12545解决方法：1.给客户端的hosts中增加vip ip地址2.在服务器端改tnsnames.ora中的hostname把vip改成ip地址，而不...]]></description><category></category></item><item><title><![CDATA[ORA-38029: object statistics are locked]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100297012</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100297012</guid><author>cldnu44288</author><pubDate>Fri, 19 Aug 2011 13:06:03 +0800</pubDate><description><![CDATA[sys@ORA102&gt;analyze table test.jobs compute statistics;analyze table test.jobs compute statistics*ERROR at line ...]]></description><category></category></item><item><title><![CDATA[ORA-04043: 对象 xxx不存在]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296971</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296971</guid><author>cldnu44288</author><pubDate>Fri, 19 Aug 2011 12:51:19 +0800</pubDate><description><![CDATA[SQL&gt; desc dba_objects;ERROR:ORA-04043: object dba_objects does not exist
SQL&gt; select status from v$instance...]]></description><category></category></item><item><title><![CDATA[为什么不使用long类型]]></title><link>https://blog.youkuaiyun.com/cldnu44288/article/details/100296967</link><guid>https://blog.youkuaiyun.com/cldnu44288/article/details/100296967</guid><author>cldnu44288</author><pubDate>Thu, 18 Aug 2011 09:57:21 +0800</pubDate><description><![CDATA[long类型包括：longlong raw
根据官文：1.lob容量比较大,lobs类型能存储4G或者根据你系统的配置更多的数据量，而long及long raw类型限制于2GB2.在一个表里lob列的数量：一个表可以有多个lo...]]></description><category></category></item></channel></rss>