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

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¡¿ÉÏÁË¡£



Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸ö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 ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ