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

"ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1.7 »ò¸ü¸ß°æ±¾"½â¾ö°ì·¨

1.Ñ¡ÔñÄúËù°²×°OrcaleµÄĿ¼£¬ÀýÈ磺C:\Oracle
2.ÓÒ¼üµã»÷£¬µ¯³ö“ÊôÐÔ”¶Ô»°¿ò£¬Ñ¡Ôñ“°²È«”Ñ¡Ï
3.Ìí¼Ó“IUser_»ú×ÓÃû³Æ”Óû§µÄȨÏÞ£¬²ÉÓÃÍêÈ«¿ØÖƵķ½Ê½
4.È·¶¨Ó¦Óúó£¬ÔÚÑ¡Ôñ“°²È«”Ñ¡ÏÖÐÑ¡Ôñ“IUser_»ú×ÓÃû³Æ”Óû§£¬µã»÷¸ß¼¶
5.Ñ¡ÔñÑ¡Ôñ¿ò“ÓÃÔÚ´ËÐÄʵĿÉÒÔÓ¦Óõ½×Ó¶ÔÏóµÄÏîÄ¿´úÌæËùÓÐ×Ó¶ÔÏóµÄȨÏÞÏîÄ¿(P)”
6.µã»÷Ó¦Ó×—È·¶¨¼´¿É¡£
Ôø¾­³¢ÊÔ¹ýÔÚ°²×°Ä¿Â¼ÉèÖÃNETWORK SERVICEÓû§µÄȨÏÞ£¬¿ÉÄÜÉÙÁË3ºóµÄ²½Ö裬ËùÒÔûÓгɹ¦£¡´ó¼Ò¿ÉÒÔÊÔÊÔ£¬Ó¦¸ÃÊÇ¿ÉÒԵġ£
´Ë²Ù×÷Ö÷ÒªÊÇΪÁËÈÃÄúµÄÓ¦ÓóÌÐò¿ÉÒÔ·ÃÎÊORCALE°²×°Ä¿Â¼Ïµēsqlnet.ora”Îļþ£¬ÆäÖмǼÁËÊý¾Ý¿â·þÎñµÄÁ¬½ÓµØÖ·¡£
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/mdmzl/archive/2009/06/15/4269835.aspx


Ïà¹ØÎĵµ£º

Oracle´´½¨×ÔÔö×ֶη½·¨ ORACLE SEQUENCEµÄ¼òµ¥½éÉÜ

ÏȼÙÉèÓÐÕâôһ¸ö±í£º
create
 
table
 S_Depart  (
   DepartId             
INT
                   & ......

½â¾öoracle¿Í»§¶ËÂÒÂë——SQLPLUSÂÒÂë½â¾ö

Òª½â¾öOracleµÄ¿Í»§¶ËÂÒÂëÎÊÌâ¹Ø¼üÊÇÒª°Ñ·þÎñÆ÷¶ËʹÓõÄ×Ö·û¼¯¸ú¿Í»§¶ËʹÓõÄ×Ö·û¼¯Í³Ò»ÆðÀ´¡£Oracle¿Í»§¶Ë£¨Sqlplus£©Í¨¹ýNLS_LANG»·¾³±äÁ¿À´È·¶¨¿Í»§¶ËʹÓõÄ×Ö·û¼¯¡£NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ ......

ORACLE¼òÒ׿ͻ§¶Ë°²×°ÓëʹÓ÷½·¨

£¨1£©¶Ôwindows»úÆ÷£º
      #½«Oracle installclientѹËõ°ü¿½±´µ½D:\oracle£¬²¢Ñ¡Ôñ½âѹÖÁµ±Ç°Ä¿Â¼£¨»òÆäËûĿ¼£¬¼ÇµÃ¸ü¸ÄÏàÓ¦µÄ»·¾³±äÁ¿¼´¿É£©
      #ÉèÖû·¾³±äÁ¿£º
      Path£¨ÔÚ±äÁ¿ÖмÓÈ룩    ......

OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È

OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È
1¡¢Ç°ÑÔ
    ĿǰËùÓÐʹÓÃOracle×÷ΪÊý¾Ý¿âÖ§³Åƽ̨µÄÓ¦Ó㬴󲿷ÖÊý¾ÝÁ¿±È½ÏÅÓ´óµÄϵͳ£¬¼´±íµÄÊý¾ÝÁ¿Ò»°ãÇé¿ö϶¼ÊÇÔÚ°ÙÍò¼¶ÒÔÉϵÄÊý¾ÝÁ¿¡£
    µ±È»ÔÚOracleÖд´½¨·ÖÇøÊÇÒ»ÖÖ²»´íµÄÑ¡Ôñ£¬µ«Êǵ±Äã·¢ÏÖÄãµÄÓ¦ÓÃÓжàÕÅ±í¹ØÁªµÄʱºò£¬²¢ÇÒÕâЩ±í´ó²¿·Ö¶¼ÊÇ±È½Ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ