½«Îı¾Îļþµ¼Èëµ½OracleµÄÎÊÌâ
1.ÇëÎÊÈçºÎͨ¹ýsqlÓï¾ä½«Îı¾Îļþµ¼Èëµ½OracleÖÐÄØ 2.ÇëÎÊÐèÒªµ¼Èëµ½OracleÖеÄÎı¾ÎļþÖеĸñʽӦ¸ÃÊÇÔõÑùµÄ£¿ Àý£º¼ÙÉèÎÒÏë°ÑÒ»°ÙÍòÌõÊý¾Ý´ÓÎı¾Îļþµ¼Èëµ½±íAÖÐ AÓÐÈý¸ö×Ö¶Î AID AName ADate Èý¸ö²»Í¬ÀàÐÍ ÇëÎÊÎÒÕâÒ»°ÙÍòÌõÊý¾ÝÓ¦¸ÃÒÔʲô¸ñʽ´æÈëµ½txtÎļþÖвÅÄܵ¼Èëµ½±íAÄØ 3.ÇëÎÊOracleÔÚµ¼ÈëÎļþµÄʱºò¼ÓµÄÊÇÄÄÖÖËø£¬Èç¹ûµ¼ÈëµÄʱºòÎÒÕýÇÉÔÚ²éѯ¸Ã±íA£¬»á³öÏÖʲôÇé¿ö
µ¼ÈëÎı¾Îļþ ÓÃsqlldr 1 ´¿SQLÓï¾äÎÞ·¨ÊµÏÖ£¬¿ÉÒÔʹÓÃsql*loader 2 ORACLE¶ÔÄãµÄÎı¾Êý¾Ý¸ñʽÎÞÒªÇó£¬Ö»ÒªÄãµÄʵ¼ÊÊý¾ÝÓëÄã±í×Ö¶ÎÀàÐͲ»³åÍ»¡£ 3 ORACLE¶ÁÓëд²»³åÍ»¡£µ¼Èëʱ²éѯ±íA£¬²é³öµÄÊÇÔÓÐÊý¾Ý+Äãµ¼ÈëÒÑÌá½»Êý¾Ý¡£ÒýÓà 2 ORACLE¶ÔÄãµÄÎı¾Êý¾Ý¸ñʽÎÞÒªÇó£¬Ö»ÒªÄãµÄʵ¼ÊÊý¾ÝÓëÄã±í×Ö¶ÎÀàÐͲ»³åÍ»¡£ 3 ORACLE¶ÁÓëд²»³åÍ»¡£µ¼Èëʱ²éѯ±íA£¬²é³öµÄÊÇÔÓÐÊý¾Ý+Äãµ¼ÈëÒÑÌá½»Êý¾Ý¡£ 2.¶Ô¸ñʽÎÞÒªÇóÊÇʲôÒâ˼£¬¼ÙÈçÎÒÓÐÈý¸ö×ֶΣ¬ÎÒÔÚTXTÎļþÖÐÔõô¼ÓÈë·Ö¸ô·û£¬»»Ðзû¡£ËùÓеÄÊý¾Ý¶¼Ð´ÔÚÒ»Æð¿Ï¶¨Ã»°ì·¨Çø·ÖÊÇÄǸö×ֶεİ¡£¿ 3.ÎÒÔÚµ¼Èë±íAµÄʱºò²»»á×Ô¶¯Ëø±íÂð£¿ÕâÊÇÈç¹ûÕýÔÚÖ´Ðвéѯ£¬Ëø±í¾Í»áʧ°ÜµÄ°É£¿ 2 ÊÇÐèÒªÓÐͳһ·Ö¸î·û¡£ 3 Õâ¸ö²»ÐèÒªÄ㿼ÂÇ£¬ÄãÖ»ÐèÒª¼Çס£¬<span style="font-size:24px">ORACLEд²»×èÈû¶Á£¬·´Ö®ÒàÈ»</span>¡£ ÓÐûÓпÉÒÔͨ¹ý³ÌÐòÖ±½ÓÓÃÓï¾äÀ´Íê³ÉµÄ·½·¨ÄØ ÓÃsql loader ÓÃÍⲿ±íÒ²ÐÐ sqlldrÊÇͨ¹ýÃüÁîÐÐÀ´Ö´Ðеģ¬Ò²¾ÍÊÇ˵ÿ´ÎÔËÐÐsql
Ïà¹ØÎÊ´ð£º
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 ÕýÈ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ MySQLʹÓõÄÊÇselect @@tx_isolation; ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿ SQL code: SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......