ÓÐûÓÐwindowsÏÂÃæµÄoracle 10g¿Í»§¶Ë£¿
ÏÖÔÚÔÚÎҵijÌÐòÀïÃæÍ¨¹ý ocilibÀ´·ÃÎÊÁËÁíһ̨·þÎñÆ÷ÉϵÄoracleÊý¾Ý¿â¡£ ÄÇÔÚÎÒ»ú×ÓÉÏÒª±àÒë²âÊÔÕâ¸ö³ÌÐòµÄ»°£¬ÎÒÖÁÉÙҪװЩʲô£¿ ÎÒ²»Ïë×°ÄǸö600¶àMµÄ¶«Î÷£¬Ì«´óÁË£¬¶øÇÒ¶ÔÎÒÀ´ËµºÃ¶à¶«Î÷¶¼Ã»Óã¬ÒòΪÎÒ²¢²»ÔÚ±¾µØ´´½¨Êý¾Ý¿â¡¡ ÓÐûÓбȽÏСµÄһЩ¶«Î÷£¬¶øÇÒÓÃocilib¿â¿ÉÒÔ·ÃÎÊ ÎÒÔõô²ÅÄÜÔÚ±¾µØ×°×îÉٵĶ«Î÷À´·ÃÎÊÔ¶µØµÄoracleÊý¾Ý¿â£º£¿£¿ лл£¡£¡£¡£¡
ÄǸöÖÁÉÙҪװsql net; Èç¹ûÓÃdelphiд´úÂ룬¿ÉÒÔʹÓÃodac¿Ø¼þ£¬²»ÐèÒª°²×°¿Í»§¶Ë Ö»ÐèÒªÌáÈ¡oralceÊý¾Ý¿âµÄ¼¸¸ö¶¯Ì¬¿â¾ÍÐÐÁË ¿Í»§¶Ë²»ÐèÒª°²×°oracleµÄ Ŷ£¿ ÍøÉÏÓÐûÓÐÒѾ´òºÃµÄ°üÌṩµÄ£¿ лл£¡ Ö±½Óplsqldevelop²»¾ÍÐÐÁË£¿ pl/sql¾ÍokÁË Å¶£¬Ð»Ð»~~~ Ã÷ÌìÈ¥¹«Ë¾ÊÔһϠ:-) ÎÒÊdzõѧÕßÒýÓà ֱ½Óplsqldevelop²»¾ÍÐÐÁË£¿ Õâ¸ö¾ÍºÜOKÁËÒýÓà ֱ½Óplsqldevelop²»¾ÍÐÐÁË£¿ ÄܺÍ10g¼æÈݵÄÓÃ8°æ±¾ÒÔÉϵÄplsqldevelop Èç¹û²»×°oracle¿Í»§¶ËµÄ»°£¬ÓÃpl/sqlû·¨Á¬½ÓÊý¾Ý¿âµÄѽ ÌáʾûÓÐ×°¿Í»§¶Ë£¬囧 ×°ÁËinstant clientºÍpl sql develop µ«ÏÖÔÚÓÃpl sqlÁ¬½ÓµÄʱºò×ÜÊÇÌáʾÎÞ·¨Ê¶±ðÃèÊö·ûÖеÄÇëÇó ÔÚÍøÉÏËÑÁËһϣ¬ËµÊÇtnsnames.oraµÄÎÊÌâ µ«ÓÖ²»ÖªµÀÓ¦¸ÃÔõô¸Ä¡¡ лл´ó¼ÒÁË£¬ÒѾ³É¹¦ÁË~~~ µ«ÎÒÔÚ³ÌÐòÀïÃæÓÃOCI_InitializeÀ´³õʼ»¯ocilib¿âµÄʱºò³ö´íÁË¡¡ ÕâÊÇΪʲô£¿ лл£¡
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......