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

oracleÁ½¸öÊý¾Ý¿âµÄͬ²½£¿ - Oracle / »ù´¡ºÍ¹ÜÀí

ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿


ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓÃJob ¶¨Ê±Ö´ÐоͿÉÒÔÁË¡£ 

Á½¸öÊý¾Ý¿â¼äÓÃdblink·ÃÎÊ¡£



------------------------------------------------------------------------------ 
Blog£º http://blog.csdn.net/tianlesoftware 
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net 
Ïà¹ØÊÓƵ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx 
DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977

ÒýÓÃ
´´½¨Ò»¸ödblinkµ½A,
ÔÚBʱ´´½¨Ò»¸öjob£¬¶¨Ê±°ÑÐÂÔöÊý¾ÝÍùAÖвåÈë¼´¿É¡£×îºÃÓÐÒ»¸öʱ¼ä´Á¼ÇÔØÊÇ·ñΪÐÂÔöÊý¾Ý¡£


iihero£¬ ÉýÐÇÁË£¬Òª×£ºØÏ°¡..

ÒýÓÃ
ÒýÓà 1 Â¥ iihero µÄ»Ø¸´:
´´½¨Ò»¸ödblinkµ½A,
ÔÚBʱ´´½¨Ò»¸öjob£¬¶¨Ê±°ÑÐÂÔöÊý¾ÝÍùAÖвåÈë¼´¿É¡£×îºÃÓÐÒ»¸öʱ¼ä´Á¼ÇÔØÊÇ·ñΪÐÂÔöÊý¾Ý¡£


iihero£¬ ÉýÐÇÁË£¬Òª×£ºØÏ°¡..

ÊǸÃÇì×£Ò»ÏÂÁË£¡

ÒýÓÃ
´´½¨Ò»¸ödblinkµ½A,
ÔÚBʱ´´½¨Ò»¸öjob£¬¶¨Ê±°ÑÐÂÔöÊý¾ÝÍùAÖвåÈë¼´¿É¡£×îºÃÓÐÒ»¸öʱ¼ä´Á¼ÇÔØÊÇ·ñΪÐÂÔöÊý¾Ý¡£

ÔõÑù´´½¨dblink£¬job,ʱ¼ä´Á?
ÎÒÊǵÚÒ»´Î½Ó´¥µ½oracle£¬Âé·³ÄܾßÌåµãÂð£¿

Â¥Ö÷£¬Äã°´ÄǼ¸¸ö¹Ø¼ü×ÖÔÙËÑË÷Ò»ÏÂÁË¡£ÄãÈÃÈ˼ҸøÄãд³öÀ´¡£Ä㿽±´Ò»Ï£¬Ï´μûÁËÕÕÑù²»»á¡£¡£¡£¡£


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

ллÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓƵ£¬¸ú×ÅÊÓƵÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......

oracle ÈçºÎµ÷ÓÃmssql´æ´¢¹ý³Ì - Oracle / ¸ß¼¶¼¼Êõ

oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ