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

Oracle ÔÚwindowÏÂ×Ô¶¯±¸·Ý

£±¡¢È·¶¨ÄãµÄ¼ÆËã»úÉÏ×°ÓÐoracleµÄ¿Í»§¶Ë£¬Èç¹ûûÓУ¬Çë°²×°oracle¿Í»§¶Ë
£²¡¢È·¶¨ÓÐÄãµÄoracle·þÎñÀïÓÐÄãÒªÐèÒª±¸·ÝµÄÊý¾Ý¿âµÄ·þÎñÃû¡£
£³¡¢ÖÆ×÷Ò»¸öÅú´¦ÀíÎļþ£¨oracleBackup.bat£©£¬¾ßÌå·½·¨£º´ò¿ª“¼Çʱ¾”£¬±£´æÎªoracleBackup.bat£¬
¡¡¡¡´Ëʱ±£´æµÄÎļþÀàÐÍÑ¡ÔñΪ“ËùÓÐÎļþ”¡£Îҵı£´æÄ¿Â¼Îª£ºd:\oracleBackup.bat¡£oracle¿Í»§¶Ë°²×°
¡¡¡¡ÔÚd:\oracleĿ¼Ï¡£
£´¡¢ÓÒ¼üµã»÷´ËÎļþ£¨oracleBackup.bat£©£¬Ñ¡Ôñ“±à¼­”£¬½øÈë±à¼­×´Ì¬£º
     D:
del /q \ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day3
copy \ÒµÎñÊý¾Ý±¸·Ý\gzdb\backup\day2\*.*  \ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day3
del /q \ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day2
copy \ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day1\*.*  \ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day2
del /q \ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day1                    
copy \ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day0\*.*  \ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day1
del /q \ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day0
exp gymz/gymz@myoracle log=gymz_exp%DATE:~4,10%.log file=\ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\day0\gymz_backup%DATE:~4,10%.dmp owner=gymz
  
¡¡¡¡a¡¢cd oracle\ora92\bin        //½øÈëexpÃüÁîµÄĿ¼ÏÂÃæ¡£
¡¡¡¡b¡¢exp gymz/gymz@myoracle file=d:/%DATE:~4,10%.dmp log=d:/%DATE:~4,10%.log
          //%DATE:~4,10%´ú±íȡϵͳÈÕÆÚ£¨windowsϵͳdocÃüÁ£¬ÀýÈ磺2005-12-01¡£ÓÃÈÕÆÚÀ´
¡¡¡¡¡¡×÷Ϊ±¸·ÝµÄÊý¾ÝÎļþÃûºÍÈÕÖ¾Ãû£¬ÓÃÀ´±£Ö¤ÎļþÃû²»Öظ´¡£ÒÔÉϱ¸·ÝÎļþÎÒ±£´æÔÚd£ºÏÂÃæ£¬±£´æ
¡¡¡¡¡¡Ä¿Â¼×Ô¼ºÉèÖá£
¡¡¡¡c¡¢±£´æÎļþ¡£
£µ¡¢ÔÚwindows¼Æ»®ÈÎÎñ£¨¿ªÊ¼£­³ÌÐò£­¸½¼þ£­ÏµÍ³¹¤¾ß£­ÈÎÎñ¼Æ»®£©ÖÐÌí¼ÓÈÎÎñ¼Æ»®£¬Ñ¡Ôñ“ÈÎÎñ¼Æ
¡¡¡¡»®”ʱ£¬µã»÷“ä¯ÀÀ”£¬Ñ¡Ôñ×Ô¼ºµÄ¼Æ»®£¨¼´oracleBackup.batÎļþ£©£¬È·¶¨¾ÍÐÐÁË¡£ÒÔÏÂÉèÖøù¾Ý×Ô
¡¡¡¡ÐèÒªÉèÖþÍÐÐÁË¡£
   н¨·½Ê½(¶þ)£ºÔÚcmd ÖÐÔËÐÐн¨¼Æ»®  at 12:47 /every:W D:\ÒµÎñÊý¾Ý±¸·Ý\gymz\backup\backup.cmd £¨ÔÚÿ¸öÐÇÆÚÈýµÄ12£º   47¶¨Ê±Ö´ÐУ©
      


Ïà¹ØÎĵµ£º

Oracle Ê÷µÄÓ¦ÓÃ

ÎÊÌâÌá³ö£º
Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ
¼ÙÉèÓÐÒ»ÕÅ±í£¬ÓÐÕâÑùһЩÊý¾Ý
a b
1 2
0 2
2 3
3 4

5 6
6 7
12 7

aÊÇ×Ó½Úµã bÊǸ¸½Úµã ,Èç¹ûbΪnull ÔòΪһ¿ÃÊ÷µÄ¸ù½Úµã
¸ù¾ÝAÓëBµÄÕâ¸ö¹ØÏµ ÕÒ³öÒ»¿ÃÊ÷µÄ½á¹¹ÏÔʾ³öÀ´ £¬²¢ÏÔʾ³öÿ¸ö½ÚµãÔÚÊéÖеIJ㼶£¬½«Ê÷µÄ½á¹¹´ò ......

ÈçºÎÔÚoracleÖе¼ÈëdmpÊý¾Ý¿âÎļþ


OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£
ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
¡¡¡¡Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS(ÃüÁîÐÐ)ÖÐÖ´ÐУ¬DOSÖ ......

¹ØÓÚoracleµÄһЩÔÓÆßÔӰ˵IJÙ×÷

1¡¢¸ü¸Ä±íÃû/ÁÐÃû
Ê×ÏÈ£¬ÒªÒÔsysdbaÉí·ÝµÇ¼£¬²ÅÄܶԱíÃû/ÁÐÃû½øÐиü¸Ä£º
(1)µÇ½sqlplus£¬¿ÉÒÔÒÔnolog·½Ê½µÇ½£¬¹ØÓÚÕâÖֵǽ·½·¨£¬¿ÉÔÚsqlplusµÄͼ±êÉÏÓÒ¼ü£¬µã»÷ÊôÐÔ£¬ÔÚ"Ä¿±ê"À¸¸ÄΪ£º"D:\oracle\product\10.2.0\client_1\BIN\sqlplusw.exe /nolog"£¬È»ºóÔÙË«»÷sqlplusͼ±ê¾Í¿É½øÈë¡£
ÓÐʱoracle²¢²»ÔÚ±¾µØµçÄÔÉÏ£¬µ ......

oracleµÄ»ù±¾ÖªÊ¶

Oracle
    SqlServer2000 2005
 MySql      
 DB2
 ORACLE   sun  SUN
 
 Êý¾Ý¿â  DataBase  db
    ´æ´¢Êý¾Ý
 Êý¾Ý Data
        Êý×Ö   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ