Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

Oracle Spatial ʵÀý¼ò½é

Oracle Spatial ¼ò½é£º
Ê×ÏÈ£¬Oracle Ö§³Ö×Ô¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬Äã¿ÉÒÔÓÃÊý×飬½á¹¹Ìå»òÕß´øÓй¹Ô캯Êý£¬¹¦Äܺ¯ÊýµÄÀàÀ´¶¨Òå×Ô¼ºµÄ¶ÔÏóÀàÐÍ¡£ÕâÑùµÄ¶ÔÏóÀàÐÍ¿ÉÒÔÓÃÓÚÊôÐÔÁеÄÊý¾ÝÀàÐÍ£¬Ò²¿ÉÒÔÓÃÀ´´´½¨¶ÔÏó±í¡£¶øOracle SpatialÒ²ÕýÊÇ»ùÓÚ´ËÖÖÌØÐÔËù¿ª·¢µÄÒ»Ì׿ռäÊý¾Ý´¦Àíϵͳ¡£
Spatial µÄ×Ô¶¨ÒåÊý¾ÝÀàÐÍÓкܶ࣬¶¼ÔÚMDSYS· ......

Oracle·ÖÒ³

Ô­À´ÓõÄSQL server£¬Ö÷ÒªÓÐÁ½ÖÖ·ÖÒ³·½·¨£ºÓαêºÍÆ´×Ö·û´®£¬Óα귨̫Âý£¬Æ´´®·¨Ò²ÓÐһЩȱÏÝ¡£
ÏÖÔÚÕÒµ½ÁËÒ»¸öOracleµÄ·ÖÒ³·½·¨£¬Ò²¿ÉÒÔ˵ÊÇÆ´×Ö·û´®£¬µ«ÊÇÓÃÆðÀ´¾Í±ÈSQL serverµÄÒª·½±ã£¬Ã»ÓÐ֮ǰµÄÎÊÌ⣺
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
W ......

Oracleµ¼Èë/µ¼³öÊý¾Ý

Oracle ÌṩÁ½¸ö¹¤¾ßimp.exe ºÍexp.exe·Ö±ðÓÃÓÚµ¼ÈëºÍµ¼³öÊý¾Ý¡£ÕâÁ½¸ö¹¤¾ßλÓÚOracle_home/binĿ¼Ï¡£
µ¼³öÊý¾Ýexp
1 ½«Êý¾Ý¿âATSTestDBÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂë123456 µ¼³öµ½c:\export.dmpÖÐ
exp system/123456@ATSTestDB file=c:\export.dmp full=y
ÆäÖÐATSTestDBΪÊý¾Ý¿âÃû³Æ£¬sys ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ