ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷ÉÏ°²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅäÖÃORACLEÊý¾Ý¿âµÄ±ðÃû(service name)¡£
2¡¢ÔÚWIN2000»òÕßwin2003·þÎñÆ÷->¹ÜÀí¹¤¾ß->Êý¾ÝÔ´(ODBC)->
ϵͳDSN£¨±¾»úÆ÷ÉÏNTÓòÓû§¶¼¿ÉÒÔÓã©->Ìí¼Ó->ORACLE ODBC Driver->Íê³É->
data source name ¿ÉÒÔ×Ô¶¨Ò壬ÎÒÒ»°ãÌîORACLEÊý¾Ý¿âµÄsid±êÖ¾£¬
descriptionÀï¿ÉÒÔÌîORACLEÊý¾Ý¿âÏêϸÃèÊö£¬Ò²¿ÉÒÔ²»Ìî->
data source service name ÌîµÚ1²½¶¨ÒåµÄORACLEÊý¾Ý¿â±ðÃû->OK¡£
£¨Óû§DSNºÍÎļþDSNÒ²¿ÉÒÔÀàËÆÅäÖ㬵«Ê¹ÓõÄʱºòÓÐһЩÏÞÖÆ£©
3¡¢SQL ServerµÄµ¼ÈëºÍµ¼³öÊý¾Ý¹¤¾ßÀï->Ñ¡Êý¾ÝÔ´-> Êý¾ÝÔ´£¨ÆäËü£¨ODBCÊý¾ÝÔ´£©£©->
Ñ¡µÚ2²½ÔÚODBCÀﶨÒåµÄϵͳDSN source name£¬Óû§ÃûÃÜÂë´¦ÌîдORACLEϵͳµÄÓû§ÃûºÍÃÜÂë->
ÏÂÒ»²½->Ñ¡ÔñÄ¿µÄ£¬Ñ¡SQL ServerÊý¾Ý¿â£¨¸úÉÏÃæµÚ¶þµã½²µÄÒ»Ö£¬¾Í²»Öظ´ÁË£©¡£
×¢Ò⣺ÔÚORACLE±íºÍSQL Server±íÖ®¼ä'ת»»'ÄDz½ºÜÖØÒª£¬
¿ÉÒԸıäĬÈϵÄ×Ö¶ÎÊý¾ÝÀàÐÍ£¬Èçimage->text,decimal->int
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
±¾ÎÄÏêϸµÄ½éÉÜÁËOracleÊý¾Ý¿â½ÏºÃµÄÊ®ÖÖÖØÐÂÆô¶¯²½Öè¡£
¡¡¡¡1. Í£Ó¦ÓòãµÄ¸÷ÖÖ³ÌÐò¡£
¡¡¡¡2. Í£oralceµÄ¼àÌý½ø³Ì:
¡¡¡¡$lsnrctl stop
¡¡¡¡3. ÔÚ¶ÀÕ¼µÄϵͳÓû§Ï£¬±¸·Ý¿ØÖÆÎļþ:
¡¡¡¡SQL>alter database backup controlfile to trace;
¡¡¡¡4. ÔÚ¶ÀÕ¼µÄϵͳÓû§Ï£¬ÊÖ¹¤Çл»ÖØ×÷ÈÕÖ¾Îļþ£¬È·±£µ±Ç°ÒÑÐ޸Ĺýµ ......
½¨Á¢±íÈçÏÂ:
ѧÉú»ù±¾ÐÅÏ¢±í
CREATE Student(
[Studentid][Int]IDENTITY(1,1)NOT NULL primary key,--Ö÷¼ü
[StudentName][char]NOT NULL
)
¿Î³ÌÐÅÏ¢±í
CREATE Subject(
[SubjectID][char]NOT NULL primary key, --Ö÷¼ü
[SubjectName][char]NOT NULL
)
³ ......
ʹÓÃPL/SQL developerÔ¶³Ì·ÃÎÊoracleÊý¾Ý¿âʱ£¬Ê×ÏÈҪȷ¶¨±¾»úÖÐ×°ÓÐoracle¿Í»§¶Ë¡£Ä¿Ç°»¹²»ÖªµÀÄÄÀïµ¥¶ÀµÄoracle¿Í»§¶Ë°²×°°ü¡££¨ÒòΪÎÒÓõÄÊÇoracle10g£¬oracle10g°²×°µÄ¹ý³ÌÖÐûÓÐÌض¨µÄ¿Í»§¶ËÑ¡ÏËùÒÔÎÒÒ»°ã¶¼ÊÇÔÚ±¾»úÓð²×°oracleËùÓй¦ÄÜ£©
ÔÚ±¾»ú°²×°ºÃoracle¿Í»§¶Ëºó£¬ÎÒÃÇÔÚ±¾»ú(¼´¿Í»§¶Ë)µÄoracleµÄ°²×°Ä¿Â¼Ï ......