搜尋此網誌
2010年10月19日 星期二
2010年10月18日 星期一
High and lows
Usage: how is your high and lows this weekend ?
explain : highs and lows means did you have any good things and bad things.
From : weekly staff meeting , in the meeting have many trend charts . each index have high and low
explain : highs and lows means did you have any good things and bad things.
From : weekly staff meeting , in the meeting have many trend charts . each index have high and low
ENGLISH-NEWS
How the Phoenix Rescue Capsule Works
這是之前智利礦坑的事件 !!
要來說說 那個字 Capsule
膠囊(MEDICINE)
但由於型狀相似 也被用於太空艙
以上是名詞
在形容詞 則是 濃縮,概要
也可以當 Vt. 來用跟 ADJ 同義 ..
Reference:
http://www.foxnews.com/scitech/2010/10/12/phoenix-rescue-capsule-save-chilean-miners/
2010年10月14日 星期四
CREATE MV
-如有建SYNONYM 要先行DROP 掉
--drop SYNONYM FPDB5001 ;
--drop SYNONYM FPDB5003 ;
--drop SYNONYM FPDB5007 ;
--drop SYNONYM FPDB5008 ;
--drop SYNONYM FPDB5013 ;
--drop SYNONYM FPDB5015 ;
--drop SYNONYM FPDB5016 ;
--drop SYNONYM KADB1017 ;
Grant Create MATERIALIZED VIEW to XXX<==先給權限給使用者
這樣USER才能 建MV
--建MV START WITH TO_DATE 是指定何時開始作的時間,將裡面的時間先行改掉
CREATE MATERIALIZED VIEW FPDB5001 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5001@LINKACER;
CREATE MATERIALIZED VIEW FPDB5003 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5003@LINKACER;
CREATE MATERIALIZED VIEW FPDB5007 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5007@LINKACER;
CREATE MATERIALIZED VIEW FPDB5008 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5008@LINKACER;
CREATE MATERIALIZED VIEW FPDB5013 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5013@LINKACER;
CREATE MATERIALIZED VIEW FPDB5015 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5015@LINKACER;
CREATE MATERIALIZED VIEW FPDB5016 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5016@LINKACER;
CREATE MATERIALIZED VIEW KADB1017 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from KADB1017@LINKACER;
CREATE MATERIALIZED VIEW KADB1023 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from KADB1023@LINKACER;
COMMIT
select * from user_mview_refresh_times;
--測試中 先DROP 掉 ,重建算時間
--drop MATERIALIZED view FPDB5001;
--drop MATERIALIZED view FPDB5003;
--drop MATERIALIZED view FPDB5007;
--drop MATERIALIZED view FPDB5008;
--drop MATERIALIZED view FPDB5013;
--drop MATERIALIZED view FPDB5016;
--drop MATERIALIZED view FPDB5015;
--drop MATERIALIZED view KADB1017;
--drop MATERIALIZED view KADB1023;
---改使用SESSION 時間顯示方式
alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';
select * from user_mview_refresh_times;
--drop SYNONYM FPDB5001 ;
--drop SYNONYM FPDB5003 ;
--drop SYNONYM FPDB5007 ;
--drop SYNONYM FPDB5008 ;
--drop SYNONYM FPDB5013 ;
--drop SYNONYM FPDB5015 ;
--drop SYNONYM FPDB5016 ;
--drop SYNONYM KADB1017 ;
Grant Create MATERIALIZED VIEW to XXX<==先給權限給使用者
這樣USER才能 建MV
--建MV START WITH TO_DATE 是指定何時開始作的時間,將裡面的時間先行改掉
CREATE MATERIALIZED VIEW FPDB5001 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5001@LINKACER;
CREATE MATERIALIZED VIEW FPDB5003 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5003@LINKACER;
CREATE MATERIALIZED VIEW FPDB5007 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5007@LINKACER;
CREATE MATERIALIZED VIEW FPDB5008 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5008@LINKACER;
CREATE MATERIALIZED VIEW FPDB5013 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5013@LINKACER;
CREATE MATERIALIZED VIEW FPDB5015 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5015@LINKACER;
CREATE MATERIALIZED VIEW FPDB5016 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from FPDB5016@LINKACER;
CREATE MATERIALIZED VIEW KADB1017 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from KADB1017@LINKACER;
CREATE MATERIALIZED VIEW KADB1023 TABLESPACE "IDB_III_IPMIS" REFRESH complete START WITH to_date('02-06-2011 23:50:00','MM-dd-yyyy hh24:mi:ss') NEXT sysdate + 1 AS select * from KADB1023@LINKACER;
COMMIT
select * from user_mview_refresh_times;
--測試中 先DROP 掉 ,重建算時間
--drop MATERIALIZED view FPDB5001;
--drop MATERIALIZED view FPDB5003;
--drop MATERIALIZED view FPDB5007;
--drop MATERIALIZED view FPDB5008;
--drop MATERIALIZED view FPDB5013;
--drop MATERIALIZED view FPDB5016;
--drop MATERIALIZED view FPDB5015;
--drop MATERIALIZED view KADB1017;
--drop MATERIALIZED view KADB1023;
---改使用SESSION 時間顯示方式
alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';
select * from user_mview_refresh_times;
2010年10月11日 星期一
I saw a pictuer on my friend's fb
A true farm village on pic
turmeric ~ it is a good food chinese name is薑黃
turmeric ~ it is a good food chinese name is薑黃
訂閱:
文章 (Atom)