Friday, November 6, 2009

東京

Information
http://kunghc.pixnet.net/blog/post/3494399
http://www.backpackers.com.tw/forum/showthread.php?t=50795
http://www.backpackers.com.tw/guide/index.php/%E6%9D%B1%E4%BA%AC
不可不知的東京優惠交通票卷整理及重要地鐵站攻略
  • http://blog.pixnet.net/kunghc/post/16956565
http://kunghc.pixnet.net/blog/post/25255841
http://transit.map.yahoo.co.jp/
http://www.jorudan.co.jp/index_06.html
山手線沿線大站站內外地圖
  • http://www.jreast.co.jp/yamanotemap/index.html

Google Map
http://maps.google.co.jp/maps/ms?msa=0&msid=108998884525174885948.00043b84c987c09c91495&hl=ja&ie=UTF8&z=11&om=1

Food
  • http://www.discuss.com.hk/viewthread.php?tid=11040517&extra=page%3D1
Hotel
shinjuku washington hotel
  • http://www.shinjyuku-wh.com/english/
休足時間
  • http://www.backpackers.com.tw/forum/showthread.php?t=245644
Souvenior
  • Tokyo Banana http://yukiblog.tw/read-292.html

Blog
http://hk.myblog.yahoo.com/jw!UXUvqR6QHxlZ6S9tPfQ9/article?mid=16528
http://hk.myblog.yahoo.com/asapchic/searchblog_art?p=%E6%9D%B1%E4%BA%AC%E4%B9%8B%E6%97%85&my=1
http://hk.myblog.yahoo.com/jw!otOosiuVAhKT8l1gW44_bXMT/article?mid=7552
http://hk.myblog.yahoo.com/fala-flora/index?l=f&id=12
http://hk.myblog.yahoo.com/hkc_s7/article?mid=3637 - Film Photo
http://hk.myblog.yahoo.com/garyso7c/index?l=f&id=9
http://hk.myblog.yahoo.com/plan2-japan/index?l=f&id=9
http://hk.myblog.yahoo.com/chairjessica/index?l=f&id=4
1&page=4
http://www.discuss.com.hk/viewthread.php?tid=10914300&extra=page%3D1
http://www.discuss.com.hk
/viewthread.php?tid=10660099&extra=page%3D2
http://hk.myblog.yahoo.com/jessomlam/article?mid=220
http://www.discuss.com.hk/viewthread.php?tid=6423224&extra=page%3D7
http://www.wretch.cc/blog/JoyceLee41/13690079
http://www.wretch.cc/blog/JoyceLee41&category_id
=11151264
http://www.backpackers.com.tw/forum/showthread.php?t=10792
http://ringo0601.wordpress.com/2009/08/22/day-1-in-tokyo/
http://chifengh.blogspot.com/2009/11/rainy-tokyo.html
http://hk.myblog.yahoo.com/keroroxtamama/index?l=f&id=10&page=4
http://laurencel0.blogspot.com/2009/09/blog-post_29.html

DAY 1 (SAT):成田機場→新宿
DAY 2(SUN):新宿→明治神宮→原宿→竹下通→表參道→澀谷→秋葉原
DAY 3 (MON):新宿->淺草(雷門,仲見世,觀音寺)->上野/阿美橫→東京站→六本木之丘cityview→TokyoMidtown→赤羽橋
DAY 4 (TUE):新宿->築地市場->汐留->台場
DAY 5 (WED):新宿->中野->池袋→成田機場

http://kunghc.pixnet.net/b
log/post/19647462
DAY 1 (SAT):(NW 296 8:00-13:05) 成田機場新宿

成田機場
http://www.narita-airport.jp/ch2/index.html

Suica & N'EX(中文) ( ¥3500), one way (¥3110)
  • JREast Travel Ticket Center
  • http://www.jreast.co.jp/tc/suica-nex/index.html
  • http://www.jreast.co.jp/e/suica-nex/s-n_users_guide.pdf

成田機場如何到新宿/都廳(10/4更新)

  • http://kunghc.pixnet.net/blog/post/3906252
  • http://kunghc.pixnet.net/blog/post/3136016
  • 1500yen1小時27分 到達新宿(和以下的方法時間差不多 但舒服很多)
  • 用此套票Narita Express 到新宿, 就和以下的1200yen相差無幾, "東京電車區間"都不用再附費歐!像你東京下車轉山手線, 新橋出站, 就拿"指定特急席車票"給站務員看即可, 別呆呆的插Suica出站歐!


按此看往新宿的Narita Express時刻表(不是每班都有到)
  • http://www.jreast.co.jp/nex/timetable/from_narita/
  • 14:42, 15:40
shinjuku washington hotel (16:15)


新宿(Shinjuku)

大黑屋Buy Ticket去票店晃晃 決定之後的行程

  • http://kunghc.pixnet.net/blog/post/3942187
  • 4.不是學生的話 也可去新宿西口或是新橋烏森口等票店(如大黑屋)買優待票 我買過980yen的
    票店地圖見 http://blog.pixnet.net/kunghc/post/3942187

  • 可去新宿西口或是新橋烏森口等票店(如大黑屋)買優待票 我買過50yen的(你沒看錯!)

    票店地圖見 http://blog.pixnet.net/kunghc/post/3942187

  • http://kunghc.pixnet.net/blog/post/24980894
  • 新宿西口店 営業時間: 9:30~19:00:月火水木金 9:30~18:00:土日祝
    所在地: 東京都新宿区西新宿1-2-12
  • Books Card
  • tokyo city view (¥1500)
  • 球型展望室--在一樓買入場券(500YEN)
  • 明治神宮 (500yen)
歌舞伎町
  • http://www.kabukicho.or.jp/
花園神社
  • www.hanazono-jinja.or.jp/mt/top

東京都本庁
  • Go to South First (9:30-17:30), then North(9:30-23:00)
  • http://www.yokoso.metro.tokyo.jp/
  • http://kunghc.pixnet.net/blog/post/4455701
  • http://kunghc.pixnet.net/blog/post/4358578
  • http://www.flickr.com/photos/shinlun/4042202132/

Shopping
Camera Store
  • 西口Halc館http://www.biccamera.com/ (10-9pm)
Yodobashi www.yodobashi.com (電器賣場)
交通:從新宿站西口出,步行約2分鐘。 營業時間:9:30am-10:00pm
東 口有Sakuraya,西口有Yodobashi Camera。綜合館以相機為主,另有AV通訊館、時計館、Game Music館等,家電、電腦、影音產品、書籍、玩具都有。「Gold Point Card」回饋計劃:買任何產品可儲積分,可購買會員優惠價產品或是下次購物時作現金使用,通常有8-18%回贈;只要走到counter即時申請便可。 三整座大廈十幾層要逛完,起碼兩個小時。
(多媒體館):分北館、南館和東館。購買數位相機和配件,可到南館地下;而手提電腦和影音產品則在東館,至於PDA、電子詞典和電腦軟體則到北館。
(電玩館):在北館後面,售買家庭遊戲及遊戲攻略。共有6層,售賣各款人氣新game

Sakuraya
  • http://www.sakuraya.co.jp/
  • Hobby 館
Tokyu Hands
  • http://shinjuku.tokyu-hands.co.jp/
  • http://translate.google.com.hk/translate?js=y&prev=_t&hl=zh-TW&ie=UTF-8&u=http%3A%2F%2Fshinjuku.tokyu-hands.co.jp%2F&sl=ja&tl=zh-TW
紀伊國屋(在伊勢丹百貨隔壁) 日本大型書店
Eating
船橋屋
  • http://r.gnavi.co.jp/g141907/menu1.htm
新宿 JR 駅吉列豬扒店

朱古力牛角包
  • 新宿西口的 Saint-Marc Choc-Cro (朱古力牛角包)

DAY 2(SUN)新宿→明治神宮 (10:00)→原宿→竹下通(12:00)→表參道(13:30)→澀谷(14:30)→秋葉原 (16:30)


原宿 (Harajuku) - Shopping

検索条件: 新宿~明治神宮前  2009/11/24 15:20発

乗車時間:4分
総額:130円
距離:2.2km
(所要時間:4分)

■ 新宿
|  JR 山手線渋谷方面行 2.2km
|  15:20~15:24 [4分] 2009/11/24
|  130円
■ 原宿

2008年12月版
空路有効期間2009年11月01日~2010年01月04日

代代木公園(明治神宮)
  • http://www.meijijingu.or.jp/ 每月第三周的星期五休息,門票500yeh
  • 1. 右手拿著放置在手水舍的水杓, 舀一瓢水, 由掌心向指頭淋下, 將左手洗淨

    2. 反之, 左手拿著水杓, 舀一瓢水, 由掌心向指頭淋下, 將右手洗淨

    3. 右手舀一瓢水, 放在左手掌心上, 將水送至口中漱漱口後吐掉, 請注意不要將水杓直接與口接觸

    4. 兩手將水杓垂直, 像數字"9"及拿香的方式, 將水杓的柄清洗乾淨
  • http://www.flickr.com/photos/dannie_tj/4124649620/
  • http://www.flickr.com/photos/doubt72/4120933467/
  • http://www.flickr.com/photos/thomasritz/4117999596/in/set-72157622806561988/

竹下通(http://www.wretch.cc/blog/bkno21427/5743829)
  • http://www.flickr.com/photos/31840837@N06/4121260313/
Condomania
  • http://condomania.jp/
390 YEN

表參道 (Omotesando Hills) (http://www.omotesandohills.com/index.php)

  • http://www.wretch.cc/blog/bkno21427/5841172)
  • http://www.wretch.cc/blog/ivana/12255337
  • 專賣玩具的 KiddyLand 不可放過
  • http://blog.yam.com/yoyonomap/article/5807164
  • Pierre Herme 南青山總店 http://www.wretch.cc/blog/vivianchiu/5781662
Eating
Snack
可麗餅 (Angel's Heart)
竹下通的可麗餅
相隔不遠距離就有三家,其中二家相對的都有人在排隊,選擇了MARION CREPES有著藍底白字招牌的。點了水蜜桃鮮奶油冰淇淋,還有鮮奶油巧克力。冷冷的下雨天冰淇淋別有風味,加了很多甜甜的鮮奶油,不過我覺得還是香蕉搭配鮮奶油比較合自己的口味。
ピーチ生クリームアイスクリーム,水蜜桃鮮奶油冰淇淋,¥350。
チョコ生クリーム,鮮奶油巧克力,¥300。
http://www.flickr.com/photos/25097664@N05/3979123881/

Lunch
蘋果樹蛋包飯
明治神宮往表餐道方向,從天橋起走左手邊的人行道約2-3分鐘,有一家位於地下室的蛋包飯專營店,各式各樣的蛋包飯絕對另你大開眼界,一個蛋包飯價位約700-800日幣
  • http://www.wretch.cc/blog/cocolia/14434628
  • http://ninkolin.pixnet.net/blog/post/6283181
  • http://blog.yam.com/venuslin0113/article/12488471

Maisen
  • Deep Fried Pork

涉谷 (Shibuya)
忠犬八公 及牆上八公的全家福合照一下

■ 忠狗八公 一提到澀谷,大家一定立刻聯想到車站的忠狗八公(Hachi公)的雕像,站在此地,澀谷區的各個性大道由此往四面放射出去,熙來攘往的人潮是極壯觀的場面。
  • http://www.flickr.com/photos/chrisbalboa/3149371325/

■ 東橫のれん街(位於東急東橫線 南口) http://www.tokyu-dept.co.jp/norengai/
也是很棒的逛街地點....伴手禮超多的地方 也可看到賣 東京banana

■ Shibuya觀光案內所
注意事項:「Shibuya觀光案內所」也在此巷弄內,提供澀谷地區的餐廳、咖啡館、生活雜貨店、流行商店及夜間去處的詢問情報,完全免費,如果還不能獲得滿足,花點小錢還有導遊出租,帶著你玩;想翻遍澀谷地區有趣的吃喝玩樂,建議你先來此拜訪一下。

109-2
  • http://www.109-2.jp/
激安の殿堂
  • www.donki.com
Book 1st
  • www.book1st.net
爆彈燒
  • 地點:竹下通尾段左邊入HARAJUKU AVENUE即可
  • 涉谷區神宮前1-8-6

CameraCabaretGrandShop

  • http://www.powershovel.co.jp/cabaret/

検索条件: 渋谷~秋葉原  2009/11/24 15:32発

乗車時間:27分
総額:190円
距離:16.0km
(所要時間:27分)

■ 渋谷
|  JR 山手線品川方面行 16.0km
|  15:35~16:02 [27分] 2009/11/24
|  190円
■ 秋葉原

2008年12月版

空路有効期間2009年11月01日~2010年01月04日

秋葉原 (http://e-akihabara.jp/ja/map.htm)
  • http://www.youyoutokyo.jp/shopping/se1010.html
如果到東京只能去一間電子大賣場 就去 秋葉原的ヨドバシカメラ/yodobashi camera
ヨドバシカメラ是我比較欣賞的電子賣場,東京圈三大電子賣場中ヨドバシカメラ和ビッグカメラ/bic camera都不錯,最討厭的是さくらや/sakuraya,以上純屬個人付了大筆卡費後的觀感就是了。


手信:秋葉原的出名手信便是動漫罐頭拉麵與Oden(關東煮)

秋葉原ラジオ会館
  • http://www.radiokaikan.org/
Gamers
  • http://www.anibro.jp/
Aso Bit City
  • akibaasobit.jp
Trader
  • http://e-trader.jp/
Mandarake
  • http://www.mandarake.co.jp/index2.html
石丸電気
  • http://ishimaru.eiden.co.jp/
Sofmap
  • http://www.sofmap.com/
Tsukumo
  • http://shop.tsukumo.co.jp/
海洋堂店
  • http://www.kaiyodo.co.jp/
Yodobashi-Akiba (10pm)
  • http://www.yodobashi-akiba.com/
Eating
Pepper Lunch位於秋葉原Yodobashi-Akiba的8F
營業時間到pm11:00
所以就算逛到Yodabashi-Akiba關店(pm10:00)再來吃也是ok的^^
  • http://yukiblog.tw/read-495.html
検索条件: 秋葉原~新宿  2009/11/24 15:35発

乗車時間:13分
総額:160円
距離:8.6km
(所要時間:16分)

■ 秋葉原
|  JR 総武線各停(中野行) 0.9km
|  15:38~15:41 [3分] 2009/11/24
|  160円
◇ 御茶ノ水
|  JR 中央線(高尾行) 7.7km
|  15:44~15:54 [10分]
|  ↓
■ 新宿

2008年12月版

空路有効期間2009年11月01日~2010年01月04日
DAY 3 (MON)新宿->淺草(雷門,仲見世,觀音寺)(10:00)->上野/阿美橫(12:00)東京站TokyoMidtown (13:30)->六本木之丘cityview→赤羽橋 (19:00)

検索条件: 新宿~浅草  2009/11/24 19:37発

乗車時間:18分
総額:260円
距離:10.4km
(所要時間:24分)

■ 新線新宿
|  地下鉄 都営新宿線(本八幡行) 8.1km
|  19:37~19:51 [14分] 2009/11/24
|  260円
◇ 馬喰横山/東日本橋
|  地下鉄 都営浅草線(京成高砂行) 2.3km
|  19:57~20:01 [4分]
|  ↓
■ 浅草

2008年12月版
空路有効期間2009年11月01日~2010年01月04日

淺草 ( ASAKUSA)
淺草

創立於西元628年,是東京最古老的寺院。一年四季來自全球各地的朝拜客絡繹不絕,是淺草的象徵。 從地下鐵銀座線、都營淺草線淺草車站雷門出口,徒步前往。

  • http://www.flickr.com/search/?s=rec&w=all&q=%E6%B7%BA%E8%8D%89%E5%AF%BA&m=text

雷門

仲見世

  • http://asakusa-nakamise.jp/
  • 人形燒
検索条件: 浅草~上野  2009/11/24 19:18発

乗車時間:4分
総額:160円
距離:2.2km
(所要時間:4分)

■ 浅草
|  地下鉄 東京メトロ銀座線(渋谷行) 2.2km
|  19:18~19:22 [4分] 2009/11/24
|  160円
■ 上野

2008年12月版

空路有効期間2009年11月01日~2010年01月04日

上野 (Ueno)

二木之菓子

  • 帆立貝
  • http://www.nikinokashi.co.jp/
三香園
  • http://www.rakuten.co.jp/sankouen/

Eating
上野登亭鰻魚定食
  • http://travel.openrice.com/japan/tokyo/restaurant/sr2.htm?poiid=141
検索条件: 上野~六本木  2009/11/24 17:0発

乗車時間:26分
総額:190円
距離:10.8km
(所要時間:26分)

■ 上野
|  地下鉄 東京メトロ日比谷線(中目黒行) 10.8km
|  17:00~17:26 [26分] 2009/11/24
|  190円
■ 六本木

2008年12月版

空路有効期間2009年11月01日~2010年01月04日

六本木 (ROPPONGI)

  • http://kunghc.pixnet.net/blog/post/7553456

TokyoMidtown

  • http://www.tokyo-midtown.com/jp/index.html
  • http://kunghc.pixnet.net/blog/post/20149603
  • http://aandcinlove.pixnet.net/blog/post/24150771
  • http://www.wretch.cc/blog/blog.php?id=Cecillia&search=Tokyo+Midtow&search_title=1
  • http://www.wretch.cc/blog/SUVcougar/17851518

Fujifilm Square

  • http://fujifilmsquare.jp/

巨型蜘蛛

  • http://www.flickr.com/photos/60079932@N00/3110220760/

朝日電視台

  • http://www.flickr.com/photos/persu417/3936057928/
21_21 DESIGN SIGHT
  • 從Galleria走出到Tokyo Midtown周圍的中城公園,就會看到三角型的水泥建築21_21 Design Sight
  • http://qqwan.pixnet.net/blog/post/10152857

tokyo city view (¥1500)

  • http://www.tokyocityview.com/ja/index.html
  • http://kunghc.pixnet.net/blog/post/2905626
  • http://www.flickr.com/photos/suvrangshu/3215207296/
  • http://blog.pixnet.net/kunghc/post/7553456
  • 交通: 搭乘日比谷線,1C出口。出來有一兩分鐘就到了

森美術館 (Mori Art Museum)

  • http://www.mori.art.museum/html/jp/index.html
  • http://www.flickr.com/search/?s=rec&w=all&q=%E6%A3%AE%E7%BE%8E%E8%A1
  • %93%E9%A4%A8&m=text#page=4
Eating
一蘭
  • www.ichiran.co.jp/index.html
検索条件: 六本木~赤羽橋  2009/11/24 16:31発

乗車時間:3分
総額:170円
距離:1.9km
(所要時間:3分)

■ 六本木
|  地下鉄 都営大江戸線大門・両国方面(都庁前[折返]行) 1.9km
|  16:33~16:36 [3分] 2009/11/24
|  170円
■ 赤羽橋

2008年12月版

空路有効期間2009年11月01日~2010年01月04日

赤羽橋
東京鐵塔
  • http://www.tokyotower.co.jp/taiwan/
  • http://www.flickr.com/photos/austin_lee0502/4095812804/

検索条件: 赤羽橋~新宿  2009/11/24 17:15発

乗車時間:13分
総額:210円
距離:6.5km
(所要時間:13分)

■ 赤羽橋
|  地下鉄 都営大江戸線六本木経由(光が丘行) 6.5km
|  17:17~17:30 [13分] 2009/11/24
|  210円
■ 新宿

2008年12月版
空路有効期間2009年11月01日~2010年01月04日

DAY 4 (TUE)新宿->築地市場(6:30)->-汐留(10:00)->台場(13:00)

検索条件: 新宿~築地市場  2009/12/1 13:3発

乗車時間:20分
総額:260円
距離:9.6km
(所要時間:20分)

■ 新宿
|  地下鉄 都営大江戸線六本木・大門方面(都庁前[折返]行) 9.6km
|  13:06~13:26 [20分] 2009/12/01
|  260円
■ 築地市場

2008年12月版

空路有効期間2009年11月01日~2010年01月04日

築地市場
検索条件: 新宿~汐留  2009/11/24 19:31発

乗車時間:18分
総額:210円
距離:8.7km
(所要時間:18分)

■ 新宿
|  地下鉄 都営大江戸線六本木・大門方面(清澄白河行) 8.7km
|  19:31~19:49 [18分] 2009/11/24
|  210円
■ 汐留

汐留 (Shiodome)
  • http://kunghc.pixnet.net/blog/post/7512868

汐留拉麵

  • http://www.ntv.co.jp/ramen-p/
    * Closed on Tuesday (maybe)

麵包超人專賣店

  • http://anpanman-terrace.jp/


日本電視台 (http://www.ntv.co.jp/tokei/)

  • B1F, B2F Dr. Black Jack sovenior
  • 宮崎駿大鐘 15:00
  • 宮崎駿的日テレ大時計
      星期一至星期五:中午12時、下午三時、六時、八時
週六週日:上午十時、中午十二時、下午三時、六時、八時


2008年12月版
空路有効期間2009年11月01日~2010年01月04日
検索条件: 汐留~台場  2009/11/24 19:32発

乗車時間:14分
総額:310円
距離:7.4km
(所要時間:14分)

■ 汐留
|  私鉄 ゆりかもめ(豊洲行) 7.4km
|  19:33~19:47 [14分] 2009/11/24
|  310円
■ 台場

2008年12月版

空路有効期間2009年11月01日~2010年01月04日

台場 (ODAIBA)
百合海鷗號一日券(ゆりかもめ一日乗車券) 800yen

速成!!!給新手的排台場行程指導

  • http://kunghc.pixnet.net/blog/post/25321972

推薦路線:
台場海濱公園站下車或下船-->東京唯一沙灘-->甲板城東京海灘(午餐)-->AquaCity(午餐2)
-->
自由女神, LuceMare教堂-->富士電視台本社大樓--> 調色板城(大摩天輪/MegaWeb/Venus Fort)
-->回AquaCity前等日落-->大江戶溫泉物語(晚餐)-->Caretta汐留46F看夜景 吃茶寮都路里

1.台場海濱公園 推薦指數: 5+
台場海濱公園站下車或下船-->東京唯一沙灘
這裡擁有東京唯一的沙灘(沙是外運來的) 傍晚和夜色更是充滿了浪漫的色彩
不過冬天的晚上很冷歐! 相信我 我們在這拍婚紗照的XD

彩虹橋

在第三站「芝浦埠頭」下車。走出車站,下了樓梯,倉庫街終點就是彩虹橋的起頭。彩紅橋有兩座人行散步道,分別是芝浦的北遊步道和臨海副都心的南遊步道。
入門票成人300日圓。步行通過彩虹大橋需30分鐘,中間必須經過橋內展望廳。4月至10月之間的開放時間為9:00~21:00。最後入場的時間為關閉時間的30分鐘之前。

富視電視台

Mediage對街,免費,開放到晚上八點 --球型展望室--在一樓買入場券(500YEN)
25F的球體展望台,可以嘹望台場、東京灣、東京鐵塔,這裡也是收集戳章的第一站喔!

原型球體場

  • 5:30就停止發售
  • http://allenls.pixnet.net/blog/post/25370777
  • http://allenls.pixnet.net/blog/post/25419822
  • Get Stamp Line
http://kunghc.pixnet.net/blog/post/7094641

摩天輪 成人900日元,旋轉一周16分鐘,10:00--22:00
透明底盤的摩天輪車廂超刺激,離彩虹大橋較遠,摩天輪的頂部高達115m,以其世界最大規模而聞名於世,是台場最醒目和人們最熟悉的指標。夜間,將摩天輪裝飾得五彩繽紛的燈飾,更值得一看。修建於摩天輪下面的“東京ZEPP”是東京都內規模最大的現代化大廈。
  • http://www.daikanransha.com/
  • http://kunghc.pixnet.net/blog/post/21628072
  • http://blog.yam.com/danny66/article/19726860

透明教堂婚禮: Luce Mare(ルーチェマーレ)

  • http://kunghc.pixnet.net/blog/post/18636142
先 搭乘百合海鷗號在汐留站下車,首先抵達 日本電視台,可以參觀電視台的節目錄製,或是逛逛電視台的主題商店,平日的十二點、十五點、十八點、二十點,可以在電視台前宮崎駿設計的大時鐘下,欣賞三 分鐘的報時表演,不僅有可愛的音樂,機器人也會各司其職地出來活動,若是星期六、日,還加演早上十點場哦!

海濱公園站下車後不需要下樓,直接連接到AQUA CITY旁的空中廣場
建議在aqua city用午餐,對面就是富士電視台,可搭百合海鷗號台場駅至青海駅(到摩天輪、維那斯廣場、TOYOTA展示場那個區域)也可從富士電視台步行過去約20分左右
青海站可以拍到自由女神像、彩虹大橋,最好在太陽下山以前去

豐田汽車展覽遊樂場(MEGA@WEB),位於彩虹城堡內,從青海站有步道直達,入場免費。裡面除了展示Toyota全車系的車種,還可付費乘坐E-Com自動車,繞行整個展覽場。記得要帶駕照,還有一定要坐無人駕駛的自動車,會有一堆的驚奇與驚訝聲出現的。
  • http://www.megaweb.gr.jp/
台場一丁目商店街
  • http://yuminghui.pixnet.net/blog/post/23012897
Positive Deli
  • http://www.positivefood.com/positivedeli/


検索条件: 台場~新宿  2009/12/1 17:44発

乗車時間:30分
総額:500円
距離:14.3km
(所要時間:37分)

■ 台場
|  私鉄 ゆりかもめ(新橋行) 7.8km
|  17:46~18:01 [15分] 2009/12/01
|  310円
◇ 新橋
|  地下鉄 東京メトロ銀座線(渋谷行) 2.3km
|  18:07~18:12 [5分]
|  190円
◇ 赤坂見附
|  地下鉄 東京メトロ丸ノ内線(新宿行) 4.2km
|  18:13~18:23 [10分]
|  ↓
■ 新宿

2008年12月版
空路有効期間2009年11月01日~2010年01月04日

DAY 5 (WED):新宿->中野(10:00)->新宿(14:30)->成田機場 (NW 295 18:35-22:55)

検索条件: 新宿~中野(東京)  2009/11/24 15:36発

乗車時間:4分
総額:150円
距離:4.4km
(所要時間:4分)

■ 新宿
|  JR 中央線中央特快(高尾行) 4.4km
|  15:37~15:41 [4分] 2009/11/24
|  150円
■ 中野

2008年12月版
空路有効期間2009年11月01日~2010年01月04日

中野 (Nakano)

  • http://kunghc.pixnet.net/blog/post/24366138
SUNMALL商店街為中心
中野BROADWAY




Future Trips
池袋(Ikebukuro)
SunShine City
  • http://www.sunshinecity.co.jp/
Animate
  • http://www.animate.co.jp/
Toyota Amlux
  • http://www.amlux.jp/main.html
Sega Ikeburkuro Gigo
  • http://location.sega.jp/loc_web/ikebukuro_gigo.html
立教大学
  • http://www.rikkyo.ac.jp/
Eating
無敵家 - 叉燒好正


三鷹->吉祥寺>中野>新宿>涉谷->池袋

三鷹
既三鷹之森Giibli美術館(港人多數稱為宮崎俊博物館)

吉祥寺
免治肉餅
炸牛肉球

中野
sun mall

東京站

行李可以放東京車站GRANSTA地下街 大型置物櫃


新宿御苑

  • http://www.env.go.jp/garden/shinjukugyoen/english/index.html
  • http://en.wikipedia.org/wiki/Shinjuku_Gyoen


銀座(shopping)

  • Sony大廈有可體驗Sony最新電腦 數位相機 DV PS3等的展示廳
  • http://kunghc.pixnet.net/blog/post/4561013

涉谷回轉壽司築地本店
  • http://comtools.esdlife.com/travel_forum/viewtopic.php?p=806
  • http://www.wretch.cc/blog/sophiee327/12320823

Friday, October 16, 2009

Progress Bar in Sharepoint List

http://pathtosharepoint.wordpress.com/2008/09/29/another-example-of-progress-bar/

Wednesday, October 14, 2009

Reason: Collection was modified; enumeration operation may not execute.

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/d2d0e939-2e29-462e-a2f0-6f5e54f6e8fd

http://mysharepointofview.com/2009/10/synchronization-for-shared-services-provider-failed/

Monday, October 12, 2009

Event ID: 27745

http://wss.made4the.net/archive/2008/04/22/the-description-for-event-id-27745-in-source-windows-sharepoint-services-3-cannot-be-found.aspx

Sunday, October 11, 2009

九寨溝、黃龍(瑤池仙境)、峨眉金頂6 天

http://www.uwants.com/viewthread.php?tid=6908605&extra=page%3D1
http://hk.myblog.yahoo.com/dream-travel/index?l=f&id=18
http://hk.myblog.yahoo.com/jw!qzy7V_qeHx5XoQg2eHYEId.2DhQk/article?mid=196
http://www.flickr.com/photos/14333367@N08/sets/72157602185998096/
http://www.flickr.com/photos/zenzhao/sets/72057594130985422/
http://www.flickr.com/photos/jackyhuang/740425418/in/set-72157600686398236/
http://www.flickr.com/photos/derek58/sets/72157621985021665/
http://www.flickr.com/photos/riverliu/sets/72157603631320541/?page=2
http://www.discuss.com.hk/viewthread.php?tid=10800491&extra=&page=1
http://hk.myblog.yahoo.com/tak_shun234/searchblog_art?p=%E6%B2%92%E6%9C%89%E6%B5%B7%E8%9E%BA%E7%9A%84%E6%B5%B7%E8%9E%BA%E6%BA%9D&my=1
http://www.flickr.com/photos/daniel-photo/sets/72157618691825397/

寬窄巷子
http://www.flickr.com/photos/jinx_dat/sets/72157622291308247/

錦里仿古一條街
http://www.singtao.com/yesterday/sup/0130mo02.html
http://eaj001.blogspot.com/2007/05/blog-post_48.html
http://www.flickr.com/photos/sitachangtw/51289794/

黃龍(瑤池仙境)
http://sy216.mysinablog.com/index.php?op=ViewArticle&articleId=1325211
http://wow.esdlife.com/space.php?uid=11145&do=album&id=8380
http://hk.myblog.yahoo.com/jw!fEArYheKGRZqgtnf5377wHY-/article?mid=1
http://hk.myblog.yahoo.com/jw!JfiK9iGQHxkifr1HjQWTWSs-/article?mid=515
http://www.flickr.com/search/?s=int&w=all&q=%E9%BB%83%E9%BE%8D&m=text

瑤池
http://www.flickr.com/photos/jackyhuang/745476385/in/set-72157600686398236/
五彩池
http://www.flickr.com/photos/jackyhuang/748953426/in/set-72157600686398236/
http://www.flickr.com/photos/jackyhuang/748093607/in/set-72157600686398236/
http://www.flickr.com/photos/jackyhuang/748094689/in/set-72157600686398236/
http://www.flickr.com/photos/jackyhuang/748094311/in/set-72157600686398236/

藏羌民族工藝店



九寨溝(世界自然遺產)






http://hk.myblog.yahoo.com/jw!PSBZpzmXFBMf6j_xLq9OklcfCDrrQ36dN29YKJQ-/article?mid=2
http://www.flickr.com/photos/zenzhao/sets/72057594130985422/
http://www.flickr.com/photos/jackyhuang/740425418/in/set-72157600686398236/
http://www.flickr.com/photos/derek58/sets/72157621985021665/
http://www.flickr.com/photos/riverliu/sets/72157603631320541/?page=2
http://www.flickr.com/photos/ahray/tags/%E4%B9%9D%E5%AF%A8%E6%BA%9D/
http://www.flickr.com/photos/annepeng1006/sets/72157604440850587/

盆景灘
火花海
諾日朗瀑布
http://www.flickr.com/photos/jackyhuang/740425418/in/set-72157600686398236/
http://www.flickr.com/photos/14333367@N08/1453561782/in/set-72157602185998096/
鏡海
http://www.flickr.com/photos/14333367@N08/1452696097/in/set-72157602185998096/
http://www.flickr.com/photos/roadstar/3923085106/in/set-72157622243248443/
珍珠灘瀑布
http://www.flickr.com/photos/14333367@N08/1453554176/in/set-72157602185998096/
http://www.flickr.com/photos/14333367@N08/1452688369/in/set-72157602185998096/
http://www.flickr.com/photos/14333367@N08/1453551526/in/set-72157602185998096/
http://www.flickr.com/photos/roadstar/3922302875/in/set-72157622243248443/
五花海
http://www.flickr.com/photos/14333367@N08/1452684625/in/set-72157602185998096/
http://www.flickr.com/photos/jackyhuang/739643957/in/set-72157600686398236/
熊貓海

箭竹海
孔雀河

則查窪溝(長海及)
http://hk.myblog.yahoo.com/jw!aXnRkQifGQLWGD8CmvnR3da.daph/article?mid=630

五彩池
http://www.flickr.com/photos/jackyhuang/748797692/in/set-72157600686398236/

樹正群海溝(老虎海,樹正瀑布/群海)

日則溝
http://www.flickr.com/photos/14333367@N08/1452693253/in/set-72157602185998096/
http://www.flickr.com/photos/14333367@N08/1452686451/in/set-72157602185998096/








樂山大佛
http://hk.myblog.yahoo.com/jw!fD5XNTOBCRvtK0nRX0AwlbA-/article?mid=1241
http://hk.myblog.yahoo.com/jw!ISpDkRqRGBb03IyIH_oHeE9hKg--/article?mid=372
http://hk.myblog.yahoo.com/jw!dOpumzWLHRTVAhE2QnD5/article?mid=970



峨嵋山金頂天下第一銅亭(第一山亭)摩崖石刻迎賓廣場天下第一牌坊
寬窄巷子文化保護區
http://hk.myblog.yahoo.com/boniyeung/article?mid=517




http://hk.myblog.yahoo.com/siusiu-happy/article?mid=3184
http://www.flickr.com/photos/ahray/2964697670/
http://www.flickr.com/photos/hammercem/sets/72157603780412084/


黃龍溪古鎮
http://hk.myblog.yahoo.com/jw!9Fa2h.uBBR4Bs0P2Noe05Q--/article?mid=14
http://hk.myblog.yahoo.com/jw!ykMEDG.aBUGbCNo_1p6I9Q--/article?mid=7483

Friday, September 25, 2009

3D Silverlight Charts in SharePoint: SmartTools.Charts

http://weblogs.asp.net/jan/archive/2008/12/04/3d-silverlight-charts-in-sharepoint-smarttools-charts.aspx

Tuesday, September 22, 2009

Repairing Supporting Files: “SharePoint alerts doesnt work” & “Invalid page URL”

http://sharepointworks.blogspot.com/2009/05/repairing-supporting-files-sharepoint.html

Speed up your SharePoint site using cache-control

http://blog.thekid.me.uk/archive/2007/07/17/speed-up-your-sharepoint-site-using-cache-control.aspx

Friday, September 11, 2009

How to move Microsoft SharePoint databases from one SQL server to another

http://ahmed-ammar.blogspot.com/2009/09/how-to-move-microsoft-sharepoint.html

Thursday, September 10, 2009

Steps required to install Microsoft Office SharePoint 2007 Service Pack 2 on existing SharePoint Farm

http://www.codeproject.com/Articles/36206/Steps-required-to-install-Microsoft-Office-SharePoint-2007-Service-Pack-2-on-existing-SharePoint-Farm.aspx?display=PrintAll

Wednesday, August 12, 2009

Useful Sharepoint Designer Custom Workflow Activities

http://www.codeplex.com/SPDActivities

Add Websphere node to windows service

http://www.websphere-world.com/modules.php?name=Forums&file=viewtopic&t=1024

Tuesday, August 11, 2009

Moving Sharepoint List item to another Sharepoint List

http://blog.henryong.com/2008/01/21/how-to-movemigrate-sharepoint-list-itemsdocuments-and-preserve-metadata-properties-at-the-same-time/

Thursday, July 30, 2009

Wednesday, July 29, 2009

Apply color coding to your SharePoint lists

http://pathtosharepoint.wordpress.com/2008/09/01/apply-color-coding-to-your-sharepoint-lists/

Serivce Locator Design Patterns

http://msdn.microsoft.com/en-us/library/cc707905.aspx

Displaying List Attachments in Custom List Forms

http://www.sharepointu.com/maartene/archive/2008/06/18/displaying-list-attachments-in-custom-list-forms.aspx

Monday, June 29, 2009

PhotographyBB Online Magazine

www.photographybb.com/magazine/

Apply color coding to your SharePoint lists

http://pathtosharepoint.wordpress.com/2008/09/01/apply-color-coding-to-your-sharepoint-lists/

Friday, June 26, 2009

Task Escalation using Workflows

http://sharepointsolutions.blogspot.com/2008/10/task-escalation-using-workflows.html

Thursday, June 18, 2009

Writing Custom Web Services for SharePoint

http://blogs.microsoft.co.il/blogs/egady/archive/2009/03/31/writing-custom-web-services-for-sharepoint.aspx

Tools to AutoGen Sharepoint Web Services

http://www.crsw.com/spdev/Wiki%20Pages/GenWS.aspx

Wednesday, June 17, 2009

Export Sharepoint User Group List

http://www.sharepointblogs.com/tonstegeman/archive/2007/10/03/export-user-information-to-excel-using-quot-export-to-spreadsheet-quot-in-sharepoint-2007.aspx

Tuesday, May 19, 2009

How to setup Sharepoint for Intranet and Internet Access

http://sharepointnotes.wordpress.com/2008/03/02/sharepoint-extranet-solutions-with-isa-server-2006-part-2-creating-the-extranet-web-application/

Friday, May 15, 2009

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

http://sharepoint.microsoft.com/blogs/fromthefield/Lists/Posts/Post.aspx?ID=14

Possible Solution
http://blogs.technet.com/apurdon/archive/2008/01/31/is-your-sharepoint-server-reporting-event-ids-7076-6398-6482.aspx

Possible Workaround

Indeed, I noticed that SPAdmin throws a Memory violation exception and than start to write all these error to Event Log. I liked the solution in

The author says:

However a simple work around is to schedule a task to restart your SPTimer service once a day. Not the server, not SharePoint, just the service.

There should no adverse side-effects to this as it is a proper service shutdown that should allow any running jobs to terminate prior to termination.

So, create a bat file “Restart SPTimer.bat” containing these lines:

net stop “Windows SharePoint Services Timer”
net start “Windows SharePoint Services Timer”

Schedule it to run once every night with the windows task scheduler.

Simple does it. Don’t care to waste any more time on this issue, don’t you all agree?

Thursday, May 14, 2009

Wednesday, May 13, 2009

Sharepoint 2007: Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION

No solution on how to resolve this error when adding Lab 01 Task 3 on Hands on Lab

Saturday, May 2, 2009

Flashback

select * from hr.employees where employee_id=100

select * from hr.employees as of TIMESTAMP(systimestamp-10) where employee_id=100

EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID

---------------------- -------------------- ------------------------- ------------------------- -------------------- ------------------------- ---------- ---------------------- ---------------------- ---------------------- ----------------------

100 Steven King SKING 515.123.4567 17-JUN-87 AD_PRES 100 90



1 rows selected



EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID

---------------------- -------------------- ------------------------- ------------------------- -------------------- ------------------------- ---------- ---------------------- ---------------------- ---------------------- ----------------------

100 Steven King SKING 515.123.4567 17-JUN-87 AD_PRES 24000 90



1 rows selected



Flashback Table



[oracle@localhost ~]$ sqlplus hr/hr



SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 10 08:45:52 2009



Copyright (c) 1982, 2005, Oracle. All rights reserved.





Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options



HR> create table hr.empt1 (id int);



Table created.



HR> insert into hr.empt1 values (1);



1 row created.



HR>

HR> drop table hr.empt1;



Table dropped.



HR> flashback table empt1 to before drop;



Flashback complete.



HR> select * from hr.empt1;

1



HR>

Log Files

Oracle's alert log
/u01/app/oracle/admin/orcl/bdump/alert_orcl.log


Show Alert Log Location
select value from v$parameter
where name like '%dump_dest';


http://www.adp-gmbh.ch/ora/concepts/alert_log.html

Backup and Restore

Backup



Backup Control File

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options



SYS> alter database backup controlfile to '/home/oracle/control.ctl';



Database altered.



SYS>



Backup Control File to Trace

When control file gone

  • use user trace script set #1 to recreate control file

When control and redo are both gone

  • use user trace script set #2



Using Data Pump Export and Import

Export Full Database

SYS> create directory DPXFER as '/home/oracle/oracleExport';



Directory created.



[oracle@localhost oracleExport]$ pwd

/home/oracle/oracleExport

[oracle@localhost oracleExport]$ expdp system/oracle directory=DPXFER DUMPFILE=hr.dmp FULL=y LOGFILE=expfull.log

Export Schema

Schema Export Mode The schema export mode is invoked using the SCHEMAS parameter. If you have no EXP_FULL_DATABASE role, you can only export your own schema. If you have EXP_FULL_DATABASE role, you can export several schemas in one go. Optionally, you can include the system privilege grants as well.

$ expdp hr/hr DIRECTORY=exp_dir DUMPFILE=schema_exp.dmp SCHEMAS=hr,sh,oe

[oracle@localhost oracleExport]$ expdp system/oracle DIRECTORY=dpxfer DUMPFILE=schema_exp.dmp schemas-hr,sh,oe LOGFILE=schema_exp.log

Table Export

This export mode is specified using the TABLES parameter. In this mode, only the specified tables, partitions and their dependents are exported. If you do not have the EXP_FULL_DATABASE role, you can export only tables in your own schema. You can only specify tables in the same schema.

$ expdp hr/hr DIRECTORY=exp_dir DUMPFILE=tables_exp.dmp TABLES=employees,jobs,departments



[oracle@localhost oracleExport]$ expdp system/oracle DIRECTORY=dpxfer DUMPFILE=tables_exp.dmp TABLES=hr.employees,hr.jobs,hr.departments LOGFILE=tables_exp.log



Export: Release 10.2.0.1.0 - Production on Tuesday, 07 April, 2009 23:33:32



Copyright (c) 2003, 2005, Oracle. All rights reserved.



Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/******** DIRECTORY=dpxfer DUMPFILE=tables_exp.dmp TABLES=hr.employees,hr.jobs,hr.departments LOGFILE=tables_exp.log

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 192 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/COMMENT

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/TRIGGER

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported "HR"."DEPARTMENTS" 6.632 KB 27 rows

. . exported "HR"."EMPLOYEES" 15.76 KB 107 rows

. . exported "HR"."JOBS" 6.609 KB 19 rows

Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:

/home/oracle/oracleExport/tables_exp.dmp

Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 23:33:40



Full Import Mode

The full import mode loads the entire contents of the source (export) dump file to the target database. However, you must have been granted the IMP_FULL_DATABASE role on the target database. The data pump import is invoked using the impdp command in the command line with the FULL parameter specified in the same command line.

$ impdp system/ DIRECTORY=exp_dir DUMPFILE=expfull.dmp FULL=y LOGFILE=impfull.og

Schema Import Mode

The schema import mode is invoked using the SCHEMAS parameter. Only the contents of the specified schemas are load into the target database. The source dump file can be a full, schema-mode, table, or tablespace mode export files. If you have a IMP_FULL_DATABASE role, you can specify a list of schemas to load into the target database.

$ impdp hr/hr DIRECTORY=exp_dir DUMPFILE=expfull.dmp SCHEMAS=hr,sh,oe



Table Import Mode

This export mode is specified using the TABLES parameter. In this mode, only the specified tables, partitions and their dependents are exported. If you do not have the EXP_FULL_DATABASE role, you can import only tables in your own schema.

$ impdp hr/hr DIRECTORY=exp_dir DUMPFILE=expfull.dmp TABLES=employees,jobs,departments

Recovery

Find All files that need recovery

SYS> select name, error from v$datafile JOIN v$recover_file USING (file#);



no rows selected



Loss of Control File

  1. Shutdown instance by SHUTDOWN ABORT

  2. Copy the remaining control files to the missing file's location. Or copy to another location and update the instance's parameter file to point to the new location. Or, you can delete the missing control file from the init parameter file

  3. Start the instance

Loss of Redo Log File

  1. Determine whether there is a missing log file by examining the alert log

  2. Restore the missing file by copying one of the remaining files from the same group

  3. If the media failure is due to loss of disk drive, rename the missing file

  4. If the group has already been archived, or if you're in NOARCHIVELOG mode, you may choose to solve the problem by clearing the log group to re-create the missing files. Select the appropriate group and select the Clear Logfile action. You can also clear the affected group manually with the following command:

SYS> alter database clear logfile group 1;



Database altered



Loss of Data File in NOARCHIVELOG Mode

The loss of any data file in NOARCHIVELOG mode requires complete restoration of the database, including control files and all data files

  1. Shut down the instance if it is not already down

  2. Click Perform Recovery on the Maintenance properties page

  3. Select Whole Database as the type of recovery

Loss of Noncritical Data File in ARCHIVELOG Mode

  1. Click Perform Recovery on the Maintenance properties page

  2. Select “Datafiles” as the recovery type, and select “Restore to current time”

  3. Add all data files that need recovery

  4. Determine whether you want to restore the files to the default location or to a new location

  5. Submit the RMAN job to restore and recover the missing files

Loss of System-critical Data File in ARCHIVELOG Mode

  1. Shut down the instance if it is not already down

  2. Mount the database

  3. Click Perform Recovery on the Maintenance properties page

  4. Select “Datafiles” as the recovery type, and select “Restore to current time”

  5. Add all data files that need recovery

  6. Determine whether you want to restore the files to the default location or to a new location

  7. Submit the RMAN job to restore and recover the missing files

  8. Open the database. Users are not required to reenter data because the recovery is up to the time of the last commit


V$RECOVER_FILE

You can often use the table V$RECOVER_FILE to determine which files to recover. This table lists all files that need to be recovered, and explains why they need to be recovered.NoteThe table is not useful if the control file currently in use is a restored backup or a new control file created since the media failure occurred. A restored or re-created control file does not contain the information Oracle needs to fill V$RECOVER_FILE accurately.

The following query displays the file ID numbers of datafiles that require recovery:

SELECT file#, online, error
FROM v$recover_file;

Performance Tuning

Time Series Monitoring of the Data Buffers

http://www.praetoriate.com/t_v$buffer_pool_statistics.htm

select name, set_msize, db_block_gets, consistent_gets, physical_reads,

(1-(physical_reads/ decode(db_block_gets+consistent_gets, 0, .001, db_block_gets+consistent_gets)))*100 cache_hit_ratio

from v$buffer_pool_statistics

Monday, April 27, 2009

Oracle Data Dict

Check Executing SQL Statements
select /*+ T1A */ * from hr.employees;
select sql_id, executions, loads, sql_text from v$sql
where sql_text like '%T1A%';

SQL Explain Plan
select * from table (dbms_xplan.display_cursor('6npnynbfn50vs'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 6npnynbfn50vs, child number 0
-------------------------------------
select /*+ T1A */ * from hr.employees
Plan hash value: 1445457117
-------------------------------------------------------------------------------
Id Operation Name Rows Bytes Cost (%CPU) Time
-------------------------------------------------------------------------------
0 SELECT STATEMENT 3 (100)
1 TABLE ACCESS FULL EMPLOYEES 107 7276 3 (0) 00:00:01
-------------------------------------------------------------------------------
13 rows selected
Execution plan is case sensitive on SQL statements
Use Hash to store
select
u.sid,
substr(u.username,1,12) user_name,
s.sql_text
from
v$sql s,
v$session u
where
s.hash_value = u.sql_hash_value
and
sql_text not like '%from v$sql s, v$session u%'
order by
u.sid;

Redo Log
select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------------------- ---------------------- ---------------------- ---------------------- ---------------------- -------- ---------------- ---------------------- -------------------------
1 1 8 52428800 2 NO CURRENT 596545 25-JAN-09
2 1 6 52428800 2 NO INACTIVE 543104 24-JAN-09
3 1 7 52428800 2 NO INACTIVE 573428 25-JAN-09
alter system switch logfile;
alter system switch succeeded.
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------------------- ---------------------- ---------------------- ---------------------- ---------------------- -------- ---------------- ---------------------- -------------------------
1 1 8 52428800 2 NO ACTIVE 596545 25-JAN-09
2 1 9 52428800 2 NO CURRENT 607813 26-JAN-09
3 1 7 52428800 2 NO INACTIVE 573428 25-JAN-09

Kill Sessions

Check Data Files
1* select file_name, tablespace_name, bytes, autoextensible from dba_data_files
SYS> /
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_4qm78bfj_.dbf
USERS 5242880 YES
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_4qm78b7x_.dbf
SYSAUX 262144000 YES
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_4qm78bd0_.dbf
UNDOTBS1 36700160 YES
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_4qm78b7d_.dbf
SYSTEM 503316480 YES
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_4qm7c00l_.dbf
EXAMPLE 104857600 YES
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs2_4shhwf2w_.dbf
UNDOTBS2 20971520 NO
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_userstbs_4shj5fyy_.dbf
USERSTBS2 20971520 NO
/u01/app/oracle/oradata/ORCL/datafile/inventorytbs1
INVENTORY 5242880 NO
8 rows selected.
SYS>

Table Free Space
1* select table_name, pct_free, chain_cnt from user_tables where table_name like 'A%'
SYS> /
ATTRCOL$ 0 0
ARGUMENT$ 10 0
ACCESS$ 10 0
AUDIT$ 10 0
ATTRIBUTE$ 0 0
ASSOCIATION$ 10 0
APPROLE$ 10 0
AUD$ 10 0
AUX_STATS$ 10 0
AW$ 10 0
AW_OBJ$ 10 0

Check if FlashBack is ON
1* select name, current_scn, flashback_on from v$database
SYS> /
ORCL 782184 NO
SYS> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS> startup mount;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 109054196 bytes
Database Buffers 54525952 bytes
Redo Buffers 2973696 bytes
Database mounted.
SYS> alter database flashback on;
Database altered.
SYS>

Undo Transactions
select * from v$transactions

Others
select file#, checkpoint_change#, name from v$datafile
SYS> select name, open_mode from v$database;
ORCL READ WRITE
SYS> select * from v$instance;
1 orcl localhost.draco.com 10.2.0.1.0 15-FEB-09 OPEN NO 1 STOPPED ALLOWED
NO ACTIVE PRIMARY_INSTANCE NORMAL NO
1* select count(*) from v$fixed_table
SYS> /
1383
SYS> desc dict;
Name Null? Type
----------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------
TABLE_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SYS> select segment_name, extents, blocks, bytes from user_segments where segment_name like '%INV%';
INVALIDATION_REGISTRY$ 1 8 65536
INVOICE 1 8 65536
I_INVALIDATION_REGISTRY$ 1 8 65536
INVPK 1 8 65536
SYS> select tablespace_name, extent_management, segment_space_management from dba_tablespaces;
SYSTEM LOCAL MANUAL
UNDOTBS1 LOCAL MANUAL
SYSAUX LOCAL AUTO
TEMP LOCAL MANUAL
USERS LOCAL AUTO
UNDOTBS2 LOCAL MANUAL
EXAMPLE LOCAL AUTO
TEMPTBS2 LOCAL MANUAL
USERSTBS2 LOCAL AUTO
INVENTORY LOCAL AUTO
INVOICE_PK LOCAL AUTO
11 rows selected.
SYS> select * from session_roles;
no rows selected

Useful Sql

$ORACLE_HOME\rdbms\admin\catalog.sql
Create views data dictionary information

$ORACLE_HOME\rdbms\admin\catproc.sql
Build procedural package

Tablespace
Create undo tablespace
1* create undo tablespace undotbs2 datafile size 20M
SYS> /

Tablespace created.

Create temp tablespace
1* create temporary tablespace temptbs2 tempfile size 5M
SYS> /

Tablespace created.


SYS> alter system set undo_management=AUTO scope=spfile;

System altered.

Change undo tablespace
SYS> alter system set undo_tablespace=UNDOTBS1 scope=spfile;

System altered.

Change temporary tablespace
SYS> alter system set undo_tablespace=UNDOTBS1 scope=spfile;

System altered.

Create users tablespace
1* create tablespace userstbs2 datafile size 20M
SYS> /

Tablespace created.

Change users tablespace
SYS> alter database default tablespace userstbs2;

Database altered.


Create tablespace
SYS> create tablespace invoice_pk datafile '/u01/app/oracle/oradata/ORCL/datafile/invoicetbs1' size 5M autoextend ON;

Tablespace created.

SYS> ed
Wrote file afiedt.buf

1 create table invoice
2 (
3 ID number constraint invpk primary key
4 using index
5 (create unique index invpk on invoice(id) tablespace invoice_pk),
6 invdate date,
7 description varchar2(200))
8* tablespace invoice_pk
SYS> /

Table created.

Resize Tablespace
SYS> alter database datafile '/u01/app/oracle/oradata/ORCL/datafile/invoicetbs1' resize 10M;

Database altered.

Set Tablespace read only

SYS> alter tablespace invoice_pk read only;

Tablespace altered.

Set Tablespace read write

1* alter tablespace invoice_pk read write
SYS> /

Tablespace altered.

Users

Create users
SYS> create user usera identified by oracle default tablespace INVENTORY temporary tablespace temp;

User created

SYS> grant create session to usera;

Grant succeeded.

SYS> alter user usera quota unlimited on inventory;

User altered.

SYS> grant unlimited tablespace to usera;

Grant succeeded.
Create OS authenticated users
SYS> show parameter prefix;
os_authent_prefix string ops$
SYS> create user ops$oracle identified externally;

User created.

SYS> grant grant any object privilege to ops$oracle;

Grant succeeded.

SYS> grant create any table to ops$oracle;

Grant succeeded.
Allow to create table on any schema
owner stay the same as the schema owner
Lock/Unlock users
1* alter user usera account lock
SYS> /

SYS> alter user usera account unlock;

User altered.


Primary Key Deferrable

DEFERRED
indicates that the conditions specified by the deferrable constraint are checked when the transaction is committed.

INITIALLY DEFERRED DEFERRABLE tells Oracle to do deferred constraint checking

1 create table inventory(
2 partno number(4) constraint partno_pk primary key deferrable initially immediate,
3* partdesc varchar2(35) constraint partdesc_uq unique deferrable initially immediate)
SYS> /

Table created.

SYS> insert into inventory values (1,'A');

1 row created.

SYS> insert into inventory values (1,'B');
insert into inventory values (1,'B')
*
ERROR at line 1:
ORA-00001: unique constraint (SYS.PARTNO_PK) violated

1 create table inventory(
2 partno number(4) constraint partno_pk primary key deferrable initially deferred,
3* partdesc varchar2(35) constraint partdesc_uq unique deferrable initially deferred)
SYS> /

Table created.

SYS> insert into inventory values (1,'A');

1 row created.

SYS> insert into inventory values (1,'B');

1 row created.

SYS> commit;
commit
*
ERROR at line 1:
ORA-02091: transaction rolled back
ORA-00001: unique constraint (SYS.PARTNO_PK) violated

Check Log Switch
SYS> select sequence#, first_time from v$log_history;
1 23-JAN-09
2 23-JAN-09
3 23-JAN-09
4 23-JAN-09
5 23-JAN-09
6 24-JAN-09
7 25-JAN-09
8 25-JAN-09
9 26-JAN-09
10 15-FEB-09
11 25-FEB-09
12 01-MAR-09
13 02-APR-09

13 rows selected.
ArchiveLog Mode
Make sure you have enough disk space
archive log list;
SYS> Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 11
Current log sequence 13
SYS>
1* select name, log_mode,open_mode from v$database
SYS> /
ORCL NOARCHIVELOG READ WRITE


SYS> alter database archivelog;

Database altered.

SYS> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 12
Next log sequence to archive 14
Current log sequence 14
SYS>

SYS> select name, log_mode,open_mode from v$database;
ORCL ARCHIVELOG MOUNTED

DB_Recovery_Size
SYS> show parameter db_recovery_file_dest_size;
db_recovery_file_dest_size big integer 8048M

Guarantee Undo Rentention
SQL> alter tablespace undotbs1 RENTENTION GUARANTEE
SQL> alter tablespace undotbs1 RENTENTION NOGUARANTEE

Show current user
SQL> show users;

Display current database
SQL> select * from global_name;

Sqlplus Configuration

Config - $ORACLE_HOME/sqlplus/admin/glogin.sql

-- Personal settings
set pagesize 0
set linesize 190
define _editor=vi
set sqlprompt "&_user> "

SharePoint Designer available as a free download

http://www.microsoft.com/downloads/details.aspx?FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42&displaylang=en

Cannot add attachment to custom list form in SharePoint 2007

https://staceybailey.securespsites.com/blog/Lists/Posts/Post.aspx?ID=13


http://support.microsoft.com/default.aspx?scid=kb;EN-US;953271

http://msmvps.com/blogs/obts/archive/2007/04/14/802759.aspx

Schema

Varchar2 – update will use more extents
PK and unique key in Oracle will create index
Index
non unique
allow insert duplicate pk
commit ← check constraint, rollback
truncate table – DDL no rollback
bitmap index
sequence – cache default next 20 values

Password Resource Parameters

$ORACLE_HOME/rdbms/admin/utlpwdmg.sql

Profiles

SYS> show parameter resource;
resource_limit boolean FALSE
resource_manager_plan string
1* alter system set resource_limit=true
SYS> /

System altered.

Privileges

Object privileges
base on db object, table
grant … with grant option;
System privileges
create session
grant … with admin option;
grant to other people as well

Users Role

SYSTEM
can connect only when database startup
cannot startup/shutdown recovery

SYSOPER
user public
startup/shutdown
complete recovery
cannot crete user/query table

Force DB to connect to listener

SYS> alter system register;

System altered.

Shutdown Database

[oracle@localhost bdump]$ emctl stop dbconsole
TZ set to Asia/Macao
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.draco.com:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
[oracle@localhost bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 29 22:06:34 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SYS> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost bdump]$ lsnrctl stop

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JAN-2009 22:08:13

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully

SYS> shutdown abort;
ORACLE instance shut down.
Startup will apply redo log

Startup Database

[oracle@localhost bdump]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JAN-2009 22:09:01

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting //u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Log messages written to //u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.draco.com)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 29-JAN-2009 22:09:01
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File //u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.draco.com)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@localhost bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 29 22:09:11 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SYS> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 83888372 bytes
Database Buffers 79691776 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SYS> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost bdump]$ emctl start dbconsole
TZ set to Asia/Macao
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.draco.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ............................ started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/localhost.draco.com_orcl/sysman/log
[oracle@localhost bdump]$



SYS> startup nomount;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 83888372 bytes
Database Buffers 79691776 bytes
Redo Buffers 2973696 bytes
SYS>

use parameter file
start smon and other processes
not use control file

SYS> alter database mount;

Database altered.

Use control file

If start DB first, then listener, DB has to wait for timeout to connect to listener. Vice versa, DB will register listener automatically.

In nomount/mount mode, data dictionary is not available because Data file has not been read

Oracle Default Port

Listener – 1521
iSqlplus – 5560
DB Console - 1158
2nd DB Console – 5500
3rd DB Console – 5501

Check Oracle Process Running

oracle@localhost bdump]$ ps -ef | grep _orcl
oracle 2828 12099 2 21:43 pts/2 00:00:18 /u01/app/oracle/product/10.2.0/db_1/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 -Doracle.home=/u01/app/oracle/product/10.2.0/db_1/oc4j -Doracle.oc4j.localhome=/u01/app/oracle/product/10.2.0/db_1/localhost.draco.com_orcl/sysman -DEMSTATE=/u01/app/oracle/product/10.2.0/db_1/localhost.draco.com_orcl -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost.draco.com_orcl/config/jazn.xml -Djava.security.policy=/u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost.draco.com_orcl/config/java2.policy -Djava.security.properties=/u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/u01/app/oracle/product/10.2.0/db_1/localhost.draco.com_orcl -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/10.2.0/db_1 -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/home/oc4j.jar -config /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost.draco.com_orcl/config/server.xml
oracle 3843 1 3 21:56 ? 00:00:00 ora_j000_orcl
oracle 3847 11527 0 21:56 pts/1 00:00:00 grep _orcl
oracle 12099 1 0 17:54 pts/2 00:00:02 /u01/app/oracle/product/10.2.0/db_1/perl/bin/perl /u01/app/oracle/product/10.2.0/db_1/bin/emwd.pl dbconsole /u01/app/oracle/product/10.2.0/db_1/localhost.draco.com_orcl/sysman/log/emdb.nohup
oracle 16935 1 0 17:59 ? 00:00:00 ora_pmon_orcl
oracle 16937 1 0 17:59 ? 00:00:00 ora_psp0_orcl
oracle 16939 1 0 17:59 ? 00:00:00 ora_mman_orcl
oracle 16941 1 0 17:59 ? 00:00:03 ora_dbw0_orcl
oracle 16943 1 0 17:59 ? 00:00:08 ora_lgwr_orcl
oracle 16945 1 0 17:59 ? 00:00:03 ora_ckpt_orcl
oracle 16947 1 0 17:59 ? 00:00:06 ora_smon_orcl
oracle 16949 1 0 17:59 ? 00:00:00 ora_reco_orcl
oracle 16951 1 0 17:59 ? 00:00:03 ora_cjq0_orcl
oracle 16953 1 0 17:59 ? 00:00:05 ora_mmon_orcl
oracle 16955 1 0 17:59 ? 00:00:00 ora_mmnl_orcl
oracle 16957 1 0 17:59 ? 00:00:00 ora_d000_orcl
oracle 16959 1 0 17:59 ? 00:00:00 ora_s000_orcl
oracle 16996 1 0 17:59 ? 00:00:00 ora_qmnc_orcl
oracle 17103 1 0 17:59 ? 00:00:02 ora_q000_orcl
oracle 31941 1 0 21:04 ? 00:00:00 ora_q002_orcl