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

oracle database link

Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈ
ÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£ 
1¡¢   Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·£¬·þÎñÃûȡΪ½«À´ÄãҪʹÓõÄÊý¾Ý¿âÁ´Ãû£º
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁ
SQL>create public database link beijing connect to scott identified by tiger
         using 'tobeijing';
Ôò´´½¨ÁËÒ»¸öÒÔscottÓû§ºÍ±±¾©Êý¾Ý¿âµÄÁ´½Óbeijing£¬ÎÒÃDzéѯ±±¾©µÄscottÊý¾Ý:
SQL>select * from emp@beijing;
ÕâÑù¾Í¿ÉÒÔ°ÑÉîÛںͱ±¾©scottÓû§µÄÊý¾Ý×ö³ÉÒ»¸öÕûÌåÀ´´¦Àí¡£
3¡¢½¨Á¢Í¬Òå´Ê£¬ÎªÁËʹÓйطֲ¼Ê½²Ù×÷¸ü͸Ã÷£¬ORACLEÊý¾Ý¿âÀïÓÐͬÒå´ÊµÄ¶ÔÏósynonym
SQL>create synonym bjscottemp for emp@beijing;
ÓÚÊǾͿÉÒÔÓÃbjscottempÀ´Ìæ´ú´ø@·ûºÅµÄ·Ö²¼Ê½Á´½Ó²Ù×÷emp@beijing¡£
4¡¢²é¿´ËùÓеÄÊý¾Ý¿âÁ´½Ó£¬½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁ
SQL>select owner,object_name from dba_objects where object_type='DATABASE LINK';
¸ÕºÃÓõ½, È¡Ïûdblink
3¡¢²é¿´Êý¾Ý¿âÁ¬½Ó
sql> select owner, db_link from dba_db_links;
ower db_link
public TEST.US.ORACLE.COM
4¡¢É¾³ýÊý¾Ý¿âÁ¬½Ó
ÏÈ´ÓµÚÈý²½Öв鿴Êý¾Ý¿âÁ¬½Ó£¬È¡µÃÆädb_linkµÄÃû³Æ
sql>drop public database link TEST.US.ORACLE.COM
Êý¾Ý¿âÁ¬½ÓËȶªÆú
±ÈÈ磺ÔÚÒ»¸öÊý¾Ý¿âBÖзÃÎÊÊý¾Ý¿âAÖÐµÄ±í£º
1.ÔÚÊý¾Ý¿âBÖд´½¨Êý¾Ý¿âÁ´£º
CREATE PUBLIC DATABASE LINK Êý¾Ý¿âÁ´½ÓÃû CONNECT TO Óû§Ãû identified by ÃÜÂë using 'Á¬½Ó˵Ã÷'
ÆäÖУ¬Á¬½Ó˵Ã÷±ØÐëΪÈçϸñʽ£º
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.10.201)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME=ORCL)
)
)
2.·ÃÎÊÁ´½ÓÊý¾Ý¿âÖеĶÔÏóµÄÓï·¨£º
Óû§Ãû.Êý¾Ý¿â¶ÔÏó@Êý¾Ý¿âÁ´½ÓÃû
3.²é¿´ËùÓеÄÊý¾Ý¿âÁ´½Ó£º
select owner,object_name from dba_objects where object_type='DATABASE LINK';
4.Àý×Ó£º
´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó£º
CREATE PUBLIC DATABASE LINK DBL_ORCL CONNECT TO province identified by province_pwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.10.201)(PORT = 1521))
)
(CON


Ïà¹ØÎĵµ£º

oracleѧϰ±Ê¼Ç——ÊÓͼ


1.ÊÓͼ£¨VIEW£©
1.1 ¸ÅÄî
       ÊÓͼ-----ÊÇÓÉSELECT²éѯÓï¾ä(¿ÉÒÔÊǵ¥±í»òÕ߶à±í²éѯ)¶¨ÒåµÄÒ»¸ö"Âß¼­±í",Ö»Óж¨Òå¶øÎÞÊý¾Ý,ÊÇÒ»¸ö"Ðé±í". ÔÚ´´½¨ÊÓͼʱ,Ö»Êǽ«ÊÓͼµÄ¶¨ÒåÐÅÏ¢±£´æÔÚÊý¾Ý×ÖµäÖÐ, ¶ø²¢²»½«Êµ¼ÊµÄÊý¾Ý¸´ÖƵ½Èκεط½, ¼´²»ÐèÒªÔÚ±í¿Õ¼äÖÐΪÊÓͼ·ÖÅä´æ´¢¿Õ¼ä. ÊÓͼÊDz鿴º ......

oracle 9i/10g°²×°°üºÍPATCHÏÂÔصØÖ·»ã×Ü

oracle 9i/10g°²×°°üºÍPATCHÏÂÔصØÖ·»ã×Ü
°ÑÏÂÃæµÄµØÖ·¸´ÖƵ½Ñ¶À×Àï¾Í¿ÉÒÔÏÂÔØ.
---------------------------------------------------------------------------------------------------
ORACLE 9i
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç6

Ëø
²éѯÆäËûÓû§µÄ±í <Óû§Ãû.±íÃû>
Ëø¶¨Ä£Ê½£º
Ðм¶Ëø
Ðб»ÅÅËûÐÔËø¶¨
ÔÚijÐеÄËø±»ÊÍ·Å֮ǰ£¬ÆäËûÓû§²»ÄÜÐ޸ĴËÐÐ
ʹÓÃcommit rollbackÃüÁîÊÍ·ÅËø
»ñÈ¡Ðм¶Ëø
ʹÓÃinsert¡¢updateÓï¾ä£¬×Ô¶¯ÉÏÐм¶Ëø
ʹÓÃselect...for update [of ÁÐÃû] Óï¾ä×Ô¶¯»ñÈ¡Ðм¶Ëø
ÔÚ±íµÄÒ»Ðлò¶àÐзÅÖÃÅÅËûËø£¬ÓÃÓÚ·ÀÖÎÆäË ......

OracleÓëAIXµÄ½ÇÉ«

1.2.1  OracleÓëAIXµÄ½ÇÉ«
OracleÔËÐÐÔÚAIXÉÏ£¬Ìṩ×ÅÊý¾ÝµÄ´æ´¢ºÍ¹ÜÀí·þÎñ¡£Êý¾Ý¼´ÐÅÏ¢£¬OracleÊý¾Ý¿â¾ÍÊÇÓ¦ÓÃϵͳÖд洢Êý¾ÝÐÅÏ¢µÄÒ»¸ö¼¯Öд洢λÖá¢Ò»ÖÖ´æÈ¡·½·¨µÄÉÌÆ·»¯ÊµÏÖ¡£AIXÊdzÐÔØOracleÔËÐеĵײãƽ̨£¬½øÐÐ×ÅCPUµ÷¶È¡¢ÄÚ´æµ÷¶È¡¢´æ´¢¹ÜÀí¡¢Îļþ¹ÜÀí¡¢ÍøÂçÇý¶¯µÈϵͳÔËÐкÍά»¤¹¤×÷¡£
×÷Ϊ¶ÔÓ¦ÓÃϵͳµÄÖ§ ......

Oracle 11g R1 for Linux(RHEL5)°²×°

1 ¡¢°²×°Ç°µÄ×¼±¸
1.1 ¼ì²éÓ²¼þ
ÎïÀíÄڴ棺 # grep MemTotal /proc/meminfo
½»»»¿Õ¼ä£º # grep SwapTotal /proc/meminfo
½»»»¿Õ¼äµÄ´óСÊǸù¾ÝÎïÀíÄÚ´æµÄ´óСÀ´ÉèÖõģ¬ÎïÀíÄÚ´æÉÙÓÚ 2G µÄÔò½»»»¿Õ¼äÉèΪÎïÀíÄÚ´æµÄÁ½±¶£¬ÎïÀíÄÚ´æ´óÓÚ 2G µÄÔò½»»»¿Õ¼äºÍÎïÀíÄÚ´æ´óСһÑù¡£Èç¹û²»·ûºÏÉÏÊö¹æ¶¨£¬ÄÇô¾ÍÐèÒªÖØÐÂÉèÖý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ