<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[orientlight的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/orientlight</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; orientlight]]></copyright><item><title><![CDATA[Informatica 效率]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/79177658</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/79177658</guid><author>orientlight</author><pubDate>Fri, 26 Jan 2018 23:32:08 +0800</pubDate><description><![CDATA[Oracle 12c on Exalystic.
Power Center 10.1.0
INSERT, 24791819 rows, 8219 rows/s , 90315820 bytes/s, total time 50 mins.]]></description><category></category></item><item><title><![CDATA[Oracle 清空表分区]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/79177551</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/79177551</guid><author>orientlight</author><pubDate>Fri, 26 Jan 2018 23:11:16 +0800</pubDate><description><![CDATA[ETL重刷201709数据，为了加快插入速度，不与已有数据比较，需要直接清空表指定分区的月份数据：

ALTER TABLE TF_FIN_CUX_DOC_SRE
	TRUNCATE PARTITION BALANCE_DT_201709;
接着需要重建索引，不然会报错ORA-01502：

ALTER INDEX BIDW.INX_FIN_CUX_DOC_SRE_U1 REBUILD;]]></description><category></category></item><item><title><![CDATA[Oracle 12c DML效率]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/79176952</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/79176952</guid><author>orientlight</author><pubDate>Fri, 26 Jan 2018 21:36:42 +0800</pubDate><description><![CDATA[Oracle 12c on Exalytics
delete 60086799 row, 1059.592s
6008万行，17.6分钟。]]></description><category></category></item><item><title><![CDATA[Oracle 判断表是否已完全刷新当天数据]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/78362885</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/78362885</guid><author>orientlight</author><pubDate>Fri, 27 Oct 2017 11:20:05 +0800</pubDate><description><![CDATA[需求：当天备份表刷新完数据后，拉取当天数据。
问题：备份表需要刷新完，才拉取数据
解决：
SELECT t.inv_date
  FROM rmsbak.cmx_item_loc_soh_bak t
 WHERE 1 = 1
   AND t.inv_date = trunc(SYSDATE)
   AND rownum = 1
   AND NOT EXISTS
 (SELECT obje]]></description><category></category></item><item><title><![CDATA[BI EE 安装补丁]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/78194149</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/78194149</guid><author>orientlight</author><pubDate>Tue, 10 Oct 2017 16:27:48 +0800</pubDate><description><![CDATA[上传补丁解压设置变量安装卸载


cd /home/oracle/Patchunzip -d PATCH_TOP p26029971_122120_Linux-x86-64.zip
export ORACLE_HOME=/u01/app/Middleware/Oracle_Home

cd PATCH_TOP/26029971opatch apply
opatch rollback]]></description><category></category></item><item><title><![CDATA[OBIEE-外部表登录无法使用代理的解决方法]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/52494151</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/52494151</guid><author>orientlight</author><pubDate>Sat, 10 Sep 2016 12:10:39 +0800</pubDate><description><![CDATA[SELECT T.USERNAME,T.PASSWORD,T.SUBJECTS FROM FOR_AMD_USER_ALL T
WHERE USERNAME = ':USER' NQS_PASSWORD_CLAUSE(AND PASSWORD = ':PASSWORD' )NQS_PASSWORD_CLAUSE]]></description><category></category></item><item><title><![CDATA[OBIEE会话变量]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/52438268</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/52438268</guid><author>orientlight</author><pubDate>Mon, 05 Sep 2016 10:45:25 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[OBIEE提示-不同维度关联]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51940085</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51940085</guid><author>orientlight</author><pubDate>Mon, 18 Jul 2016 10:51:31 +0800</pubDate><description><![CDATA[管理会话中有“类型=ValuePrompt”的记录，查看日志，可以看到提示中列的值是如何限制的。 
如果两个不同维度设置了 限制值依据，那么biserver会寻找最优的事实表将两个维度关联获取有关联的值作为依据。 
如果要指定事实表，需要在RPD中对该主题进行“隐式事实列”设置。]]></description><category></category></item><item><title><![CDATA[OBIEE权限管理-WLST脚本]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51834617</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51834617</guid><author>orientlight</author><pubDate>Tue, 05 Jul 2016 21:04:14 +0800</pubDate><description><![CDATA[使用Weblogic Script Tool进行批量操作，创建用户，移除用户，添加到组]]></description><category></category></item><item><title><![CDATA[OBIEE分析开发-使用Echarts展现地图2]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51765173</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51765173</guid><author>orientlight</author><pubDate>Sun, 26 Jun 2016 23:14:06 +0800</pubDate><description><![CDATA[1.结果 
 
2.内容<!-- 前缀 -->
<head>
    <meta charset="utf-8">
</head><body style="height: 100%; margin: 0">
    <div id="container" style="height: 100%"></div>
    <script type="text/javascript" src="/anal]]></description><category></category></item><item><title><![CDATA[OBIEE分析开发-使用Echarts展现地图1]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51764211</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51764211</guid><author>orientlight</author><pubDate>Sun, 26 Jun 2016 20:20:47 +0800</pubDate><description><![CDATA[OBIEE使用Echarts展现地图]]></description><category></category></item><item><title><![CDATA[Oracle数据库-数据文件重置大小]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51629210</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51629210</guid><author>orientlight</author><pubDate>Fri, 10 Jun 2016 23:22:58 +0800</pubDate><description><![CDATA[造数时发现数据太多了，需要删掉，结果发现数据文件还是很占系统空间，下面是尝试减小数据文件大小的过程。


truncate table T_test;
--释放表空间
alter table T_test enable row movement;
alter table T_test shrink space;
--查看使用的块数目
select blocks from dba_segmen]]></description><category></category></item><item><title><![CDATA[OBIEE RPD开发-数据库功能]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51628458</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51628458</guid><author>orientlight</author><pubDate>Fri, 10 Jun 2016 20:02:38 +0800</pubDate><description><![CDATA[[ DATA_SOURCE_FEATURE  ORACLE_11g ]
 



特性

值



MAX_TABLES_IN_SELECT

1024



MAX_COLUMNS_IN_GROUP_BY

1024



MAX_COLUMNS_IN_ORDER_BY

1024



MAX_COLUMNS_IN_INDEX

3]]></description><category></category></item><item><title><![CDATA[OBIEE RPD开发]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51611285</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51611285</guid><author>orientlight</author><pubDate>Wed, 08 Jun 2016 10:34:37 +0800</pubDate><description><![CDATA[A parent-child hierarchy is a hierarchy of members that all have the same type. This contrasts with level-based hierarchies, where members of the same type occur only at a single level of the hierarch]]></description><category></category></item><item><title><![CDATA[甲骨文销售云-报表开发·神鬼抓bug]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51221081</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51221081</guid><author>orientlight</author><pubDate>Fri, 22 Apr 2016 16:12:22 +0800</pubDate><description><![CDATA[甲骨文销售云报表开发中出现的奇葩错误]]></description><category></category></item><item><title><![CDATA[Oracle BI Server DNS 配置错误集]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51160507</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51160507</guid><author>orientlight</author><pubDate>Fri, 15 Apr 2016 11:49:23 +0800</pubDate><description><![CDATA[本文为使用Oracle BI Server DNS配置时的错误提示集合]]></description><category></category></item><item><title><![CDATA[OBIEE 12c SAMPLE VM]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/51086235</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/51086235</guid><author>orientlight</author><pubDate>Sat, 09 Apr 2016 20:41:05 +0800</pubDate><description><![CDATA[OBIEE 12c SAMPLE

/app/oracle/biee/user_projects/domains/bi2/nodemanager/nodemanager.log
/app/oracle/biee/user_projects/domains/bi2/servers/AdminServer/logs]]></description><category></category></item><item><title><![CDATA[OBIEE分析开发-前端函数备忘]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/50955068</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/50955068</guid><author>orientlight</author><pubDate>Tue, 22 Mar 2016 14:45:15 +0800</pubDate><description><![CDATA[--将数字转换为日期
CAST(INSERT(INSERT(CAST(20160301 AS CHAR), 7, 0, '/'), 5, 0, '/') AS DATE)]]></description><category></category></item><item><title><![CDATA[ORACLE Database 时区相关]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/50622519</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/50622519</guid><author>orientlight</author><pubDate>Tue, 02 Feb 2016 10:35:41 +0800</pubDate><description><![CDATA[SELECT CURRENT_DATE+numtodsinterval(8,'hour') nowtime ,
                    to_date(CURRENT_DATE+numtodsinterval(8,'hour') ,'YYYY-MM-DD') nowdate ,
                    TZ_OFFSET('US/Eastern') oss
FROM]]></description><category></category></item><item><title><![CDATA[OBIEE分析开发-获取当月第一天]]></title><link>https://blog.youkuaiyun.com/orientlight/article/details/49797079</link><guid>https://blog.youkuaiyun.com/orientlight/article/details/49797079</guid><author>orientlight</author><pubDate>Thu, 12 Nov 2015 12:02:52 +0800</pubDate><description><![CDATA[CAST(
	Concat(	
		Concat(
			Concat(
				CAST(YEAR(CURRENT_DATE) AS CHAR(4))
			, '-')
		, CAST(MONTH(CURRENT_DATE) AS CHAR(2)))
	, '-01') 
AS DATE)]]></description><category></category></item></channel></rss>