[B! oracle] chanpon0ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

chanpon0 id:chanpon0

oracleã«é–¢ã™ã‚‹chanpon0ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (16)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

MySQL 5.7 InnoDB æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢
1. Copyright Â© 2016, Oracle and/or its affiliates. All rights reserved. | MySQL 5.7 InnoDB æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ï¼ˆãã®1ï¼‰ Yoshiaki Yamasaki / å±±ï¨‘ ç”±ç« MySQL Senior Sales Consultant, Asia Pacific and Japan updated: 2016/09/30 2. Copyright Â© 2016, Oracle and/or its affiliates. All rights reserved. Safe Harbor Statement ä»¥ä¸‹ã®äº‹é …ã¯ã€å¼Šç¤¾ã®ä¸€èˆ¬çš„ãªè£½å“ã®æ–¹å‘æ€§ã«é–¢ã™ã‚‹æ¦‚è¦ã‚’èª¬æ˜Žã™ã‚‹ã‚‚ã®ã§ã™ã€‚ ã¾ãŸã€æƒ…å ±æä¾›ã‚’å”¯ä¸€ã®ç›®çš„ã¨ã™ã‚‹ã‚‚ã®ã§ã‚ã‚Šã€ã„ã‹ãªã‚‹å¥‘ç´„ã«ã‚‚çµ„ã¿è¾¼ã‚€ã“ã¨ã¯ã§ã ã¾ã›ã‚“ã€‚ä»¥ä¸‹ã®äº‹é …ã¯ã€ãƒžãƒ†ãƒªã‚¢ãƒ«ã‚„ã‚³ãƒ¼ãƒ‰ã€æ©Ÿèƒ½ã‚’æ
chanpon0 2018/03/08
mysql 5.7

å…¨æ–‡æ¤œç´¢

fulltext index

oracle
ãƒªãƒ³ã‚¯
SQL*Loader ã®ä½¿ã„æ–¹ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
SQL Loader (SQL ãƒãƒ¼ãƒ€) ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã®ä½¿ç”¨æ–¹æ³• SQL Loader æ¦‚è¦ SQLLoader ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§å¤–éƒ¨ãƒ•ã‚¡ã‚¤ãƒ«ã«è¨˜è¿°ã•ã‚Œã¦ã„ã‚‹åˆ¶å¾¡ãƒ•ã‚¡ã‚¤ãƒ«ã¨ä¸€å®šã®æ›¸å¼ã§è¨˜è¿°ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ã¿ã®å¤§é‡ã®ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿(â€»)ã‚’åŠ¹çŽ‡ã‚ˆãé«˜é€Ÿã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¡¨ã«ãƒãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ (â€») ãƒ†ã‚ã‚¹ãƒˆå½¢å¼ã ã‘ã§ã¯ãªãã€Native ãªåž‹ã®ãƒ‡ãƒ¼ã‚¿ã‚„ LOB åž‹ã®ãƒ‡ãƒ¼ã‚¿ã‚‚ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®è¨å®šã«ã‚ˆã£ã¦ãƒãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã€‚ SQL Loader ã®ä¸»ãªç‰¹å¾´ ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒ‘ã‚¹ API ã‚’ä½¿ç”¨ã—ãŸé«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ã®ãƒãƒ¼ãƒ‡ã‚£ãƒ³ã‚°(ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆãƒ»ãƒ‘ã‚¹ãƒ»ã‚¤ãƒ³ã‚µãƒ¼ãƒˆ) è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ã®ãƒ‘ãƒ©ãƒ¬ãƒ«ãƒãƒ¼ãƒ‰ æ¼¢å—ã‚³ãƒ¼ãƒ‰(ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆ)ã®å¤‰æ› SQL é–¢æ•°ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼é–¢æ•°ã€ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ãªã©ã‚’ä½¿ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ã®ç”Ÿæˆã€åˆæˆã€å¤‰æ›ãŒå¯èƒ½ ä¸é©æ ¼ãƒ‡ãƒ¼ã‚¿ã®æŽ’é™¤ã¨ãƒ¬ãƒãƒ¼ãƒˆã€ãƒã‚° SQL Loa
chanpon0 2016/06/03
ã‚ã¨ã§èªã‚€

ORACLE

SQL

sqlloader
ãƒªãƒ³ã‚¯
è¡¨ã®çµåˆã‚’æ¥µã‚ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
æœ¬é€£è¼‰ã§ã¯ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã‹ã‚‰ã€ç‰¹ã«SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ³¨ç›®ã—ã¦ã€å®Ÿè·µãƒ¬ãƒ™ãƒ«ã®æ‰‹æ³•ã‚’è§£èª¬ã™ã‚‹ã€‚èªè€…ã¯Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ç†è§£ã—ã€é‹ç”¨ç®¡ç†ã®å®Ÿå‹™çµŒé¨“ã‚’ç©ã‚“ã§ã„ã‚‹ã“ã¨ãŒæœ›ã¾ã—ã„ã€‚å¯¾è±¡ã¨ã™ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ç¾çŠ¶ã§åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹Oracle9iã®æ©Ÿèƒ½ã‚’åŸºæœ¬ã¨ã™ã‚‹ãŒã€Oracle 10gã§æœ‰åŠ¹ãªæƒ…å ±ã‚‚éšæ™‚ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ é€£è¼‰ç›®æ¬¡ å‰å›žã¾ã§ã¯ã€ç´¢å¼•ã«é–¢ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚ä»Šå›žã‹ã‚‰ã¯è¡¨ã®çµåˆã«é–¢ã™ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Šæ–¹æ³•ã‚’è€ƒãˆã¦ã¿ã¾ã™ã€‚çµåˆå‡¦ç†ã¯ã€æ£è¦åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€å¿…ãšå¿…è¦ã«ãªã‚‹å‡¦ç†ã§ã‚ã‚Šã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå•é¡Œã¨ãªã‚Šã‚„ã™ã„éƒ¨åˆ†ã§ã‚‚ã‚ã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ã€å‚ç…§ã™ã‚‹è¡¨ã®ä»¶æ•°ã€çµžã‚Šè¾¼ã¿æ¡ä»¶ã®æœ‰ç„¡ãªã©ã‚’å¤‰æ›´ã—ã€çµåˆã®ç¨®é¡žã«ã‚ˆã£ã¦å‡¦ç†æ™‚é–“ã€ã‚¢ã‚¯ã‚»ã‚¹ãƒ–ãƒãƒƒã‚¯æ•°ãªã©ãŒã©ã®ã‚ˆã†ã«å¤‰ã‚ã‚‹ã‹ã€å®Ÿä¾‹ã‚’æŒ™ã’ã¦èª¬æ˜Žã—ã¦ã„ã
chanpon0 2016/05/31
ã‚ã¨ã§èªã‚€

oracle

SQL
ãƒªãƒ³ã‚¯
Oracleã§æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦åˆ¥åã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹æ–¹æ³• - å°ã•ã„é ƒã¯ã‚¨ãƒ©å‘¼å¸
ã¯ã˜ã‚ã« Oracle DBã«ãŠã„ã¦ã€ã™ã§ã«å˜åœ¨ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€åˆ¥åã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã¨ãã«copyã‚³ãƒžãƒ³ãƒ‰ã¿ãŸã„ãªã‚‚ã®ãŒã‚ã‚‹ã®ã‹ã¨æ€ã£ã¦ã„ãŸã‚‰ã€ã¡ã‚‡ã£ã¨é•ã„ã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€åˆ¥åã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦æ›¸ã„ã¦ã„ã¾ã™ã€‚ Oracleã®åŸºæœ¬ ~ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ã‹ã‚‰è¨è¨ˆ/é‹ç”¨ã®åˆæ©ã¾ã§posted with amazlet at 19.09.29æ¸¡éƒ¨ äº®å¤ª ç›¸å· æ½” æ—¥æ¯”é‡Ž å³»ä½‘ å²¡é‡Ž å¹³å…«éƒŽ å®®å· å¤§åœ° æŠ€è¡“è©•è«–ç¤¾ å£²ã‚Šä¸Šã’ãƒ©ãƒ³ã‚ãƒ³ã‚°: 65,273 Amazon.co.jpã§è©³ç´°ã‚’è¦‹ã‚‹ Oracleã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦åˆ¥åã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹ã«ã¯ã€create tableæ–‡ã‚’ä½¿ã„ã¾ã™ã€‚ãã®éš›ã«ã‚³ãƒ”ãƒ¼å…ƒã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰selectã—ãªãŒã‚‰ã€create tableã—ã¾ã™ã€‚ ä»¥ä¸‹ã®ä¾‹ã§ã¯ã€table01ã‚’ãƒ™ãƒ¼ã‚¹ã«table01
chanpon0 2016/04/26
ã‚ã¨ã§èªã‚€

Oracle

ã‚³ãƒ”ãƒ¼
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/post/entry/column_exp_imp
chanpon0 2016/04/26
ã‚ã¨ã§èªã‚€

oracle

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
ãƒªãƒ³ã‚¯
Oracle 11gã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã—ãŸã¾ã¾ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’å‰Šé™¤ã™ã‚‹ - å°ã•ã„é ƒã¯ã‚¨ãƒ©å‘¼å¸
ã¯ã˜ã‚ã« Oracleã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã™ã‚‹ã‚ˆã†ãªãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½œæˆä¸ã«ã€ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯å‡¦ç†ã«ä¸å‚™ãŒã‚ã‚‹ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ãŒãƒãƒƒã‚¯ã•ã‚ŒãŸã¾ã¾ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ ã“ã†ãªã£ã¦ã—ã¾ã£ãŸå ´åˆã«ã€ãƒãƒƒã‚¯ã—ã¦ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’å¼·åˆ¶çš„ã«çµ‚äº†ã•ã›ã‚‹æ–¹æ³•ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ æ©Ÿèƒ½ã§å¦ã¶ Oracle Databaseå…¥é–€posted with amazlet at 14.06.16ç¿”æ³³ç¤¾ (2013-10-30) å£²ã‚Šä¸Šã’ãƒ©ãƒ³ã‚ãƒ³ã‚°: 23,228 Amazon.co.jpã§è©³ç´°ã‚’è¦‹ã‚‹ ãƒãƒƒã‚¯ã—ã¦ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’ç‰¹å®šã™ã‚‹ ãƒãƒƒã‚¯ã‚’ã¤ã‹ã‚“ã§ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’ç‰¹å®šã™ã‚‹ã«ã¯ã€ä»¥ä¸‹ã®ã‚µã‚¤ãƒˆã«è¨˜è¼‰ã•ã‚Œã¦ã„ã‚‹SQLã‚’ä½¿ã„ã¾ã™ã€‚ ã“ã®SQLã§ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã—ã¦ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®SIDã¨ã‚·ãƒªã‚¢ãƒ«Noã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ Oracleã§ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ã—ã¦ã„ã‚‹sessionã‚’æ®ºã™ - Qiita ãƒãƒƒã‚¯ã—ã¦ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’çµ‚äº†ã•ã›ã‚‹ ã‚»ãƒƒ
chanpon0 2016/04/26
oracle

ãƒãƒƒã‚¯

session
ãƒªãƒ³ã‚¯
ã‚»ãƒƒã‚·ãƒ§ãƒ³IDã‹ã‚‰OSã®ãƒ—ãƒã‚»ã‚¹IDã‚’èª¿ã¹ã‚‹æ–¹æ³• - ablog
Oracle ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³IDã‹ã‚‰OSã®ãƒ—ãƒã‚»ã‚¹IDã‚’èª¿ã¹ã‚‹SQLã‚’ãƒ¡ãƒ¢ã€‚ SQL set pagesize 1000 set linesize 200 col spid for a4 col sid for 9999 col serial# for 9999 col username for a10 col program for a30 col machine for a30 col osuser for a10 select proc.spid, ses.sid, ses.serial#, ses.username, ses.program, ses.machine, ses.osuser from v$session ses, v$process proc where ses.paddr = proc.addr; å®Ÿè¡Œçµæžœ SPID SID SERIAL# USERNAME PRO
chanpon0 2016/04/25
session kill

oracle
ãƒªãƒ³ã‚¯
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ˆãƒ¡ãƒ¢ãƒªè¨å®šç·¨ï¼‰
ãƒ¡ãƒ¢ãƒªåˆ©ç”¨èª¿æŸ» ãƒãƒƒãƒ•ã‚¡ãƒ»ã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ OLTPç³»ã®å‡¦ç†ã§ã‚ã‚Œã°90%ä»¥ä¸Šã¯ç¶æŒã—ãŸã„ã€‚ ãƒ’ãƒƒãƒˆçŽ‡ãŒæ‚ªã„å ´åˆã¯ã€DB_CASHE_SIZEã®å€¤ã‚’å¤§ããã™ã‚‹ã€‚ ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ãŒååˆ†ã«é«˜ã„å ´åˆã€å‰²å½“é‡ã‚’å¢—ã‚„ã—ã¦ã‚‚ã»ã¨ã‚“ã©ï¼ˆã‚ã‚‹ã„ã¯å…¨ãï¼‰åŠ¹æžœã¯ãªã„ã€‚ select (a.value+b.value) "Logical", c.value "Phygical", round(((1-(c.value / (a.value+b.value))) * 100),3) "Hit Ratio" from v$sysstat a,v$sysstat b,v$sysstat c where a.name = 'db block gets' and b.name = 'consistent gets' and c.name = 'physical reads'; ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚ãƒ£ãƒƒ
chanpon0 2016/04/25
ãƒãƒƒã‚¯å¯¾å¿œã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ï¼ˆsessionï¼‰kill

oracle
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
chanpon0 2016/04/14
oracle
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºãƒ„ãƒ¼ãƒ« SI Object Browser
SI Object Browserã¯ã€Oracle Databaseã‚’ã¯ã˜ã‚ã¨ã™ã‚‹ä¸»è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ©Ÿèƒ½ã‚’ã‚ªãƒ¼ãƒ«ã‚¤ãƒ³ãƒ¯ãƒ³ã§ã‚µãƒãƒ¼ãƒˆã—ãŸã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºãƒ„ãƒ¼ãƒ«ã€ã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®é–²è¦§ã€SQLã®ç·¨é›†/å®Ÿè¡Œã‚„å„ç¨®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆä½œæˆã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚°ãƒ©ãƒ ã®ãƒ‡ãƒãƒƒã‚°ã€Excelå½¢å¼ã§ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã®å‡ºåŠ›ãªã©ã‚’GUIä¸Šã§ç°¡å˜ã«å®Ÿè¡Œã§ãã¾ã™ã€‚ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆæ©Ÿèƒ½ãªã©ã®å„ç¨®DBAæ©Ÿèƒ½ã«ã‚‚å¯¾å¿œã—ã¦ãŠã‚Šã€é–‹ç™ºã‹ã‚‰é‹ç”¨ã¾ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºè€…ã®ç”Ÿç”£æ€§å‘ä¸Šã«è²¢çŒ®ã—ã¾ã™ã€‚
chanpon0 2016/04/14
æœ‰å„Ÿ

oracle
ãƒªãƒ³ã‚¯
sqlplusã§è¡¨ç¤ºãŒå¤‰ãªã®ã§ã€å‡ºåŠ›ã‚’æ•´å½¢ã—ãŸã„ã€‚
ã„ã¤ã‚‚ãŠä¸–è©±ã«ãªã£ã¦ã„ã¾ã™ã€‚ ã‚µãƒ¼ãƒã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦sqlplusã§ã€ ãƒ‡ãƒ¼ã‚¿ã‚’èª¿ã¹ãŸã„ã®ã§ã™ãŒã€ å‡ºåŠ›å½¢å¼ãŒè¦‹ã¥ã‚‰ãã¦å›°ã£ã¦ã„ã¾ã™ã€‚ ã‚ˆãã‚ã‹ã‚‰ã„ã®ã§ã™ãŒã€ --------------------------- ã‚«ãƒ©ãƒ åï¼‘ --------------------------- ã‚«ãƒ©ãƒ åï¼’ --------------------------- ã‚«ãƒ©ãƒ åï¼“ --------------------------- ï¼‘ã®å€¤ã€€ï¼’ã®å€¤ ï¼“ã®å€¤ --------------------------- ã‚«ãƒ©ãƒ åï¼‘ --------------------------- ã‚«ãƒ©ãƒ åï¼’ --------------------------- ã‚«ãƒ©ãƒ åï¼“ --------------------------- ä¸Šè¨˜ã®ã‚ˆã†ã«æ„å‘³ä¸æ˜Žãªå½¢å¼ã§å‡ºã¦ãã¾ã™ã€‚ ä¾‹ãˆã°ã“ã‚“ãªé¢¨ã« select ã‚«ãƒ©ãƒ ï¼‘,ã‚«ãƒ©ãƒ ï¼’,ã‚«ãƒ©
chanpon0 2016/04/13
oracle

sqlplus
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³åŒ–ã®æ¦‚å¿µ
chanpon0 2016/03/23
ã‚ã¨ã§èªã‚€

oracle

ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
OTN Japan ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
chanpon0 2016/03/23
ã‚ã¨ã§èªã‚€

oracle

ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
Oracle Data Pumpã®æ¦‚è¦
1 Oracle Data Pumpã®æ¦‚è¦ Oracle Data Pumpãƒ†ã‚¯ãƒŽãƒã‚¸ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãŠã‚ˆã³ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–“ã§éžå¸¸ã«é«˜é€Ÿã«ç§»å‹•ã§ãã¾ã™ã€‚Oracle Data Pumpã¯ã€Oracle Database 10g ãƒªãƒªãƒ¼ã‚¹1ï¼ˆ10.1ï¼‰ä»¥é™ã§ã®ã¿ä½¿ç”¨ã§ãã¾ã™ã€‚ ã“ã®ç« ã®å†…å®¹ã¯ã€æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ Data Pumpã®ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆ Data Pump Exportãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ãŠã‚ˆã³Importãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã®æ–°æ©Ÿèƒ½ Data Pumpã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚¢ã‚¯ã‚»ã‚¹æ–¹æ³• ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒªãƒ³ã‚¯ã‚’ä»‹ã—ãŸãƒ‡ãƒ¼ã‚¿ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ Data Pumpã‚¸ãƒ§ãƒ–å®Ÿè¡Œä¸ã«è¡Œã‚ã‚Œã‚‹å‡¦ç† ã‚¸ãƒ§ãƒ–ã®çŠ¶æ…‹ã®ç›£è¦– ãƒ•ã‚¡ã‚¤ãƒ«ã®å‰²å½“ã¦ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç•°ãªã‚‹å ´åˆã®ãƒ‡ãƒ¼ã‚¿ç§»å‹• ã‚ªãƒªã‚¸ãƒŠãƒ«ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŠã‚ˆã³ã‚¤ãƒ³ãƒãƒ¼ãƒˆã¨Data Pump ExportãŠã‚ˆã³Import Data Pumpã®ã‚³ãƒ³ãƒãƒ¼ãƒ
chanpon0 2016/03/17
oracle

DATA Pump
ãƒªãƒ³ã‚¯
Oracle:ç„¡æ–™ã§ä½¿ãˆã‚‹ã®Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ Oracle Database Express Edition 11g Release 2 ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã¾ã§
Oracle Database Express Edition 11g Release 2ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ Oracle Express Edition 11g Release2ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã‚’é–‹ãã¾ã™ã€‚ â€»ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã«ã¯Oracleã¸ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ç™»éŒ²(ç„¡å„Ÿ)ãŒå¿…è¦ã§ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã®"Accept License Agreement"ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ "Oracle Database Express Edition 11g Release 2 for Windows x32"ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãŒé–‹å§‹ã•ã‚Œã‚‹ã®ã§ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãŒçµ‚äº†ã™ã‚‹ã¾ã§å¾…ã¡ã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã•ã‚ŒãŸ"OracleXE112_Win32.zip"ã‚’ãƒ€ãƒ–ãƒ«ã‚¯ãƒªãƒƒã‚¯ã—ã¦è§£å‡ã—ã¾ã™ã€‚ è§£å‡ã•ã‚ŒãŸãƒ•ã‚©ãƒ«ãƒ€"DISK1"ã‚’é–‹ãã€"setup.exe"ã‚’ãƒ€ãƒ–ãƒ«ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ Oracle Database
chanpon0 2016/03/08
oracle
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/post/entry/sql_developersql
chanpon0 2016/03/07
oracle

SQL Developer
ãƒªãƒ³ã‚¯
1