<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Eric Ray的博客]]></title><description><![CDATA[每天进步一点点]]></description><link>https://blog.youkuaiyun.com/EricLeiy</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; EricLeiy]]></copyright><item><title><![CDATA[Oracle表空间使用及单表空间占用查询]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/122594611</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/122594611</guid><author>EricLeiy</author><pubDate>Thu, 20 Jan 2022 09:32:46 +0800</pubDate><description><![CDATA[oracle表空间大小使用情况及单表占用空间大小查询]]></description><category></category></item><item><title><![CDATA[Oracle创建表空间、用户详细介绍]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/122492167</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/122492167</guid><author>EricLeiy</author><pubDate>Fri, 14 Jan 2022 13:13:20 +0800</pubDate><description><![CDATA[Oracle创建表空间、用户详细介绍
文章目录Oracle创建表空间、用户详细介绍前言表空间及数据文件操作新增数据文件删除数据文件删除表空间，不删除数据文件删除表空间及数据文件创建临时表空间创建用户及授权创建用户用户授权用户信息查看
前言
突然要用，就整理一下表空间及用户相关操作步骤。
表空间及数据文件操作
/* 创建表空间 */
create tablespace TS_RDM  -- 表空间逻辑名
  datafile 'TS_RDM01.dbf'   -- 表空间物理文件名称
  '/u01/app/]]></description><category></category></item><item><title><![CDATA[Hadoop系列 (十)：Flume详细介绍]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/121338489</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/121338489</guid><author>EricLeiy</author><pubDate>Mon, 15 Nov 2021 17:09:28 +0800</pubDate><description><![CDATA[Flume详细介绍，工作机制，搭建及采集Hive日志等]]></description><category></category></item><item><title><![CDATA[Hadoop系列 (九)：Sqoop详细介绍]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/121037128</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/121037128</guid><author>EricLeiy</author><pubDate>Fri, 29 Oct 2021 16:23:50 +0800</pubDate><description><![CDATA[Sqoop详细介绍，部署及使用]]></description><category></category></item><item><title><![CDATA[Hadoop系列 (八)：Hbase搭建]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120888749</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120888749</guid><author>EricLeiy</author><pubDate>Thu, 21 Oct 2021 16:10:30 +0800</pubDate><description><![CDATA[Hbase搭建及shell简介]]></description><category></category></item><item><title><![CDATA[zookeeper启动报错Could not find or load main class org.apache.zookeeper.server.quorum.QuorumPeerMain]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120830056</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120830056</guid><author>EricLeiy</author><pubDate>Mon, 18 Oct 2021 17:04:41 +0800</pubDate><description><![CDATA[解决zookeeper启动时Error: Could not find or load main class org.apache.zookeeper.server.quorum.QuorumPeerMain]]></description><category></category></item><item><title><![CDATA[Hadoop系列 (七)：ZooKeeper详细介绍]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120829713</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120829713</guid><author>EricLeiy</author><pubDate>Mon, 18 Oct 2021 16:54:07 +0800</pubDate><description><![CDATA[ZooKeeper详细介绍及集群搭建]]></description><category></category></item><item><title><![CDATA[Hadoop系列 (六)：Spark搭建]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120762026</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120762026</guid><author>EricLeiy</author><pubDate>Thu, 14 Oct 2021 13:20:59 +0800</pubDate><description><![CDATA[基于hadoop的spark搭建]]></description><category></category></item><item><title><![CDATA[Hadoop系列 (五)：MapReduce详细介绍]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120655680</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120655680</guid><author>EricLeiy</author><pubDate>Fri, 08 Oct 2021 17:10:01 +0800</pubDate><description><![CDATA[MapReduce过程详细介绍]]></description><category></category></item><item><title><![CDATA[Hadoop系列 (四)：Yarn详细介绍]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120351770</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120351770</guid><author>EricLeiy</author><pubDate>Fri, 17 Sep 2021 16:29:00 +0800</pubDate><description><![CDATA[Yarn详细介绍及其高可用部署]]></description><category></category></item><item><title><![CDATA[Hadoop系列 (三)：HDFS详细介绍]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120287578</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120287578</guid><author>EricLeiy</author><pubDate>Tue, 14 Sep 2021 15:30:39 +0800</pubDate><description><![CDATA[HDFS三大组件、机制等详细介绍]]></description><category></category></item><item><title><![CDATA[Hive系列 (十)：Hive调优]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120202984</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120202984</guid><author>EricLeiy</author><pubDate>Thu, 09 Sep 2021 16:13:36 +0800</pubDate><description><![CDATA[Hive优化详细解释]]></description><category></category></item><item><title><![CDATA[Hive系列 (九)：Hive数据存储]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120138850</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120138850</guid><author>EricLeiy</author><pubDate>Mon, 06 Sep 2021 16:41:44 +0800</pubDate><description><![CDATA[Hive 数据存储格式TextFile  ORCFile Parquet 及其压缩方式详细介绍]]></description><category></category></item><item><title><![CDATA[Hive系列 (八)：Hive中的explode 与 lateral view]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120127196</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120127196</guid><author>EricLeiy</author><pubDate>Mon, 06 Sep 2021 09:38:05 +0800</pubDate><description><![CDATA[explode 与 lateral view详解]]></description><category></category></item><item><title><![CDATA[Oracle数据库恢复删除数据的方法]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120080197</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120080197</guid><author>EricLeiy</author><pubDate>Fri, 03 Sep 2021 13:52:49 +0800</pubDate><description><![CDATA[误删oracle数据库中的数据，在不考虑全库备份和利用归档日志情况，怎样快速恢复数据呢？
下面介绍3种方法。
1.  利用oracle提供的闪回方法进行数据恢复，适用于delete删除方式
首先获取删除数据的时间点：
select * from v$sql where sql_text like '%table_name%' ;

根据结果中的sql_text内容，找到delete执行语句对应的删除时间点，执行下面语句查询出删除的数据。
select * from table_name as of time]]></description><category></category></item><item><title><![CDATA[Hive系列 (七)：Hive常用函数]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/120039712</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/120039712</guid><author>EricLeiy</author><pubDate>Wed, 01 Sep 2021 14:48:04 +0800</pubDate><description><![CDATA[最全的hive函数详细介绍]]></description><category></category></item><item><title><![CDATA[Hive系列 (六)：Hive数据类型转换]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/119914626</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/119914626</guid><author>EricLeiy</author><pubDate>Wed, 25 Aug 2021 16:42:35 +0800</pubDate><description><![CDATA[hive数据类型转换规则及转换原则，日期类型转换]]></description><category></category></item><item><title><![CDATA[Hive系列 (五)：Hive数据类型]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/119890436</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/119890436</guid><author>EricLeiy</author><pubDate>Tue, 24 Aug 2021 15:10:29 +0800</pubDate><description><![CDATA[hive数据类型详解，简单数据类型及复杂数据类型array, map, struct, union 等]]></description><category></category></item><item><title><![CDATA[Hive系列 (四)：自定义函数UDF UDTF UDAF]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/119679654</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/119679654</guid><author>EricLeiy</author><pubDate>Fri, 13 Aug 2021 17:06:23 +0800</pubDate><description><![CDATA[使用idea创建hive自定义函数UDF UDTF UDAF ，详细介绍及语法代码案例]]></description><category></category></item><item><title><![CDATA[Hive系列 (三)：开窗函数详解]]></title><link>https://blog.youkuaiyun.com/EricLeiy/article/details/119382057</link><guid>https://blog.youkuaiyun.com/EricLeiy/article/details/119382057</guid><author>EricLeiy</author><pubDate>Wed, 04 Aug 2021 13:36:27 +0800</pubDate><description><![CDATA[开窗函数详细介绍，包括聚合开窗函数和排序开窗函数，sum,min,max,avg,first_value,last_value,lag,lead,cume_dist,row_number,rank,dense_rank,percent_rank,ntile等函数]]></description><category></category></item></channel></rss>