Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\ohj\wbdod10659.htm

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\ohj\wbdod10659.htm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja">
<script src="./callback.js" type="text/javascript"></script>
<noscript>??????????????avaScript???????????????????????????????????????????????JavaScript??????????</noscript>
</head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Script-Type" content="text/javascript" />

<meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" />
<meta name="date" content="2009-06-04T0:46:15Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="Case Study" />
<meta name="relnum" content="11g Release 2 (11.2)" />
<meta name="partnum" content="E10582-01" />
<link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" />
<link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" />
<link rel="contents" href="toc.htm" title="Contents" type="text/html" />
<link rel="prev" href="wbdod10658.htm" title="Previous" type="text/html" />
<link rel="next" href="wbdod10660.htm" title="Next" type="text/html" />
<title>???</title>
</head>
<body>
<div class="zz-skip-header"><a href="#BEGIN">??????????????</a></div>
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<col width="86%" />
<col width="*" />
<tr valign="bottom">
<td align="left"></td>
<td align="center"><a href="wbdod10658.htm"> <img src="./dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a>&nbsp;</td>
<td align="center"><a href="wbdod10660.htm"> <img src="./dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td>
</tr>
</table>
<p><a id="WBDOD10659" name="WBDOD10659"></a></p>
<div class="sect2"><a id="sthref124" name="sthref124"></a>
<h1>???</h1>
<a name="BEGIN" id="BEGIN"></a>
<p>???????????arehouse Builder????????????<code>employees.xls</code>?????xcel??????????????????????????</p>
<a id="WBDOD90743" name="WBDOD90743"></a>
<p class="subhead2">???1: Excel??DBC?????????????????</p>
<p>Microsoft Excel????????????????????xcel??DBC????????????????????????????????xcel??DBC????????indows???????????????????????</p>
<a id="WBDOD90744" name="WBDOD90744"></a>
<p class="subhead2">???2: Excel??????????????????????????????</p>
<p>Excel??????????????????????????????????????????????????????????????????????</p>
<ol>
<li>
<p><code>employee_details</code>?????????????racle????????????????????????????????</p>
<p>?????????????????????????????????????????????Oracle Database???????????????????????????????????????????</p>
</li>
<li>
<p>??????????????????<span class="bold">???????</span>??<span class="bold">???????</span>??????????????????????????????????????????????????????????????????????</p>
</li>
</ol>
<a id="BGBGEFFF" name="BGBGEFFF"></a><a id="WBDOD90745" name="WBDOD90745"></a>
<p class="subhead2">???3: ??????DSN?????</p>
<p>Microsoft ODBC Administrator???????????????????????????????SN?????????????</p>
<ol>
<li>
<p><span class="bold">??????????</span>??<span class="bold">???????</span>??<span class="bold">??????????? ???????????????????????????? ????? (ODBC)??</span>???????????</p>
<p>????????????DBC ????? ????? ????????????????????????????????????????</p>
</li>
<li>
<p>???????? DSN?????????????????<span class="bold">???????</span>????????????????? ??????????????????????????????????????</p>
</li>
<li>
<p>?????????????????????????????<span class="bold">??icrosoft Excel Driver??</span>???????????</p>
</li>
<li>
<p>??????????????????????????????????<code>odbc_excel</code>???????????</p>
</li>
<li>
<p><span class="bold">?????????????</span>???????????????????????????Excel?????????????????</p>
</li>
<li>
<p>??????????????????????????xcel???????????????????????????????????????????????</p>
</li>
</ol>
<a id="WBDOD90747" name="WBDOD90747"></a>
<p class="subhead2">???4: ???????????????????°???????</p>
<p>?????????????????????????ó???????????????????????????????????????????????????????????????????????????????????????????°???????????????ó??????????????????????????<code>init</code><code><span class="codeinlineitalic">SID</span></code><code>.ora</code>????????????<code><span class="codeinlineitalic">SID</span></code>????????????????????racle?????????????????????°?????????????????<code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>&yen;hs&yen;admin</code>??????????????</p>
<p>?°????????<code>initexcelsid.ora</code>????????<code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>&yen;hs&yen;admin</code>????????????????????</p>
<pre xml:space="preserve" class="oac_no_warn">
HS_FDS_CONNECT_INFO = <code><span class="codeinlineitalic">odbc_excel</span></code>
HS_AUTOREGISTER = TRUE
HS_DB_NAME = dg4odbc
</pre>
<p>????????<code>odbc_excel</code>???????3??????????????SN??????????<code>excelsid</code>??????????????????????racle????????????????????</p>
<a id="WBDOD90748" name="WBDOD90748"></a>
<p class="subhead2">???5: listener.ora???????????</p>
<p>??????????????????????????racle Database???????°??????????????????????????????????°????????????????????????????????????????????????????????????????????<code>listener.ora</code>????????<code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>&yen;network&yen;admin</code>??????????????????????????????????</p>
<pre xml:space="preserve" class="oac_no_warn">
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = <code><span class="codeinlineitalic">excelsid</span></code>)
      (ORACLE_HOME = <code><span class="codeinlineitalic">C:\oracle11g\product\11.2.0\db_1</span></code>)
      (PROGRAM = dg4odbc)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = <code><span class="codeinlineitalic">C:\oracle11g\product\11.2.0\db_1</span></code>)
      (PROGRAM = extproc)
      )
  )
</pre>
<ol>
<li>
<p><code>SID_NAME</code>????°???????????ó???????????????????°????????????????????????<code>SID</code>????????????????????<code>excelsid</code>?????</p>
</li>
<li>
<p><code>ORACLE_HOME</code>????°????????racle Database????????????????????????????????????????</p>
</li>
<li>
<p><code>PROGRAM</code>???????????????????????????????????????????????????</p>
</li>
</ol>
<p>???????????????????????????????????????</p>
<div align="center">
<div class="inftblnote"><br />
<table class="Note oac_no_warn" summary="" cellpadding="3" cellspacing="0">
<tbody>
<tr>
<td align="left">
<p class="notep1">???:</p>
????????????<code>GLOBAL_NAMES</code>??????????????????????????????°??????<code>FALSE</code>??????????????????????????ALSE?????????????????????????????</td>
</tr>
</tbody>
</table>
<br /></div>
</div>
<a id="WBDOD90749" name="WBDOD90749"></a>
<p class="subhead2">???6: ODBC??????????????????</p>
<p>?°???????????DBC?????????????????????????</p>
<ol>
<li>
<p>???????????????????????DBC?????????????????????????</p>
<p>ODBC????????????????????????????????????<a href="wbdod90609.htm#CACCJGEG">??DBC??????????????</a>????????????????</p>
</li>
<li>
<p>???????????????????????????????????????????????????????????????????????????????????????????????</p>
</li>
<li>
<p>????????????????????????????????????????????????<span class="bold">???????</span>????????????????????????????</p>
<p>?????????????????<code>listener.ora</code>???????????????<code>SID_NAME</code>????????????????????????</p>
<p>?????????????????????????????????????????????????????????????????????????????????</p>
<p>Oracle database????????????????????????????????????????????????????????????????????????????????</p>
<p>?????????????????????????????????????????????????????????????????????????????</p>
</li>
</ol>
<a id="WBDOD90750" name="WBDOD90750"></a>
<p class="subhead2">???7: ?°???????????????????????????????Excel?????????????????????</p>
<p>?°???????????????????????????????Excel?????????Warehouse Builder??????????????????????????????????????????<span class="bold">?????</span>???????????????????????????????????????????????????????????????????????????xcel?????????????????????????????????????</p>
<ol>
<li>
<p><span class="bold">??mployee_details??</span>???????????????????????????????????????????????????????</p>
</li>
<li>
<p><span class="bold">???????</span>???????????????????????????????</p>
<p>employee_details??????????????????????DBC?????????????????<code>employee_details</code>???????????????????</p>
</li>
</ol>
<a id="WBDOD90751" name="WBDOD90751"></a>
<p class="subhead2">???8: ?????????????????????????????????????????</p>
<p>Warehouse Builder?????????????????????????????????????????????????DBC?????????????????<code>employee_details</code>????????????????????????????????????????????????????????????????</p>
<a id="WBDOD90753" name="WBDOD90753"></a>
<p class="subhead2">???9: ????????????</p>
<p>????????????????????????????????????????????????????????8?????????????????????????????????????????????????????????????????????????????????????</p>
</div>

<div class="footer">
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td align="left" width="86%"><a href="topicid:help_legalnotices_html"> <span class="copyrightlogo">Copyright&nbsp;(C)&nbsp;2009,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;All&nbsp;rights&nbsp;reserved.</span></a>
</td>
</tr>
</table>
</div>
</body>
</html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de