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

¹ØÓÚoracleµ¼ÈëDMP£¬Çë´Í½Ì

  ÎÒµÄÀÏʦ¸øÁËÒ»¸ödmpÎļþ¸øÎÒ£¬Ëûµ¼³öµÄ»úÆ÷ʱserver2003£¬¶øÎÒÓõÄÊÇxp¡£
  ÔÚµ¼ÈëµÄʱºò£¬³öÏÖ£º
    IMP-00010: ²»ÊÇÓÐЧµÄµ¼³öÎļþ, Í·²¿Ñé֤ʧ°Ü
    IMP-00000: δ³É¹¦ÖÕÖ¹µ¼Èë
  ÎÒÉÏÍøÕÒÁ˺ܾã¬ÍøÉÏ˵ÊÇÎļþÍ·¿ÉÄܲ»Í¬£¬ËùÒÔ²»Äܵ¼È룬ÎÒ¾Íн¨ÁËÒ»¸öÊý¾Ý¿â£¬È»ºóÖ´ÐÐexpÀ´µ¼³ö¸ÃÊý¾Ý¿âΪdaochu.dmpÈ»ºó¶Ô±ÈÀÏʦ¸øµÄlaoshi.dmp£¬´ò¿ª·½Ê½ÊÇÓÃUltraEdit-32¡£ÉÔ΢¶Ô±ÈÁËһϣ¬·¢ÏÖÎļþÍ·ÊÇÍêÈ«²»Í¬µÄ£¬ÒÔÏÂÊÇdouchu.dmpµÄÍ·²¿ÐÅÏ¢£º
Java code:

TEXPORT:V10.02.01
DIFTSAPP
RENTIRE
2048
0
20
0
TT


¶øÀÏʦ¸øµÄlaoshi.dmpµÄÍ·²¿ÐÅϢȴÊÇÒ»¶ÑÂÒÂ룬ÉõÖÁ²»Äܸ´ÖƵ½ÕâÀï¡£ÇëÎÊ£¬ÎÒÔõô²ÅÄܳɹ¦µÄµ¼ÈëÀÏʦ¸øµÄlaoshi.dmpÎļþÄØ£¿ÁíÍ⣬ÒòΪÁªÏµ²»·½±ã£¬ÀÏʦÊDz»ÄÜÁªÏµµÄ£¬Çë´Í½Ì£¡
ÔÚJAVAÉèÖÃÖл¹Ô­Óï¾ä

ÒýÓÃ
ÔÚJAVAÉèÖÃÖл¹Ô­Óï¾ä

ÔõÃ´ÅªÄØ£¿

ÕÒÀÏʦҪһ·Ýµ¼³öΪsqlÎļþÀàÐ͵ÄÊý¾Ý¿â

ÒýÓÃ
ÕÒÀÏʦҪһ·Ýµ¼³öΪsqlÎļþÀàÐ͵ÄÊý¾Ý¿â

ÒѾ­·¢ÁËÓʼþ¼¸ÌìÁË£¬µ«ÊÇÀÏʦ¶¼Ã»ÓлØÓ¦£¬ËùÒÔÕâ¸öÓ¦¸ÃÊDz»ÐÐÁË

ÐèҪȷÈÏÊý¾Ý¿âµÄÀàÐÍ¡¢°æ±¾

ÒýÓÃ
ÐèҪȷÈÏÊý¾Ý¿âµÄÀàÐÍ¡¢°æ±¾

ÀÏʦµÄÊÇ£ºserver2003£¬oracle10g
ÎÒµÄÊÇ£ºxp£¬oracle10g

·þÎñÆ÷°æ±¾ÎÊÌ⡣·¹ý¡£

лл¸÷룬ÊÇ×Ö·û¼¯ÎÊÌâ¡£°Ñн¨µÄÊý¾Ý¿âµÄ×Ö·û¼¯¸Ä³ÉºÍdm


Ïà¹ØÎÊ´ð£º

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

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

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

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 ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ