Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MOSS2007µÄBDCÁ¬½ÓORACLEÊý¾Ý¿â

×÷ΪÊý¾Ý¼¯³ÉµÄMOSS×é¼þBDC£¬ÔÚMOSS2007°æ±¾Öл¹Óкܶ಻³ÉÊìµÄµØ·½£¬ËäÈ»¿ÉÒÔ´æÈ¡ÆäËûÊý¾Ý¿âÖеÄÊý¾Ý£¬µ«ÅäÖÃȷʵºÜ¸´ÔÓ£¬È±Ê¡µÄ¹¤¾ßÒ²ºÜÈõ£¬ÕâÊÇÔÚÒ»¸öÏîÄ¿ÖÐÓõ½µÄÁ¬½ÓORACLEÊý¾Ý¿âÅäÖÃÎļþ£¬¼Í¼ÔÚ´ÎÒÔ±ãºóÓá£
<?xml version="1.0"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.XSD" Type="Database" Version="1.0.0.0" Name="OracleLOBSystem" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
  <Properties>
    <Property Name="WildcardCharacter" Type="System.String">%</Property>
  </Properties>
  <LobSystemInstances>
    <LobSystemInstance Name="OracleInstance">
      <Properties>
        <Property Name="DatabaseAccessProvider" Type="System.String">Oracle</Property>
        <Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>
        <Property Name="RdbConnection Data Source" Type="System.String">(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = djin-pc)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = umboydb.bingosoft)))</Property>
        <Property Name="RdbConnection Pooling" Type="System.String">false</Property>
        <Property Name="RdbConnection User ID" Type="System.String">system</Property>
        <Property Name="RdbConnection Password" Type="System.String">123456</Property>
        <Property Name="RdbConnection Integrated Security" Type="System.String" />
        <Property Name="WildcardCharacter" Type="


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

¹ØÓÚORACLE¼àÌý·þÎñÎÞ·¨Æô¶¯µÄÎÊÌâ

½ñÌìµçÄÔÄûؼң¬Æô¶¯oracleÊý¾Ý¿âµÄ¼àÌý·þÎñʱ·¢ÏÖÎÞ·¨Æô¶¯¡£¸ø³öµÄ´íÎóÌáʾÊÇ˵£¬Õâ¸ö·þÎñÆô¶¯ÁËÓÖÍ£Ö¹ÁË£¬²»ÖªµÀÊÇΪʲô¡£ÒòΪÔÚѧУµÄʱºòÓÃÊÇûÓÐÎÊÌâµÄ¡£ÎÒÏëÓ¦¸ÃÊÇÒòΪipµÄÊÇÎÊÌâ¡£ÔÚÍøÉϲéÁËһϣºÄãÊÇ·ñÐÞ¸ÄÄãµÄ»úÆ÷Ãû»òIPµØÖ·£¬Èç¹ûÓÐÐ޸쬰ÑORACLE\ora81\network\admin\listener.oraÎļþÖеÄhostÐÞ¸ÄΪлúÆ÷à ......

ÈçºÎ¼ÓËÙOracle´óÅúÁ¿Êý¾Ý´¦Àí

ÈçºÎ¼ÓËÙOracle´óÅúÁ¿Êý¾Ý´¦Àí
Ò»¡¢           Ìá¸ßDML²Ù×÷µÄ°ì·¨£º
¼òµ¥ËµÀ´£º
£±¡¢ÔÝÍ£Ë÷Òý£¬¸üкó»Ö¸´.±ÜÃâÔÚ¸üеĹý³ÌÖÐÉæ¼°µ½Ë÷ÒýµÄÖØ½¨.
£²¡¢ÅúÁ¿¸üУ¬Ã¿¸üÐÂһЩ¼Ç¼ºó¼°Ê±½øÐÐÌá½»¶¯×÷.±ÜÃâ´óÁ¿Õ¼Óûعö¶ÎºÍ»òÁÙʱ±í¿Õ¼ä.
£³¡¢´´½¨Ò»ÁÙʱµÄ´óµÄ±í¿Õ¼äÓà ......

ORACLE Êý¾Ý¿â£¨²éѯ Ö÷¼üÍâ¼üÔ¼Êø£©

 --   ²éѯÍâ¼üÔ¼Êø(²éij±íµÄËùÓи¸±í)  
  select   c.constraint_name,cc.column_name,rcc.owner,rcc.table_name,rcc.column_name  
  from   user_constraints   c,user_cons_columns   cc,user_cons_columns   rcc  
  where   c.owner=' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ