oracleµÄ10.2dmpÎļþµ¼ÈëÎÊÌâ,Óгêл¡£
ÈçÌâÄ¿, ÎÒÓÐÒ»¸ö±ðÈ˵ÄoracleÊý¾Ý¿âEXP³öÀ´µÄ.DMPÎļþ£¬ ÎÒ×Ô¼ºµ¼Èë,ʧ°Ü£¿´íÎóÐÅÏ¢----->>> ¶ÁÈ¡µ¼ÈëÎļþ ORA-31619: ת´¢Îļþ "c:\ora\PTRC_oracle_database.dmp" ÎÞЧ ʱ³öÏÖÎÊÌâ¡£ ÎÒÅóÓѵ¼Èë,¾Ý˵Ëû´´½¨ÁËÒ»¸ö³¬¼¶Óû§,·¢ÏÖÓкܶàÓû§ºÍ±í¿Õ¼ä. ²»ÖªµÀÕâÀïµÄÅóÓÑÓа취ûÓÐ.×îºÃÊÇÔÚÉϺ£µÄÅóÓÑ, Óгêл,²»¹ý²»ÊǺܶà.
ÊDz»Êǰ汾µÄÎÊÌ⠻ظ´ÄÚÈÝÌ«¶ÌÁË£¡ ת´¢Îļþ "c:\ora\PTRC_oracle_database.dmp" ÎÞЧ? -------------- ÄãÈ·ÈϸÃÎļþºÃʹ£¿ Äãµ¼ÈëµÄÓû§ÒªÓе¼ÈëȨÏÞ¡£¡£¡£ Îļþ·¾¶Òª¶Ô¡£¡£¡£ ÒªÊÇ¿ÉÒÔ²Ù×÷,ÎÒ¸øÄ㿪Զ³Ì. »òÕß°ÑDMP·Åµ½Ò»¸öÍøÂçÓ²ÅÌ¿ÉÒÔÏÂÔØ. Ö÷ÒªÊÇÏëÔÚÉϺ£·½±ãЩ. Ö±½ÓÔ¼Ò»¸öµØ·½,ÏÖ³¡¾ÍÄܲÙ×÷ÁË. Ô¶³Ì±È½ÏÂ鷳Ĩ. ±ðÈËÅÂÎÒ²»¶ÒÏÖ, ÎÒÓÖ²»ÖªµÀ±ðÈËÄÜ×öºÃ²».ºÇºÇ. ÒýÓà ÉϺ£µÄÅóÓÑ£¬³å°¡¡£Õ¦ºÃʶ¼ÂÖ²»µ½°³ÄØ¡¡ // *Cause: Either the file was not generated by Export or it was corrupted. // *Action: If the file was indeed generated by Export, report this as an // Import bug and submit the export file to Oracle Customer Support. 1 ¼ì²éÎļþÊÇ·ñË𻵣¨Èç´«Êä¹ý³ÌÖУ©£¬´óСÊÇ·ñÒ»Ö¡£ 2 ¼ì²éIMP°æ±¾ÊÇ·ñ>=EXP°æ±¾¡£ ÎÒ×Ô¼ºÓõÄsystem, ȨÏÞÈ·ÈϹýÁË¡£ Îļþ·¾¶Ò²ÊǶԵģ¬Òª²»¾ÍÌáʾÕÒ²»µ½ÎļþµÄ´íÎóÁË. ÒýÓà Äãµ¼ÈëµÄÓû§ÒªÓе¼ÈëȨÏÞ¡£¡£¡
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......