oracle imp µ¼ÈëÎÊÌâ
ÎÒÊÇÔÚlinux oracle11g µ¼³öµÄdmp ÔÚlinux oracle9iÀïµ¼Èë Ìáʾ´íÎó IMP-00058: ORACLE error 12535 encountered ORA-12535: TNS:operation timed out IMP-00000: Import terminated unsuccessfully ÕâÊÇÔõô»ØÊÂ
¸ß°æ±¾²»Äܵ¼µ½µÍ°æ±¾µÄÒýÓà ¸ß°æ±¾²»Äܵ¼µ½µÍ°æ±¾µÄ up.... ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx Q Q Ⱥ£º62697716 ¸ß°æ±¾µÄdmpÎļþÍùµÍ°æ±¾µÄ¿âÖе¼Èë»á³öÏÖÎÊÌâµÄ¡£ 9iµÄ¿ÉÒÔµ¼Èë11g£¬µ«·´Ö®»áÒì³£ ÕâÖÖÎÊÌâ¿ÉÒÔ½â¾öÂð »¹ÊǾÍÊÇûÓа취 ¿ÉÒÔµ¼³öSQL£¡ ³ýÁËÔËÐе¼³öµÄSQL£¬ºÃÏñûÓбðµÄ°ì·¨ÁË£¬ ÔËÐÐSQLµÄʱºò£¬Èç¹ûÄÄÀï³öÎÊÌâÁË£¬¿ÉÒÔÊÖ¶¯Ð޸ģ¬Ó¦¸Ã²»Âé·³¡£ Êǵĸ߰汾²»Äܵ¼ÈëµÍ°æ±¾µÄ£¬¿Ï¶¨»á´íÎóµÄ¡£ µÍ°æ±¾Äܵ¼Èëµ½¸ß°æ±¾ÖУ¬ µ«ÊǸ߰汾²»Äܵ¼µ½µÍ°æ±¾µÄ ÒòΪOracleÊÇÏòºó¼æÈݵģ¡¶ø²»ÊÇÏòǰ¼æÈÝ£¡ µ¼Èëµ¼³ö×î²»ÓÃŪµÄ¾Í°æ±¾ÎÊÌâ¡£ °²×°Ò»¸öºÍÄ㡾linux oracle9i¡¿Ò»ÑùµÄ¿Í»§¶Ë£¨»òÕßÈç¹û¿ÉÒԵϰֱ½Óͨ¹ýlinux oracle9i£©£¬Í¨¹ýÕâ¸ö¿Í»§¶ËÁ¬½Óµ½11gÉÏexp Ö®ºóÕâ¸ö dmpÎļþ¾Í¿ÉÒÔ˳ÀûµÄ±»impµ½¡¾linux oracle9i¡¿ÉÏÁË¡£
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼ ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ² SQL code:
......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮ ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update Caused ......
±¾À´ÒªÐ´¸öupdateÓï¾ä update table_a A set A.flag=1 where A.id in (select B.id from table_b B) ½á¹ûÎóд³É update table_a A set A.flag=1 where ......
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Ä ......