<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[HUONG的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/HUONG</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; HUONG]]></copyright><item><title><![CDATA[游标]]></title><link>https://blog.youkuaiyun.com/HUONG/article/details/8879248</link><guid>https://blog.youkuaiyun.com/HUONG/article/details/8879248</guid><author>HUONG</author><pubDate>Fri, 03 May 2013 11:04:11 +0800</pubDate><description><![CDATA[http://xsb.itpub.net/post/419/38490]]></description><category></category></item><item><title><![CDATA[写文件]]></title><link>https://blog.youkuaiyun.com/HUONG/article/details/8875088</link><guid>https://blog.youkuaiyun.com/HUONG/article/details/8875088</guid><author>HUONG</author><pubDate>Thu, 02 May 2013 11:15:05 +0800</pubDate><description><![CDATA[create or replace directory dir_test as 'D:\';

drop table t;
create table t(a varchar2(10),b varchar2(10));
insert into t values('a','b');
insert into t values('aa','bb');
insert into t values(]]></description><category></category></item><item><title><![CDATA[查找文件位置]]></title><link>https://blog.youkuaiyun.com/HUONG/article/details/8834008</link><guid>https://blog.youkuaiyun.com/HUONG/article/details/8834008</guid><author>HUONG</author><pubDate>Mon, 22 Apr 2013 13:16:30 +0800</pubDate><description><![CDATA[select rtrim(c.value,'/')||'/'||d.instance_name||'_ora_'||ltrim(to_char(a.spid))||'.trc' from v$process a,
v$session b,v$parameter c,v$instance d where a.addr=b.paddr
and b.audsid=sys_contect('usere]]></description><category></category></item><item><title><![CDATA[定时添加或删除分区表分区的方法]]></title><link>https://blog.youkuaiyun.com/HUONG/article/details/8833147</link><guid>https://blog.youkuaiyun.com/HUONG/article/details/8833147</guid><author>HUONG</author><pubDate>Mon, 22 Apr 2013 09:36:01 +0800</pubDate><description><![CDATA[平台如下：
os：centos4.7
oracle 10g
定时添加或删除分区表的分区
这几天，根据业务的需求和性能的考虑，需要定时删除历史数据，表里
只保留最近指定的wareid的数据，考虑删除时对表的影响及便利性，我决定
把这个表建立成分区表，定期添加和删除分区
步骤：

1. 创建相关procedure
    pro_ADD_PARTITION_wareid    --]]></description><category></category></item><item><title><![CDATA[导入导出]]></title><link>https://blog.youkuaiyun.com/HUONG/article/details/8833110</link><guid>https://blog.youkuaiyun.com/HUONG/article/details/8833110</guid><author>HUONG</author><pubDate>Mon, 22 Apr 2013 09:26:55 +0800</pubDate><description><![CDATA[sqlplus"/as sysdba"
create tablespace 表间名 datafile '数据文件名' size 表空间大小;
    如：
    SQL> create tablespace news_tablespace datafile 'F:\oracle\product\10.1.0\oradata\news\news_data.dbf' size 500M;]]></description><category></category></item></channel></rss>